最近项目上有需求要导出wind系统中的数据,写了个python 脚本批量导出, 脚本如下:
from WindPy import w
import pandas as pd
"""
wind路径:
量化-API接口-代码生成器(GC) 生成python代码
批量导出货币基金的日万份和七日年化
"""
w.start()
print("是否已连接wind:", w.isconnected())
fund_str = "000009.OF,000010.OF"
fund_arr = fund_str.split(",");
for fund_code in fund_arr:
wd = w.wsd(fund_code, "mmf_unityield,mmf_annualizedyield","2021-01-01", "2021-01-24", "")
dic={
"日期":wd.Times,
"日万份":wd.Data[0],
"七日年化":wd.Data[1]
}
dst = pd.DataFrame(dic)
dst_path = "D:/fund_export/" + fund_code + ".csv"
dst.to_csv(dst_path)
print(dst_path + " 完成导出!")
以上脚本,批量导出货币基金的日万份和七日年化,导入基金的其它信息也是类似,这个可以作为demo代码参考