- 1 Excel Add-In for Fundamentals and End Of Day API with Charts
- 2 Downloader for End-Of-Day Stock API
- 3 Add-In for End-Of-Day 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
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.
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:
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:
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:
Then only one number will be returned: 172.5. Which is very useful for Excel WEBSERVICE function like this:
In case if you have more questions and need help, send us to email: email@example.com.