# Any known bugs with Yahoo Finance adjusted close data ?

Yahoo Finance allows you to download tables of their daily historical stock price data.

The data includes an adjusted closing price that I thought I might use to calculate daily log returns as a first step to other kinds of analyses.

To calculate the adj. close you need to know all the splits and dividends, and ex-div and ex-split dates. If someone gets this wrong it should create some anomalous returns on the false vs. true ex dates.

Has anyone seen any major problems in the adj. closing price data on Yahoo Finance?

-
Based on a quick check of some edge cases (stocks I hold and know, or stocks that have changed exchanges), it looks reasonably decent. –  Tangurena Apr 24 '11 at 6:09
What about bloomberg? Have anyone found errors? –  DBS Jan 2 '12 at 20:38

Yahoo rounds the adjusted price to 2 decimals even though dividend amounts often have 3 decimal places. Since they apply the adjustment formula to adjusted prices, if you go far enough back in time, the value they give for Adjusted Price will be different than it would be if there were no rounding.

edit: For example, for C (Citigroup), on January 2, 1990, Yahoo gives a close value of 29.37 and an Adjusted value of 1.50. Using the dividend data that Yahoo supplies, if they didn't round to cents on every adjustment, the adjusted value would be 1.677.

-
The quantmod function adjustOHLC() can calculate correct adjust prices, using dividend and adjustment data from yahoo. –  Zach Jul 12 '11 at 16:29

Do not passively use Yahoo where you need reliable historical data; it will just fail at one point (from what I have seen due to corporate actions/dividends not properly implemented). Paying for a single alternative data source will not save you either (Bloomberg sometimes reports crazy intraday prices); the only way is to write some data cleaning routines (that will warn you if something strange happens), and to compare what several different providers say.

Welcome to the prehistory!

-
Some story with Thomson. I helped them clean up lots of data. Glad we were paying for the privilege. –  Steve Aug 9 '11 at 21:33
I've been more recently dealing with Yahoo data issues on this question. Seems Erwin is correct in his summary - you can't trust any one source implicitly! –  Marcus Feb 6 at 7:25

Yahoo's historical data is sometimes missing dividends. For example: http://finance.yahoo.com/q/hp?s=VWINX&a=00&b=1&c=2010&d=11&e=20&f=2011&g=v (VWINX) is missing two dividends for 2011, though it has the ones for 2010.

Also, this paper: http://arxiv.org/PS_cache/arxiv/pdf/1105/1105.2956v1.pdf from 2010 reports Yahoo finance as missing a dividend in the 2007 data.

-

Yahoo data is not as clean as alternative data providers such as CSI. Some issues are: i) data for some tickers is missing, ii) incorrect data (rare but it does happen), iii) sometimes they fail to merge the price histories of firms that undergoe corporate actions (i.e. merger, acquisition, or changes in corporate headquarters).

-
my experience is that it beats by far the data quality found in many banks, including very reputed ones.. –  nicolas Jul 9 '11 at 17:26
@nicolas I agree –  silencer Jun 29 '12 at 23:18
$$\log{\frac{adj.close(t)}{adj.close(t-1)}}$$
$$\log{\frac{derived.actual.close(t)}{derived.actual.close(t-1)}}$$