If you are not a developer but still need instant access to data and tools such as historical financial data (with charts), real-time data, fundamental data, screener functionality, and various technical indicators, we recommend trying our Google Sheets & Excel spreadsheet add-ons. With these add-ons, financial data for stocks, ETFs, mutual funds, and global exchanges is now available on any device without coding.
Let’s see how we can extract data about stocks and financial assets via our Google Sheets add-on. We also recommend checking our API documentation for the best investment analysis integration 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.
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:
4. If the right sidebar is not visible, click the arrow in the bottom-right corner:
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:
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.
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.
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.
Install Financial Data Free Add-on for Google Sheets
