10
$\begingroup$

I have read various blog posts and reddit threads and so on talking about the recent changes to the Yahoo! Finance API and it leaves me very confused. I'm confused about what has changed. Supposedly all prices are adjusted data for both dividends and splits, but the "AdjClose" column isn't? Or no data is adjusted for dividends (just splits)? Or too much data is mysteriously missing? Or that only the location of the API has changed (breaking links) but the data is the same?

Can someone explain:

  1. What has changed
  2. What exactly about the quality of the data has changed (or that changes appear sporadically without explanation, which would be bad)
  3. What about the data described has changed (is it adjusted as it was before, or are dividends no longer adjusted for, putting Yahoo! Finance on part with Google Finance)
  4. Whether Yahoo! Finance should be the go-to source for free equities data now, or whether Google Finance/Quandl are now superior

Thanks!

$\endgroup$
12
$\begingroup$
  1. What has changed

The API is gone. The new downloads need 1st to parse the Yahoo Finance page to find a hidden crumb and use it as the key for data retrieval over a 2nd URL.

The adjusted close is sometimes the adjusted, sometimes is the non-adjusted and sometimes is a different value

Lines with literally "null" as the value for the prices have been inserted. Apparently this sometimes only affects the volume

Sometimes changes will appear across a single download of data.

Splits and dividends are for example apparently no longer applied to some of the values

  1. What exactly about the quality of the data has changed (or that changes appear sporadically without explanation, which would be bad) What about the data described has changed (is it adjusted as it was before, or are dividends no longer adjusted for, putting Yahoo! Finance on part with Google Finance)

Having a lot of "sometimes" as seen above is for sure no synonym of quality

  1. What about the data described has changed (is it adjusted as it was before, or are dividends no longer adjusted for, putting Yahoo! Finance on part with Google Finance)

See above again

  1. Whether Yahoo! Finance should be the go-to source for free equities data now, or whether Google Finance/Quandl are now superior

It is obviously no longer usable without a prior analysis from your side. Anything else seems to be a better choice now.

For reference see for example:

Note: Understanding that Yahoo may have not been happy about people downloading (and possibly redistributing) data for (a) f(r)ee, how Yahoo did it shows what Yahoo is up for: a web page that said that engineers were working on the problem. There was obviously no problem and a page indicating that the service was no longer available would have been the right way to go.

Update: And some tickers like YHOO (surprise, surprise) seem to no longer be available (try for example YHOO.MX for something that works)

$\endgroup$
2
$\begingroup$

No. I’m watching the management of a penny stock manipulate its share price by announcing a reverse stock split and yahoo hasn’t adjusted its prices going on a week and a half. The algorithms thinks it’s a huge breakout and are buying. There’s plenty of opportunity to pickoff bad data.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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