我的脚本接收了一个F500家公司的“实时”在线列表,遍历每个股票代码,在一个定义的时间段内获取股票代码的性能。我搞不懂的是如何在一个2D列表中架构/存储每个符号的多行股票数据。不知何故,第二个iTErrors将无法运行。提前感谢:
import pandas as pd #dataframe extends from pd
import pandas_datareader.data as web #grabs stock data
import datetime as dt #to specify date range for grab
#VARS:
#url to f500 list
data_url = "https://query.data.world/s/vjghzuarkh6dap3dblkxanppyh5jtl"
source = "yahoo"
start = dt.datetime(2019, 2, 13) #datetime type
end = dt.datetime.now()
results = []
#read into memory
df500 = pd.read_csv(data_url)
for index, row in df500.tail().iterrows():
try:
dfdr = web.DataReader(row['SYMBOL'], source, start, end) #returns a dataframe presumably
for index2, row2 in dfdr().iterrows():
# here i want to append to the results list: row['SYMBOL'], row2['Date'], row2['High']
print ("test output ", row2[0]) #not even this works
except Exception as e:
pass
# commit to sqlite3 from list or df
dfdr后面的括号是错误的:
应该是:
相关问题 更多 >
编程相关推荐