I have limited programming and API knowledge but have been using an API to get current stock prices into an excel spreadsheet using =webservice() and some text functions. The service I have been using is not available anymore and I found Alpaca when looking for an alternative but I cannot figure out how to include the API keys with the URL so I can pass the argument to the excel function. Does this API support single line URL or does the authentication have to be done programmatically? The only means I have found looking through the documentation to do similar uses VBA which I do not have access to on the computer I am wanting to run this .xlsx file on so I am just hoping I missed something. Thank you in advance.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Access Alpaca API from MS Automate | 0 | 344 | January 17, 2021 | |
| Get company URLs | 0 | 401 | May 12, 2020 | |
| How can I retreive stock price in simplest way possible? | 2 | 569 | April 25, 2024 | |
| Alpaca integration with XYZ | 0 | 540 | December 21, 2020 | |
| Show data to end-users | 0 | 401 | February 2, 2022 |