bell notificationshomepageloginNewPostedit profiledmBox

Hoots : Using Close or Adjusted Close in stock correlation calculation I would like to calculate two stocks correlation for a specific time range. I am simply taking a daily returns of both stocks and then applying correlation function. - freshhoot.com

10% popularity   0 Reactions

Using Close or Adjusted Close in stock correlation calculation
I would like to calculate two stocks correlation for a specific time range. I am simply taking a daily returns of both stocks and then applying correlation function.

Should I use "Close" price or "Adjusted Close" price to get a daily return? I understand the meaning of "Adjusted Close", however I get quite different results on a different pair of stocks.

For example for a pair GLD - AAPL using "Open" and "Close" prices between 2019-04 and 2020-04 I get -0.240. Using "Open" and "Adjusted Close" for the same period I get -0.247.

However, for some other stocks results are completely different. E.g. DANSKE.CO and RBREW.CO using "Close" and "Open" I get 0.008, but using "Adjusted Close" I get 0.192.


Load Full (1)

Login to follow hoots

1 Comments

Sorted by latest first Latest Oldest Best

10% popularity   0 Reactions

You should use Adjusted Close. If you know the meaning of Adjusted Close then it should be obvious why. If you just use the close, then any corporate actions (splits, dividends, buybacks) would be reported as returns which would throw off your correlation calculations.


Back to top Use Dark theme