Back to APIs list![stevekrouse avatar](https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg)
US Congress Stock Trading API examples & templates
Use these vals as a playground to view and fork US Congress Stock Trading API examples and templates on Val Town. Run any example below or find templates that can be used as a pre-built solution.
![stevekrouse avatar](https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg)
stockPrice
@stevekrouse
HTTP
Current Stock Price This val was designed to be used in Google Sheets, particularly because Google Finance stopped supporting Spotify inexplicably. Usage 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 API 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