2021-05-23

如何利用Python 获取沪深300指数行情数据并存入ACCESS数据库（附实用代码案例）

-----Tushare ID：277032

import pyodbc  

conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\WindData\TushareData.mdb')
crsr = conn.cursor()
import xlrd
import pandas as pd
pd.set_option('expand_frame_repr','False')
import tushare as ts
ts.set_token('XXXXXXXXXXXXXXX')
pro = ts.pro_api()

 m_startdate='20050101'    #设置数据开始时间
df = pro.index_daily(ts_code='399300.SZ', start_date=m_startdate)   #从TuShare读取数据
#print(df)
if df is None or df.empty:
   print("No data to download!")
else:
       ts_code=df['ts_code'].tolist()
       ts_tradedate=df['trade_date'].tolist()
       ts_close=df['close'].tolist()
       for jj in range(len(ts_code)):
           print(ts_tradedate[jj])
           sql=""" insert into csi300index(Indexcode,tradedate,indexprice) values ('%s','%s',%s)"""
           crsr.execute(sql%(ts_tradedate[jj],'s12426',ts_close[jj]))

crsr.commit()
crsr.close()
conn.close()