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.
