EXCEL繪製投資效率前緣
劉任昌程式交易Markowitz 1952投資效率前緣
STYLE樣式BORDER邊界SOLID實心DASHED虛線DOTTED點線 import csv #輸入import輸出export,輸入csv套件 import math #輸入math套件 from tkinter import * #或者import tkinter as tk Dim = 10 def draw_circle(x, y, label): canvas.create_oval(100+x-5, 700-y-5, 100+x+5, 700-y+5, fill="black") canvas.create_text(100+x+20, 700-y, text = label, anchor='w', font=('微軟正黑體',20)) file = open('台灣.csv','r',encoding='utf-8') read = csv.reader(file) header, rows = [], [] header = next(read) for item in read: rows.append(item) file.close() num = len(rows) #資料表長度 #print(header) mean = [0 for i in range(Dim)]; mean50 = 0; vari50=0 meanTemp = [0 for i in range(Dim)] vari = [[0 for i in range(Dim)] for j in range(Dim)] for k in range(num): for i in range(Dim): meanTemp[i]=float(rows[k][i+1])/100 #轉換為小數 mean[i] += meanTemp[i] for j in range(i+1): vari[i][j] += meanTemp[i]*meanTemp[j] mean...
https://fanyahui.blogspot.com/2026/03/excel.html
回覆刪除https://hsiao-yu0711.blogspot.com/2026/03/excel.html
回覆刪除https://d11217111.blogspot.com/2026/03/excel.html
回覆刪除https://s10655075.blogspot.com/2026/03/excel.html
回覆刪除https://huang-pei-kai.blogspot.com/2026/03/excel.html?m=1
回覆刪除https://the-most-great.blogspot.com/2026/03/excel.html
回覆刪除https://dgdhgfhgfjh.blogspot.com/2026/03/blog-post_26.html
回覆刪除