量化交易 如何生成EXCEL

第一步是作成数据excel

###EXCEl  create  start
#######################
A.datanum3s=300
A.datanum1m=int(A.datanum3s/20)
A.stock_vol3s = []
A.stock_pri3s = []
A.stock_pmt3s = []
A.stock_pri1m = []
A.stock_mav7m = []
##########
A.stock2_vol3s = []
A.stock2_pri3s = []
A.stock2_pmt3s = []
A.stock2_pri1m = []
A.stock2_mav7m = []
for i in range(A.stocknum):
    pri3s = []
    pri1m = []
    for j in range(A.datanum3s):
        pri3s.append(j)
    for j in range(A.datanum1m):
        pri1m.append(j)
    A.stock_vol3s.append(pri3s)
    A.stock_pri3s.append(pri3s)
    A.stock_pmt3s.append(pri3s)
    A.stock_pri1m.append(pri1m)
    A.stock_mav7m.append(pri1m)
    A.stock2_vol3s.append(pri3s)
    A.stock2_pri3s.append(pri3s)
    A.stock2_pmt3s.append(pri3s)
    A.stock2_pri1m.append(pri1m)
    A.stock2_mav7m.append(pri1m)
###########################
###EXCEl  create  finish
#######################