The Google Sheets Add-in is an easy-to-use plugin that doesn’t require any coding knowledge from the user, one of our no-coding solutions for obtaining data.
Installing the Financial Add-In
Before we proceed with fetching the EOD data, we need to install the Add-in from Google Marketplace.
After installation, please refresh the page of your Google sheets, and you will see the Add-in button on the applications panel to the right:
API Key Configuration
Click the button, and the first thing you’ll need to do is enter your API key in the designated field. If you don’t have an API key yet, you can register and obtain it by following the “Register” link (please note, the free API key has a limited functionality, see the pricing page for more details). For testing purposes you can also use the ‘demo’ API key which works for the tickers AAPL.US, AMZN.US, TSLA.US, MSFT.US, EURUSD.FOREX, BTC-USD.CC.
Retrieving EOD Historical Data
After entering the API key, you need to click the “GET DATA” button, and you’ll be taken to the main Add-in interface. Finally, to obtain EOD prices, you need to select “End-Of-Day Historical Stock”, enter the required ticker, choose output period (daily, weekly, monthly), and set the time interval. You can also check the box to get the chart along with the data. Then click the GET button, and you’re done!
Please note, that OHLC data with this Add-in is provided raw, adjusted neither to splits nor to dividends, while adjusted closes are adjusted to both splits and dividends, and volume is adjusted to splits.