pandas-datareader
pandas-datareader copied to clipboard
pydata
RemoteDataError: Unable to read URL: https://finance.yahoo.com/quote/SPY/history
when trying to get a dataframe:
df = pandas_datareader.yahoo.daily.YahooDailyReader('SPY').read()
error
RemoteDataError: Unable to read URL: https://finance.yahoo.com/quote/SPY/history?period1=1470542400&period2=1628308799&interval=1d&frequency=1d&filter=history
expected result: a dataframe with prices
Interestingly, it works with curl and aria2c but not with wget or DataReader.
I'm running the example here: https://pandas-datareader.readthedocs.io/en/latest/remote_data.html#yahoo-finance-data and it fails:
df = web.DataReader('GE', 'yahoo', start='2019-09-10', end='2019-10-09')
RemoteDataError: Unable to read URL: https://finance.yahoo.com/quote/GE/history?period1=1568088000&period2=1570679999&interval=1d&frequency=1d&filter=history Response Text: b'<!DOCTYPE html>\n <html lang="en-us"><head>\n <meta http-equiv="content-type" content="text/html; charset=UTF-8">\n <meta charset="utf-8">\n <title>Yahoo</title>\n <meta name="viewport" content="width=device-width,initial-scale=1,minimal-ui">\n <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">\n <style>\n html {\n height: 100%;\n }\n body {\n background: #fafafc url(https://s.yimg.com/nn/img/sad-panda-201402200631.png) 50% 50%;\n background-size: cover;\n height: 100%;\n text-align: center;\n font: 300 18px "helvetica neue", helvetica, verdana, tahoma, arial, sans-serif;\n }\n table {\n height: 100%;\n width: 100%;\n table-layout: fixed;\n border-collapse: collapse;\n border-spacing: 0;\n border: none;\n }\n h1 {\n font-size: 42px;\n font-weight: 400;\n color: #400090;\n }\n p {\n color: #1A1A1A;\n }\n #message-1 {\n font-weight: bold;\n margin: 0;\n }\n #message-2 {\n display: inline-block;\n *display: inline;\n zoom: 1;\n max-width: 17em;\n _width: 17em;\n }\n </style>\n <script>\n document.write(\'<img src="//geo.yahoo.com/b?s=1197757129&t=\'+new Date().getTime()+\'&src=aws&err_url=\'+encodeURIComponent(document.URL)+\'&err=%<pssc>&test=\'+encodeURIComponent(\'%<{Bucket}cqh[:200]>\')+\'" width="0px" height="0px"/>\');var beacon = new Image();beacon.src="//bcn.fp.yahoo.com/p?s=1197757129&t="+new Date().getTime()+"&src=aws&err_url="+encodeURIComponent(document.URL)+"&err=%<pssc>&test="+encodeURIComponent(\'%<{Bucket}cqh[:200]>\');\n </script>\n </head>\n <body>\n <!-- status code : 404 -->\n <!-- Not Found on Server -->\n <table>\n <tbody><tr>\n <td>\n <img src="https://s.yimg.com/rz/p/yahoo_frontpage_en-US_s_f_p_205x58_frontpage.png" alt="Yahoo Logo">\n <h1 style="margin-top:20px;">Will be right back...</h1>\n <p id="message-1">Thank you for your patience.</p>\n <p id="message-2">Our engineers are working quickly to resolve the issue.</p>\n </td>\n </tr>\n </tbody></table>\n </body></html>'
As szotsaki mentions, strange since clicking through the URL is fine – is yahoo blocking these requests now?
Was anyone able to figure this issue? I am facing the same issue when trying to get data from famafrench lib.
web.DataReader('F-F_Research_Data_Factors_2x3', famafrench)
