title = ["日期", "收盤", "決策","部位"] rows = [] rows.append(title) rows.append(["2024/6/17",15.1,0,0]) rows.append(["2024/6/18",15.8,0,0]) rows.append(["2024/6/19",18.1,1,1]) rows.append(["2024/6/20",19.2,0,1]) rows.append(["2024/6/21",20.1,0,1]) for i in range(len(rows)): print(rows[i]) for i in range(1, len(rows)): if rows[i][3]==1:#如果做多 gain = rows[i][1]-rows[i-1][1] rows[i].append(gain)#增加一個欄位今天損益 elif rows[i][3]==-1:#如果做空 gain = rows[i-1][1]-rows[i][1]#昨天扣除今天 rows[i].append(gain) else: rows[i].append(0.0) for i in range(1,len(rows)): print(rows[i])
留言
張貼留言