历史库存数据错误

Question

当我试图从雅虎或谷歌(我都试过了)检索股票价格时，它总是返回这个错误。我不知道它是什么意思，也不知道如何修复它。我以前用过这段代码，它工作得很好。你能帮我解决这个错误和解决方案吗？谢谢。

import datetime as dt
import pandas as pd
import pandas_datareader.data as web


start = dt.datetime(2000,1,1)
end = dt.datetime(2004,1,1)

df= web.DataReader('TSLA', 'yahoo', start, end)
print(df.head)

servname : HTTPConnectionPool(host='ichart.finance.yahoo.com'，port=80)：超过url: /table.csv?a=0&ignore=.csv&s=TSLA&b=1&e=1&d=0&g=d&f=2004&c=2000的最大重试次数(由ConnectionError(‘：无法建立新连接: Errno 8 port=80或servname未提供，或未知’)引起)

Answer 1

只需更改此部分即可：

df=web.DataReader("TSLA","yahoo",start,end) to：df=web.DataReader("TSLA","google",start,end)

这里的问题出在雅虎搜索引擎上。所以希望这能解决这个问题。

Answer 2

以下是我发现的一种解决方法：

# Define the instruments to download. We would like to see Apple, Microsoft and the S&P500 index.
tickers = ['AAPL', 'MSFT', 'SPY']

# Define which online source one should use
data_source = 'google'

# We would like all available data from 01/01/2000 until 12/31/2016.
start_date = '2010-01-01'
end_date = '2016-12-31'

# User pandas_reader.data.DataReader to load the desired data. As simple as that.
panel_data = data.DataReader(tickers, data_source, start_date, end_date)

# Getting just the adjusted closing prices. This will return a Pandas DataFrame
# The index in this DataFrame is the major index of the panel_data.
close = panel_data.ix['Close']

# Getting all weekdays between 01/01/2000 and 12/31/2016
all_weekdays = pd.date_range(start=start_date, end=end_date, freq='B')

# How do we align the existing prices in adj_close with our new set of dates?
# All we need to do is reindex close using all_weekdays as the new index
close = close.reindex(all_weekdays)

close.head(10)

来自http://www.learndatasci.com/python-finance-part-yahoo-finance-api-pandas-matplotlib/