D11050113王泓崴期末考

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])