0
$\begingroup$

This question already has an answer here:

I've been trying to calculate returns for different stocks but using Yahoo Fiance Historical price data seems to be weird. For instance, looking up the March 5th 2012 Price for APPL on the online interface gives:

Open    High    Low     Close   Adj Close
77.92   78.21   75.14   533.16  76.17

This in itself doesn't make sense, why is the close so much higher than the high/low?

To add to my confusion if I download the csv it gives different numbers entirely (except for the close):

Open    High    Low     Close   Adj Close
545.42  547.48  526.00  533.16  69.08

Am I doing something wrong and if not where can I get somewhat accurate financial data?

$\endgroup$

marked as duplicate by Bob Jansen May 8 '17 at 12:33

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • $\begingroup$ Experience from various questions on this site on gathering reliable data from Yahoo Finance tells: you can not. This topic has a list of data sources, some reliable. $\endgroup$ – Bob Jansen May 8 '17 at 12:33
1
$\begingroup$

You really care about the adjusted close. The difference you're seeing is caused by the stocks split, see e.g.

enter image description here

$\endgroup$
  • $\begingroup$ Thanks for the answer, but why is the adjusted close different when downloading the data? $\endgroup$ – nico Mar 4 '17 at 21:47
  • $\begingroup$ Where? In your first or in your second table? $\endgroup$ – rbm Mar 4 '17 at 21:49
  • 1
    $\begingroup$ The first table is when I look at the data online and the second table is when I download the csv data (top-right button on the online view). $\endgroup$ – nico Mar 4 '17 at 21:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.