Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in miliseconds.
This val was designed to be used in Google Sheets, particularly because Google Finance stopped supporting Spotify inexplicably.
- Copy and paste this into Google Sheets:
=IMPORTDATA(CONCATENATE("https://stevekrouse-stockprice.web.val.run/?simple=1&symbol=","SPOT"))
- Replace "SPOT" with the symbol you want
This val currently uses Alpha Vantage's free plan (5 requests per minute & 500 per day).
You can sign up for your own API Key here: https://www.alphavantage.co/support/#api-key
Migrated from folder: External_APIs/AlphaVantage/stockPrice