Wednesday, June 7, 2017

Yahoo Finance Alternatives

I assume that you're reading this because you are one of many people who were affected by the changes to Yahoo Finance data in May (2017).  Not only did the URL change, but the actual data changed as well!

The most noticeable difference is that the adjusted close column is now only split-adjusted, whereas it used to be split- and dividend-adjusted.  Another oddity is that only the close prices is unadjusted (strangely, the open, high, and low are split-adjusted).

All these issues can be dealt with using tools that are currently available.  For example, you can unadjust the open, high, and low prices using the ratio of close to adjusted close prices.  And you can adjust for both splits and dividends using quantmod::adjustOHLC().

Unfortunately, there also appear to be issues with data quality.  Some instruments have rows where all the prices and volume are zeros (e.g. XLU).  The adjusted close in some instruments is incorrect because of missing split events, or double-counting splits and special dividends.

So, what are your alternatives?  If you're just tinkering, you can try other free data sources like Google Finance or Quandl.  Note that Google Finance data is already split-adjusted, so you might need to adjust for dividends, or un-adjust for splits, depending on your needs.  Quandl has a wiki of end-of-day stock prices curated by the community.  You only need a free account to access the data.

If you're using the data to make actual investment decisions, you should really be using a professional data provider.  At the very least, you get someone to yell at when the data have errors. :)  First, you should check if your broker provides the historical data you need (e.g. Interactive Brokers provides historical and real-time data to account-holders).

If your broker doesn't provide historical data, here are a few providers you may want to consider:

Tiingo
- Free historical end-of-day data (registration and API key required)
- Up to 50+ years of daily data (split and dividend adjusted) for over 65,000 equities, mutual funds, and ETFs
- Free historical and real-time crypto data (4+ year of daily prices, 2+ years of intraday data)
- Free historical and real-time intraday data from IEX, beginning in August 2017
- Available via getSymbols()

Alpha Vantage
- Free historical and intraday equity data (registration and API key required)
- Up to 20 years of daily data (split and dividend adjusted available)
- Up to 10 days of intraday data (1min, 5min, 15min, 30min, 60min)
- Available via getSymbols()

- Provide limited historical data for free
- For a one-time fee:
  - $20-$50 for 10 years of daily data
  - $40-$100 for 20 years of daily data

- Massive historical equity database
- $600 annually for 30 years of daily data
- Ability to adjust for splits and dividends

- Mainly a real-time data provider, but also has historical data
- Pricing, starts at $78/month

Leave a comment if you know of another end-of-day data provider that I didn't list!

*FULL DISCLOSURE: I receive a referral fee for annual subscriptions to CSI products if you use the FOSS coupon code.

8 comments:

Aastha said...

Thanks for sharing the info, keep up the good work going.... I really enjoyed exploring your site. good resource... www.qatarbusinesscouncil.org

Unknown said...

It’s my fortune to go to at this blog and realize out my required stuff that is also in the quality.
Poor Credit Mortgage

Thomas Joe said...

Excellent value driven article here. Tons of information. Appreciate it.
mortgage refinance in Toronto

DFC SEO said...

Excellent website! I adore how it is easy on my eyes it is. I am questioning how I might be notified whenever a new post has been made. Looking for more new updates. Have a great day! financial news for today

Rumi said...

One of the best places to find a high risk personal loan is online, and you can get an online loan from the comfort of your home. If you have a poor credit rating, it can be embarrassing to apply for a loan in person only to be turned down.

long term loan for poor credit

Mawazna.com said...

Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. car financing in pakistan - js bank car finance

ExcelSHE - Letters & Templates said...

Very good article and thanks for sharing such information. Already Read your Recent Post, its Great Thanks name tag | proof of residency | id card | immigration letter | open house sign in

Unknown said...

Awesome blog, very informative too. I really enjoyed this blog it helps me a lot awaiting for more post keep posting. Digital Marketing Central