Skip to main content

Understand Yahoo Finance Historical Data

I frequently visit Yahoo Finance website. The reason is that it provides almot complete historical stock data for which I use to build financial models. In order to use the right data, I need to kwno the "Close price adjusted for splits" and "Adjusted close price adjusted for splits and dividend and/or capital gain distributions" that Yahoo Finance presents.

Close price adjusted for splits

If I would to use the historical prices that Yahoo Finance provides, I could choose this column of data. But what does this mean?

Theoretically, if stock splite, it price should go down so that the total capital of the company remains the same.

I search the company Tesla. It had a 5 for 1 stock split on Aug 31, 2020, which means the stock price should be cut to 1 fifth. And what I have found was that Yahoo Finance would adjust the price so just if the stock split has never happeed.

Adjusted close price adjusted for splits and dividend and/or capital gain distributions

Now, let's take a look at the second to the last column of data which is adjusted for both stock split and dividends.

I search SPY for answers.

What this column means is that if you use this column of data, you don't need to calculate the reinvesment of dividends as if the stock does not pay out any dividends.

Proof?

To quench my urge to continue looking for answer for the what "Adjusted close price adjusted for splits and dividend and/or capital gain distributions" means, I build an app to test if the data set with no adjustment for dividend but with reinvestment would have the same result if I use the one with adjustment.
Click on run, the system will pick a random date and compare for the result.

Conclusion

After playing with my own app, I am happy with the result that the adjusted closed prices at the 5th column provdided by Yahoo Finance already take care of dividends so I can use these date without doing the dividend reinvestment calculation.
Labels:

Comments

Post a Comment

Popular posts from this blog

Which is better? BND or AGG?

The US 10-year treasury yield has reached at 2007-2008 years level, which is about 16 years ago. From a technical point of view, it is a buy. Then there are 2 bond ETFs that I am interested in. There are BND and AGG. They are very similar in nature. US 10 year Treasury Bond, chart, prices - FT.com Expense Ratio BND: 0.03% AGG: 0.03% The same. Turnover Rate BND: 40.00% AGG: 104.0% BNG seems better. Historical Performance Comparison Investment duration: 5 years with no tax on dividends BND wins a little with winning rate of 57.5%, but AGG wins 0.012% in return. Investment duration: 5 years with 30% tax on dividends AGG wins a little with winning rate of 65% and a 0.079% difference on average. Investment duration: 10 years with no tax on dividends AGG wins a little with winning rate of 67% and a 0.024% difference on average. Investment duration: 10 years with 30%  tax on dividends AGG wins a little with winning rate of 99% and a 0.095% difference on average. C...
Post a Comment
Read more