VOO正股 融資
其實1.1 -1.5 倍OK
當融資 10000美金都係 日息都係1蚊幾美金利息
當一個月都係還 300-400 HKD 左右
=let(StartDate,Today()-7,Nasdaq100,googlefinance("INDEXNASDAQ:NDX","price",StartDate,7,"DAILY"),TQQQ,googlefinance("NASDAQ:TQQQ","price",StartDate,7,"DAILY"),SQQQ,googlefinance("NASDAQ:SQQQ","price",StartDate,7,"DAILY"),Length,len(Nasdaq100),Nasdoq100ToPredict,Sequence(20,1,round(index(Nasdaq100,Length+1,2)*1.05,-2),-100),LeverageRatio,3,LowDecay,10,HighDecay,2,PredictedTQQQ,LAMBDA(i,max(0,round(index(TQQQ,Length+1,2)*((1+LeverageRatio*((index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^(1/HighDecay)-1))^HighDecay),2))&" - "&round(index(TQQQ,Length+1,2)*((1+LeverageRatio*((index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^(1/LowDecay)-1))^LowDecay),2)),PredictedSQQQ,LAMBDA(i,max(0,round(index(SQQQ,Length+1,2)*((1-LeverageRatio*((index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^(1/HighDecay)-1))^HighDecay),2))&" - "&round(index(SQQQ,Length+1,2)*((1-LeverageRatio*((index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^(1/LowDecay)-1))^LowDecay),2)),MaxTQQQ,LAMBDA(i,index(TQQQ,Length+1,2)*(index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^LeverageRatio),MaxSQQQ,LAMBDA(i,index(SQQQ,Length+1,2)*(index(Nasdoq100ToPredict,i)/index(Nasdaq100,Length+1,2))^-LeverageRatio),iferror(VSTACK(HSTACK("Nasdaq 100","TQQQ","SQQQ"),HSTACK(index(Nasdaq100,Length+1,2),index(TQQQ,Length+1,2),index(SQQQ,Length+1,2)),"","以下是根據"&year(index(Nasdaq100,Length+1,1))&"年"&month(index(Nasdaq100,Length+1,1))&"月"&day(index(Nasdaq100,Length+1,1))&"日的資料作出的預測,不會100%準確。越遠嘅價位準確度會越低,預測會隨資料更新而不斷變動。","",HSTACK("Nasdaq 100","TQQQ (估計)", "SQQQ (估計)", "TQQQ (最大)", "SQQQ (最大)"),HSTACK(Nasdoq100ToPredict,VSTACK(PredictedTQQQ(1),PredictedTQQQ(2),PredictedTQQQ(3),PredictedTQQQ(4),PredictedTQQQ(5),PredictedTQQQ(6),PredictedTQQQ(7),PredictedTQQQ(8),PredictedTQQQ(9),PredictedTQQQ(10),PredictedTQQQ(11),PredictedTQQQ(12),PredictedTQQQ(13),PredictedTQQQ(14),PredictedTQQQ(15),PredictedTQQQ(16),PredictedTQQQ(17),PredictedTQQQ(18),PredictedTQQQ(19),PredictedTQQQ(20)),VSTACK(PredictedSQQQ(1),PredictedSQQQ(2),PredictedSQQQ(3),PredictedSQQQ(4),PredictedSQQQ(5),PredictedSQQQ(6),PredictedSQQQ(7),PredictedSQQQ(8),PredictedSQQQ(9),PredictedSQQQ(10),PredictedSQQQ(11),PredictedSQQQ(12),PredictedSQQQ(13),PredictedSQQQ(14),PredictedSQQQ(15),PredictedSQQQ(16),PredictedSQQQ(17),PredictedSQQQ(18),PredictedSQQQ(19),PredictedSQQQ(20)),VSTACK(MaxTQQQ(1),MaxTQQQ(2),MaxTQQQ(3),MaxTQQQ(4),MaxTQQQ(5),MaxTQQQ(6),MaxTQQQ(7),MaxTQQQ(8),MaxTQQQ(9),MaxTQQQ(10),MaxTQQQ(11),MaxTQQQ(12),MaxTQQQ(13),MaxTQQQ(14),MaxTQQQ(15),MaxTQQQ(16),MaxTQQQ(17),MaxTQQQ(18),MaxTQQQ(19),MaxTQQQ(20)),VSTACK(MaxSQQQ(1),MaxSQQQ(2),MaxSQQQ(3),MaxSQQQ(4),MaxSQQQ(5),MaxSQQQ(6),MaxSQQQ(7),MaxSQQQ(8),MaxSQQQ(9),MaxSQQQ(10),MaxSQQQ(11),MaxSQQQ(12),MaxSQQQ(13),MaxSQQQ(14),MaxSQQQ(15),MaxSQQQ(16),MaxSQQQ(17),MaxSQQQ(18),MaxSQQQ(19),MaxSQQQ(20))),"")))