Our Financial Data JSON API is easily integrated into Google Sheets, and there are several ways to do it. Below we describe all currently available solutions.
EOD Historical Data
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:
You will get one value – the last price for MCD.
The ‘WEBSERVICE’ function for Excel is also supported.
Another option is the integration with Apipheny Google Sheets service. It’s a very fast, flexible and not too expensive API used to import financial data into Google Sheets and automate your data pulls without breaking the bank. For this integration, an Apipheny subscription is required, however their prices are relatively low.
Complete documentation about integrating our Financial APIs with Google Sheets and Apipheny can be found here: https://apipheny.io/eod-historical-data-api/.
We also have integration with Cryptosheets, a great service with dozens of integrations with different APIs both with Google Sheets and Excel. All our APIs are integrated there, the service is flexible and very easy to use. For this integration, a Cryptosheets subscription is required.
Complete documentation about integrating our Financial APIs with Google Sheets and Cryptosheets can be found here: https://docs.cryptosheets.com/providers/eod-historical-data/.
Please let us know if you need more integrations with other services or better support for Google Sheets via email@example.com.