Efrem Sternbach
Sep 6 · 2 min read

The Alpha Vantage Google Sheets Add-on can be installed for an individual through the Chrome Store. The quickest way is to open a new spreadsheet and under the Add-ons menu choose “Get add-ons.”

This will bring you to the Chrome Store. Search for “Alpha Vantage” and you should find an Add-on named “Alpha Vantage Market Data.”

Click the “+ FREE” button to install the Add-on. Google will request that you approve permissions necessary for the Add-on to function. This will look like

Please click “Allow” to enable the Add-on. The add-on requires 3 types of permissions.

  • Access to the Spreadsheet API to allow the Add-on to modify spreadsheets
  • Enable user interface features like menus, dialogs and alerts
  • Enable the script to call out to alphavantage.co (external service) to return market data

If successful you should see:

Refresh your browser window if necessary to make sure the Add-on menu is initialized. Then enter your API Key using the Add-on menu

which will open a dialog where you can enter your API Key.

That’s it! You’re ready to go!

NOTE: One of the great things about Google Sheets is the ability to share with others. However, please be aware that if you share your spreadsheet with someone you may expose your API Key to them. Additionally, any invocations of the spreadsheet will count against your data limits. Please only share your spreadsheets within your organization or with trusted individuals.

Alpha Vantage

Accessible and easy to use APIs for financial market data

Efrem Sternbach

Written by

Alpha Vantage

Accessible and easy to use APIs for financial market data

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade