This Office 365 Web Add-in provides functions to download Alpha Vantage market data directly into a spreadsheet. There is also a simple taskpane interface to help in setting up the functions. The Add-in is completely free of charge.
This Add-in requires a current subscription to Office 365. It should work on Windows desktop, Mac desktop and browser versions of Office 365. Currently functionality requires that you are using the Office Monthly channel to return data as dynamic arrays.
The following are the minimum Office versions required to run this Add-in:
Version 1911 (Build 12228.20332)
Office 365 Monthly Update Channel for Windows Release Notes
Version 16.32 (Build 19120802)
Office 365 Monthly Update Channel for Macintosh Release Notes
Minimum version unknown. Tested on Build 16.0.12512.31876
The current Office 365 Web Add-in (Office.js) interface is still missing a few features that would make this a more functional and stable product. Until enhanced error handling is added to the Monthly channel version of Office.js custom functions there is no way to return useful error information from the function.
On a Windows machine there are a couple ways to set the channel. Not as simple as it should be.
Switch Office 2016 to Monthly Targeted Channel
Switching to the Office 365 Monthly Update Channel
On a Mac OSX machine you can set the channel in the Microsoft AutoUpdate application. Insider/Slow is the same as Monthly.
We are releasing an Add-in at this point because there is enough functionality to make this API interesting. We have also implemented streaming functions for real-time data that update automatically. We hope you will enjoy this software and we welcome feedback (email@example.com)
The Office 365 web Add-ins cannot be directly downloaded. The Add-in must be downloaded directly from Microsoft using an account with an active Office 365 subscription.
To download the Add-in from either a desktop or browser based version of Excel go to the Insert ribbon interface. On a desktop version of Excel this should look something like
In the browser version of Excel this should look something like
This will bring up an online store run by Microsoft. You can search for "Alpha Vantage" and install the Add-in from there.
After installation you should see a ribbon tab named Alpha Vantage(Web) added to Excel.
The actual ribbon will look like
In order to use this Add-in you will need a valid Alpha Vantage API key. You can request one here if you don't already have one. On the Alpha Vantage(Web) ribbon tab select either the Info or Tasks button on the left. This will open a taskpane on your page. Scroll to the bottom of the pane and find the text box to update your API key at the botton. If you have previously entered your API key you should see it here.
The spreadsheet functions include Intellisense and the namespace for this Add-in is AlphaVantage.
There is also some help for the function arguments as well.
Clicking the Tasks button on the Alpha Vantage(Web) ribbon tab will bring up a taskpane with some useful functionality.
This inserts validation into the currently selected cell to ensure a valid value. Also creates a dropdown in the cell for the user to choose from.
This sets the default for the outputsize when it is not explicitly specified in a formula. "Compact" will return only the 100 latest points and "Full" will return all known points in the series
If an API key has been previously entered it will be displayed here. Typing or copying an API key into this field and pressing "Update" will cause that API key to be set for this installation
Alpha Vantage calculates over 50 technical indicators on equity data. If you click the Indicators button on the Alpha Vantage(Web) ribbon tab it will open a taskpane that can help you input the various parameters to the indicator calculations
First we select an indicator
One indicator with a number of possible parameters is STOCH(stochastic oscillator). If we click the button "Insert STOCH Arguments" the parameters for the STOCH calculation will be written to the range starting with the currently selected cell in the spreadsheet. Where default values exist they are inserted as well. In addition validation rules are set to ensure only valid values of the parameters are entered.
If you click the Symbol Search button on the Alpha Vantage(Web) ribbon tab it will open a taskpane that allows a limited interactive search for symbols
If you click the Help button on the Alpha Vantage(Web) ribbon tab it will open a taskpane with links to help on the spreadsheet Add-in as well as documentation of the Alpha Vantage api.