如何编写和追加多个股票数据从雅虎财经url?

Question

我有以下代码，需要从雅虎url下载多个报价器的数据:

import time
import datetime
import pandas as pd
#read ticker symbols from a file to a python list object named ticker
symbols = []
with open('ticker_list.csv') as f:
symbol = [row.split()[0] for row in f]
f.close
period1 = int(time.mktime(datetime.datetime(2020, 12, 1, 23, 59).timetuple()))
period2 = int(time.mktime(datetime.datetime(2020, 12, 31, 23, 59).timetuple()))
interval = '1d' # 1d, 1wk, 1m
xlwriter = pd.ExcelWriter('Stock_Price_sample.xlsx', engine='xlsxwriter')
for ticker in symbols:
query_string = f'https://query1.finance.yahoo.com/v7/finance/download/{ticker}?period1={period1}&period2={period2}&interval={interval}&events=history&includeAdjustedClose=true'
df = pd.read_csv(query_string)
append_df.to_excel(xlwriter, sheet_name='Sheet1', index=False)

xlwriter.save()

例如，在ticker_list.csv文件中，我有以下股票:MSFT, AAPL, TSLA等。

我无法下载股票数据并将它们附加到excel编写器。它给了我空白的一页。如果您能提供任何帮助，我将不胜感激。

Answer 1

此任务可使用yahooquery或yfinance。