劉任昌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% Spyder畫面