If you are not a developer but still need access to data and tools such as end-of-day historical stock prices (with charts), intraday data, fundamental data, screeners, various technical indicators and more, we recommend trying our Excel or Google Sheets add-ons. With these add-ons, financial data for stocks, ETFs, mutual funds, and FOREX markets is now available on any device without coding.
Let see how we can extract data about stocks and financial assets via Google Sheets add-on. We also recommend you to check our API documentation on our APIs endpoints which are the best to retrieve the data right into your code if you are a developer.
Activate your API key
Though there is a demo mode in the add-on which gives an opportunity to get Fundamental & Live data for a few tickers, in order to use the add-on fully we recommend to sign up on our site. Registration is free and provides you with API Key which should be used in Google Sheets Add-on in order to get access to more data.
1. You can start with “DEMO” API key to test the data for a few tickers only: AAPL.US, TSLA.US , VTI.US, AMZN.US, BTC-USD and EUR-USD. For these tickers, all of our types of data (APIs), including Real-Time Data, are available without limitations.
2. Register for the free plan to receive your API key (limited to 20 API calls per day) with access to End-Of-Day Historical Stock Market Data API for any ticker, but within the past year only. Plus a List of tickers per Exchange is available.
3. We recommend to explore our plans, starting from $19.99, to access the necessary type of data without limitations.
Google Sheets Financial Data Add-on installation
The add-on is free and can be installed in a few clicks from Google Marketplace.
- Go to Google Workspace Marketplace and install the Financial Data add-on:
2. The add-on requeres minimum of permissions in order to be able to take financial data via API from our server and export it to your Google Sheets document:
3. After a successful installation, refresh the Google Sheets tab. You can find the add-on in the right sidebar menu or in the main Google Sheets menu under Extensions:
Note that if you can’t start the add-on from the Extensions menu -> Financial Data (you only see “Help” there), it is because our add-on requires permissions for each document it is added to. In this case, you can still open it from the right sidebar. If you don’t use the right sidebar, grant permissions for the add-on for this specific document. Here is how to do it:
4. By default, the demo key is applied, which only works with a few tickers. After signing up on eodhd.com, you will receive an API key that should be used instead of the ‘demo’ key:
How to get stock data in Google Sheets
Our add-on provides a formula-free workflow, meaning you don’t have to write formulas yourself. Simply choose the desired options, fill in the fields, and insert the data into a new sheet.
For example, here we retrieve EOD historical data with chart using add-on for AAPL.US:
Each request will import data by creating a new sheet in your project, ensuring that no existing data is lost or replaced.
Each request consumes API calls, which are limited for the account, and the amount depends on your plan. For example, the free plan allows only 20 API calls per day. You can see your current API call count in the add-on’s ‘Settings’ section or in your account dashboard on eodhd.com. Read more about our API call limit policy here.
Various types of data are available only under certain subscription plans. As you can see, the ‘demo’ plan has the most limitations and basically works with only a few tickers for each type of data:
For example, the free plan provides access to all tickers for EOD data but is limited in historical depth. Compare plans to see which one best fits your needs.
If you believe that you have limitations that do not apply properly to your plan, please contact our support team (chat icon in the lower right corner).
EOD Historical Data (IMPORTDATA function)
We support the ‘IMPORTDATA’ Google Sheet function. Just add ‘filter=last_close’ or ‘filter=last_volume’ with ‘fmt=json’, and you will get only one number which perfectly works with IMPORT functions for Google Sheets. This feature works for any End of Day or Fundamentals API request with the ‘filter’ parameter. For example, with this URL:
https://eodhd.com/api/eod/MCD.US?api_token=demo&fmt=json&filter=last_close
You will get one value – the last price for MCD.
The ‘WEBSERVICE’ function for Excel is also supported.
Apipheny
Another option is integrating with the Apipheny Google Sheets service. It’s a fast, flexible, and reasonably priced API used to import financial data into Google Sheets, allowing you to automate your data pulls without overspending. While an Apipheny subscription is required for this integration, their prices are relatively low.
You can find complete documentation on integrating our Financial APIs with Google Sheets and Apipheny here: https://apipheny.io/eod-historical-data-api/.
Cryptosheets
We also offer integration with Cryptosheets, a versatile service offering dozens of integrations with various APIs for both Google Sheets and Excel. All our APIs are seamlessly integrated there, and the service is flexible and user-friendly. A Cryptosheets subscription is required for this integration.
You can find comprehensive documentation on integrating our Financial APIs with Google Sheets and Cryptosheets here: https://docs.cryptosheets.com/providers/eod-historical-data/.
24/7 EODHD Support
If you found a bug or would like to suggest what other data could be integrated into our Google Sheets add-on, please contact our support team via chat on our main site or via email at support@eodhistoricaldata.com.
Enjoy the data!
