Excel VBA Stock API

If you are not familiar with any programming languages, we have several Excel examples to help you download data with our API. Excel examples work both for end-of-day prices and fundamental data.

Excel 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 charts 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

Add tickers you want to download the data for

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:

Get Fundamental Data directly to the Excel

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.

Register & Get Data

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://eodhistoricaldata.com/api/real-time/AAPL.US?api_token=OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX&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://eodhistoricaldata.com/api/real-time/AAPL.US?api_token=OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX&fmt=json&filter=close)

Register & Get Data

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