Excel VBA Stock API

Excel VBA Stock API with Examples

Excel VBA Stock API Bulk Download Here you can find an Excel VBA script for multiple (bulk) downloads: vba-multiple-download.xlsm. It’s easy to test and use, you just need to do the following two things: Change the TEST API KEY to your own API KEY, since the test API Key will work only with AAPL.US Add stocks […]

Read More
Python Stock API Example

Python Stock API Example

A simple Python example was written for us by Femto Trader. There is a small example, more information you can find on GitHub, check python-eodhistoricaldata. import requests import pandas as pd from pandas.compat import StringIO def get_eod_data(symbol=”AAPL.US“, api_token=”OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX”, session=None): if session is None: session = requests.Session() url = “https://eodhistoricaldata.com/api/eod/%s” % symbol params = { “api_token”: […]

Read More
R-language Stock API Example

R Language Stock API Example

It’s very easy to use our API with R language, below you can find a very simple example with explanations for R developers. api.token <- “YOUR_API_KEY_HERE” symbol <- “AAPL.US” ticker.link <- paste(“http://eodhistoricaldata.com/api/eod/”, symbol, “?api_token=”, api.token, “&period=m&order=d”, sep=””) data <- read.csv(url(ticker.link)) head(data) For testing purposes you can use this API Key: api_token=OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX. Works with AAPL.US only. If you […]

Read More
MATLAB Stock API Example

MatLab Stock API Example

It’s easy to use our API with MatLab, below you can find a very simple example with explanations for MatLab users.     url = ‘http://eodhistoricaldata.com/api/table.csv?s=AAPL.US&api_token=YOUR_API_KEY_HERE&a=0&b=1&c=2000&d=5&e=16&f=2017&g=d’; [s,status] = urlread(url,’Timeout’,60); C = textscan(s, ‘%s%f%f%f%f%f%f’, ‘HeaderLines’, 1, ‘delimiter’, ‘,’, ‘CollectOutput’, 0); disp(C) For testing purposes you can use this API Key: api_token=OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX. Works with AAPL.US only. As you see, […]

Read More