If you are not familiar with any programming languages, one of the best ways to extract or export the data is a Excel Add-In for end-of-the-day (EOD), Intraday, and Fundamental Data APIs.

You can also check our comprehensive video instruction on How to Use our Financial Excel Add-In.

Register & Get Data

Excel Financial Add-In for Fundamentals and End Of Day API with Charts

We have created an Excel Add-In for easy downloading our End Of Day and Fundamental data directly into your Excel. You can download our Excel Add-In here. The Add-In includes downloading the data via End of day API with chart autogeneration, downloading the data via Fundamental API directly into your Excel file, and ticker search with autosuggestion via Search API. It’s easy to test and use, you just need to do the following actions:

Change the TEST API KEY to your API KEY

 

 

Click ‘Load’.

And get results directly to your Excel file (with charts)

The Add-In automatically downloads the data, adds adjusted OHLC, and creates the chart for each ticker:

 

Excel Add-In for Financial Fundamental, EOD and Intraday Data.

You can download our Excel Add-In here.

Downloader for End-Of-Day Stock API

Here you can find an Excel VBA script for multiple (or bulk) downloads: vba-multiple-download-new.xlsm. It’s easy to test and use, you need to do the following two things:

  • Change the TEST API KEY to your API KEY, since the test API Key will work only with AAPL.US
  • Add stocks you want to download.
Excel VBA Historical prices bulk download

 

That’s easy!

Add-In for End-Of-Day Stock API

We created an Excel VBA example that works with our API. You can easily download an example of XLS-file and read our instructions below. It’s effortless to use it:

VBA Example for downloading EOD Historical Data

 

For accessing our API, you can use our defined function “=EODSymbolData(Symbol, From_Date, To_Date).” It’s easy like you use other functions “=SUM(…)” or “=AVERAGE(…)”

If you open the file, you will need to change your API Key in the ‘config’ sheet. The current key works only with AAPL.US:

 

To see the code, please push ALT+F11 and open VBA Module ‘EODHistoricalData’ to check the VBA function:

Excel VBA Modules EOD Historical Data

 

Download our XLS-file example for getting EOD Historical Data via API and check the source to create your spreadsheet.

Also, if you are former Yahoo user, you can check our article on How to Migrate from Yahoo Finance API.

LIVE API Excel WEBSERVICE support

If you need only one field, any one field, use ‘filter=FIELDNAME’ parameter. For examples, if you use the following URL:

https://eodhd.com/api/real-time/AAPL.US?api_token=demo&fmt=json&filter=close

Then only one number will be returned: 172.5. Which is very useful for Excel WEBSERVICE function like this:

=WEBSERVICE(https://eodhd.com/api/real-time/AAPL.US?api_token=demo&fmt=json&filter=close)

In case if you have more questions and need help, send us to email: support@eodhistoricaldata.com.

Register & Get Data