Can't get all data from Yahoo finance API

Question

I'm using python pandas in order to get stock/index prices from yahoo finance. I use the web.DataReader([list of stocks], 'yahoo', start, end)

Many of these stocks are working fine. However, one doesn't. My questions is: How can I manage to successfully gather all of them?

The one called ^DJCI is the one that doesn't work. It is available on the website of yahoo and it has data. I can't even get it individually by doing the following:

web.DataReader('^DJCI', 'yahoo', start, end)

I get the following error:

IOError: after 3 tries, Yahoo! did not return a 200 for url 'http://ichart.finance.yahoo.com/table.csv?s=^DJCI&a=0&b=1&c=2015&d=0&e=9&f=2016&g=d&ignore=.csv'

Load that URL in a browser. You have provided an invalid URL. — jumbopap, Jan 09 '16 at 21:42
Keep it simple! Try `web.DataReader('DJCI', 'yahoo', start, end)` — Sergey Bushmanov, Jan 09 '16 at 21:46
DJCI and ^DJCI are unfortunately different stocks. DJCI works but it doesn't solve my problem. Here is the link to ^DJCI: http://finance.yahoo.com/q;_ylt=AoLanflTrlWqZkhs7gTJUBNzAcAF?uhb=uhb2&fr=uh3_finance_vert_gs_ctrl2_e&type=2button&s=%5EDJCI — Filip Eriksson, Jan 09 '16 at 21:51

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

Try searching for %5EDJCI. That is equivalent to ^DJCI. The reason ^DJCI didn't work might because ^ is not a normal character and you need to ¹escape it.

1: I don't know the proper term for converting ^ to %5E.

EDIT 1

See Yahoo! Finance CSV file will not return Dow Jones (^DJI)

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 10 '16 at 03:53

NoOneIsHere

1,054
16
28

Unfortunately it didn't work either. It failed in the same manner. – Filip Eriksson Jan 10 '16 at 14:34
See http://stackoverflow.com/questions/3679870/yahoo-finance-csv-file-will-not-return-dow-jones-dji?lq=1. – NoOneIsHere Jan 10 '16 at 14:46
The term is "URL encoding" – Ken Fehling Jan 11 '16 at 01:50

jrovegno · Answer 2 · 2016-01-11T17:05:14.513

The problem is not the special character in ^DJCI the problem is the availability of historical data of that index, if you check Historical Prices this message is displayed:

Historical quote data is unavailable for the specified date range.

I search other source like Quandl, with no luck. But according this article, you could have good correlation with "iShares S&P GSCI Commodity-Indexed Trust (GSG)", if you find a free source of ^DJCI please let me know. By this time a good alternative is to use GSG

web.DataReader('GSG', 'yahoo', start, end)

Can't get all data from Yahoo finance API

2 Answers2

EDIT 1