17

When a data provider like Yahoo finance says that the closing price is adjusted for splits and dividends, what does that mean? A split will increase/ decrease the price by the split ratio, and a dividend will decrease the price by the amount of the dividend.

So what adjustment are they talking of?

Victor123
  • 16,084
  • 40
  • 133
  • 234

2 Answers2

8

Should be noted that pacoverflow's answer is wrong. Yahoo back-adjusts all the previous (not current or future) values based on a cumulative adjustment factor. So if there's a dividend ex-date on December 19, Yahoo adjusts all the PREVIOUS (December 18 and prior) prices with a factor which is:

1 - dividend / Dec18Close

misantroop
  • 604
  • 4
  • 9
7

[This answer has been updated to reflect changes to Yahoo's historical prices. It is accurate as of 2017/12/15.]

Yahoo adjusts all historical prices to reflect a stock split. For example, ISRG was trading around $1000 prior to 2017/10/06. Then on 2017/10/06, it underwent a 3-for-1 stock split. As you can see, Yahoo's historical prices divided all prices by 3 (both prior to and after 2017/10/06):

enter image description here

For dividends, let's say stock ABC closed at 200 on December 18. Then on December 19, the stock increases in price by $2 but it pays out a $1 dividend. In Yahoo's historical prices for XYZ, you will see that it closed at 200 on Dec 18 and 201 on Dec 19. Yahoo factors in the dividend in the "Adj Close" column for all the previous days. So the Close for Dec 18 would be 200, but the Adj Close would be 199.

For example, on 2017/09/15, SPY paid out a $1.235 dividend. Yahoo's historical prices say that SPY's closing price on 2017/09/14 was 250.09, but the Adj Close is 248.85, which is $1.24 lower. The Adj Close for the previous days was reduced by the dividend amount.

enter image description here

7529
  • 3,813
  • 3
  • 25
  • 37