莊庭寬Python字典判斷除息日對照EXCEL向下填滿公式

EXCEL畫面

日	量	開	高	低	收	率	調	收報	除息?	
1993/1/29	1003200	43.96875	43.96875	43.75	43.9375	0	24.53		=IF(G3-I3>0.001,"除息","")	
1993/2/1	480500	43.96875	44.25	43.96875	44.25	0.71%	24.7	0.71%		=IF(J3="除息",F2*(G3-I3),"")
1993/2/2	201300	44.21875	44.375	44.125	44.34375	0.21%	24.75	0.21%		
1993/2/3	529400	44.40625	44.84375	44.375	44.8125	1.06%	25.01	1.06%		
1993/2/4	531500	44.96875	45.09375	44.46875	45	0.42%	25.12	0.42%

留言

張貼留言

這個網誌中的熱門文章

莊庭寬python運算CSV輸出TKINTER投資風險與報酬Markowitz

圖片
import csv #輸入csv套件comma separated value f = open('200201to202505.csv','r', encoding="utf-8")#打開下載的檔案SPY.CSV,模式是r讀取, csvreader = csv.reader(f) #將檔案讀入變數csvreader header, rows = list(), list() #宣告空白串列(陣列,清單) firms = set() #建構集合 header = next(csvreader) #串列header儲存檔案第一列 for record in csvreader: #檔案紀錄，逐列row檢視 rows.append(record) #第i筆附加append於rows串列成為rows[i] firms.add(record[0]) #row[0]公司名稱 f.close() #關閉檔案 months = dict() for year in range(2007,2026): months[year]=[str(year*100+month) for month in range(1,13)] count, sum, sumSq, mean, stdev = dict(), dict(), dict(), dict(), dict() for firm in firms: for year in range(2007, 2026): t = (firm, year) #元組(公司,年) count[t] = 0 sum[t] = 0.0 sumSq[t] = 0.0 for row in rows: #字典value增加append元素 for firm in firms: if row[0] =...
閱讀完整內容

馬可維茲風險平均數平面

import csv #輸入csv套件comma separated value f = open('200201to202505.csv','r', encoding="utf-8")#打開下載的檔案SPY.CSV,模式是r讀取, csvreader = csv.reader(f) #將檔案讀入變數csvreader header, rows = list(), list() #宣告空白串列(陣列,清單) firms = set() #建構集合 header = next(csvreader) #串列header儲存檔案第一列 for record in csvreader: #檔案紀錄，逐列row檢視 rows.append(record) #第i筆附加append於rows串列成為rows[i] firms.add(record[0]) #row[0]公司名稱 f.close() #關閉檔案 months = dict() for year in range(2007,2026): months[year]=[str(year*100+month) for month in range(1,13)] count, sum, sumSq, mean, stdev = dict(), dict(), dict(), dict(), dict() for firm in firms: for year in range(2007, 2026): t = (firm, year) #元組(公司,年) count[t] = 0 sum[t] = 0.0 sumSq[t] = 0.0 for row in rows: #字典value增加append元素 for firm in firms: if row[0] == firm...
閱讀完整內容

莊庭寬利用Python讀取SPY日成交資料

圖片
PYTHON程式碼 #下載csv檔案下載CSV檔案 https://drive.google.com/file/d/1eB8B... #莊庭寬 import csv #輸入套件csv=comma seperated value #輸入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() #關閉檔案 print(header) print(len(rows)) print('全球第一檔ETF交易資料') print(rows[0]) print(rows[len(rows)-1]) 執行結果 IPython 7.22.0 -- An enhanced Interactive Python. runfile('C:/Users/user/Downloads/劉任昌.py', wdir='C:/Users/user/Downloads') ['日期', '成交量', '開', '高', '低', '收', '調收'] 7833 ['1993/1/29', '1003200', '43.96875', '43.96875', '43.75', '43.9375', '24.840673'] ['2024/3/8', '86425500...
閱讀完整內容