In this post I will share a quick way for Amibroker users to update quotes using split and dividend back adjusted data from a fairly new provider, Tiingo.com. Although we do run our investment strategies on our very own QuantTrader, we use various other tools to analyse markets, including Amibroker.
The problem: Where to download dividend adjusted data
Many Amibroker users build strategies that rely on dividend adjusted historical data. At this moment it is difficult to find similar data since Yahoo, as well as many other sources, do not back-adjust prices to include dividends. A solution is to use free (or rather donation-based) EOD data from Tiingo.com.
What happened to the free Yahoo finance historical data?
Yahoo! finance has changed their Yahoo Finance API and the way the data is delivered. This has disrupted the workflow of many self-directed investors that use Excel or Google sheets to track their holdings. It has also created problems for users of financial software that use Yahoo’s service.
The service has not been discontinued. Rather, it has been changed. You can still retrieve stock, ETF, mutual funds and currency historical data. From what we can see so far, the data is in json format, adjusted for splits but not for dividends, although the dividend information is provided in the data and can be retrieved (as of 6/3/2017).
If you use Amibroker, you can use the updated Amiquote to retrieve data using the new Yahoo API. It will not be dividend-adjusted (just try to download a bond ETF like “TLT”). If you want to continue an existing workflow of dividend-adjusted data, you can try this solution.
You will need:
- A free account at Tiingo.com to get a Token #
- A way to run the following Python script.
Tingo API docs for daily prices: https://api.tiingo.com/docs/tiingo/daily