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 | |
---|---|---|---|---|
BAR api with OAuth Token? | 1 | 419 | July 22, 2020 | |
How to do multi-symbol market data request | 8 | 3163 | March 1, 2022 | |
Alpaca Data API - API for Free Real-Time Stock Market Data | 7 | 5545 | August 18, 2022 | |
Cannot fetch bars | 6 | 214 | May 28, 2024 | |
How can I retreive stock price in simplest way possible? | 2 | 559 | April 25, 2024 |