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])
import csv #輸入csv套件comma separated value file = open('SPY.CSV','r') #打開下載的檔案SPY.CSV,模式是r讀取, csvreader = csv.reader(file) #將檔案讀入變數csvreader header, rows = [], [] #宣告空白串列(陣列,清單) header = next(csvreader) #串列header儲存檔案第一列 for row in csvreader: #檔案接續逐列附加append於rows串列 rows.append(row) file.close() #關閉檔案 header.append('MA20') #appendix附錄,為header串列list新曾元素 header.append('部位') #print('印出前十列') #print(header) for i in range(20): rows[i].append(rows[i][5]) for i in range(21,len(rows)): sum20 = 0.0 #實數=浮點數 for j in range(i-20, i): sum20 += float(rows[j][5]) rows[i].append(sum20/20) for i in range(len(rows)-3,len(rows)):...
留言
張貼留言