Alpha Vantage Google Sheets Add-on Documentation


Visit our website to learn about other Alpha Vantage products

Release Notes


There are two ways to get the Add-on:

G Suite Marketplace Listing.

Function API

Spreadsheet Function Reference.

There is also function help within the spreadsheet

All Alpha Vantage functions begin with "AV..."

In Google Sheets you can't re-calc a spreadsheet manually. Why this is an issue and how to address it is described in the blog Implementing Re-Calc Strategies in Google Sheets.


Quick Tour of the Add-on Menu

The Add-on menu looks like



There is a function for viewing the Add-on documentation which is self-explanatory. The item "Insert Interval Validation" puts validation into the currently selected cell that restricts it to valid values. After running this function your cell will look like



when you select the triangle in the validated cell. This helps you restrict function inputs to valid arguments. The item "Insert Technical Indicator Function Validation" does something similar in the currently selected cell in that it requires a valid Technical Indicator to be used in that cell



If the menu item "Insert Technical Indicator Arguments" is clicked while the currently selected cell is blank it will set up a range with every possible argument from every possible Indicator (these arguments are ignored if they don't apply to that technical indicator)



Arguments are filled with their default values where available.

If the cell that is selected when the menu item is clicked contains a valid Technical Indicator function only arguments for that function will be returned


More information on the arguments for each Indicator can be found at


For general guidance on working with financial market data, please refer to Best Stock APIs and Industry Landscape in 2020