ib 你試吓擺佢去watchlist
有個column叫fee rate
牛牛3%
=let(CurrentRate,R1,RateList,Q3:Q16,DotPlot,R3:R16,hikeone,sumif(RateList,CurrentRate+0.25,DotPlot),hiketwo,sumif(RateList,CurrentRate+0.25*2,DotPlot),hikethree,sumif(RateList,CurrentRate+0.25*3,DotPlot),hikefour,sumif(RateList,CurrentRate+0.25*4,DotPlot),hikemore,sumif(RateList,">"&CurrentRate+0.25*4,DotPlot),maintain,sumif(RateList,"=" & CurrentRate,DotPlot),cutone,sumif(RateList,CurrentRate-0.25,DotPlot),cuttwo,sumif(RateList,CurrentRate-0.25*2,DotPlot),cutthree,sumif(RateList,CurrentRate-0.25*3,DotPlot),cutfour,sumif(RateList,CurrentRate-0.25*4,DotPlot),cutmore,sumif(RateList,"<" & CurrentRate-0.25*4,DotPlot),VSTACK(VSTACK(HSTACK("Hike",">1.00%",hikemore),VSTACK(HSTACK("Hike","+1.00%",hikefour),HSTACK("Hike","+0.75%",hikethree),HSTACK("Hike","+0.50%",hiketwo),HSTACK("Hike","+0.25%",hikeone),HSTACK("Maintain","0.00%",maintain),HSTACK("Cut","-0.25%",cutone),HSTACK("Cut","-0.50%",cuttwo),HSTACK("Cut","-0.75%",cutthree),HSTACK("Cut","-1.00%",cutfour),HSTACK("Cut","> 1.00%",cutmore)))))