首先在tushare官网导出tushare的stock的csv表格
官网url:https://waditu.com/
之后遍历,将所有数据进行股票的查询,根据当前股票的发行日期,与当前的系统时间,进行tushare接口的访问,将获取的数据信息保存至本地excel文件即可。
import csv
import tushare as ts
import datetime
import pandas as pd
import os
stock_info_path=os.getcwd()+"/stock/stock_dairy/"
csv_reader = csv.reader(open("tushare_stock.csv"))
pro = ts.pro_api('your token')//在官网账号中寻找
cnt=0
t=datetime.datetime.now()
# t1 =t.strftime('%Y-%m-%d %H:%M:%S')
t1 = t.strftime('%Y%m%d')
print(t1)
for row in csv_reader:
cnt+=1
if(cnt==1):
continue
print(row)
df = pro.query('daily', ts_code=row[0], start_date=row[12], end_date=t1)
print(df)
# df.to_excel('/stock/stock_dairy/data.xlsx', columns=['A列'], index=False)
stock_diary_path=stock_info_path+row[0]+'.xlsx'
print(stock_diary_path)
df.to_excel(stock_diary_path)
导出效果