Python pandas datareader no longer works for yahoo-finance changed url

python pandas yahoo-finance pandas-datareader
Scilear picture Scilear · May 18, 2017 · Viewed 29.4k times · Source

Since yahoo discontinued their API support pandas datareader now fails 

import pandas_datareader.data as web
import datetime
start = datetime.datetime(2016, 1, 1)
end = datetime.datetime(2017, 5, 17)
web.DataReader('GOOGL', 'yahoo', start, end)

HTTPError: HTTP Error 401: Unauthorized

is there any unofficial library allowing us to temporarily work around the problem? Anything on Quandl maybe?

Answer

artDeco picture artDeco · May 25, 2017

I found the workaround by "fix-yahoo-finance" in https://pypi.python.org/pypi/fix-yahoo-finance useful, for example:

from pandas_datareader import data as pdr
import fix_yahoo_finance

data = pdr.get_data_yahoo('APPL', start='2017-04-23', end='2017-05-24')

Note the order of the last 2 data columns are 'Adj Close' and 'Volume' ie. not the previous format. To re-index:

cols = ['Date', 'Open', 'High', 'Low', 'Close', 'Volume', 'Adj Close']
data.reindex(columns=cols)

Related questions

converting daily stock data to weekly-based via pandas in Python

I've got a DataFrame storing daily-based data which is as below: Date Open High Low Close Volume 2010-01-04 38.660000 39.299999 38.509998 39.279999 1293400 2010-01-05 39.389999 39.520000 39.029999 39.430000 1261400 2010-01-06 39.549999 40.700001 39.020000 40.250000 1879800 2010-01-07 40.090000 40.349998 39.910000 40.090000 836400 2010-01-08 40.139999 40.310001 39.720001 40.290001 654600 2010-01-11 40.209999 40.520000 40.040001 40.290001 963600 2010-01-12 40.160000 40.340000 39.279999 39.980000 1012800 2010-01-13 39.930000 40.669998 39.709999 40.560001 1773400 2010-01-14 40.490002 40.970001 40.189999 40.520000 1240600 2010-01-15 40.570000 40.939999 40.099998 40.450001 1244200 What I intend …

Read More
How can get ' USDJPY'(currency rates) with pandas and yahoo finance?

I am learning and using the pandas and python. Today, I am trying to make a fx rate table, but I got a trouble with getting the pricess of 'USDJPY'. When I get a prices of 'EUR/USD', i code …

Read More
How To: Python Pandas get current stock data

I've used: data = DataReader("yhoo", "yahoo", datetime.datetime(2000, 1, 1), datetime.datetime.today()) in pandas (python) to get history data of yahoo, but it cannot show today's price (the market has not yet closed) how can I resolve such problem, thanks in …

Read More