複雜版未得閒update住,畀個精簡版大家先。
計算Underlying去到 x 嗰陣,LETF最大係幾多。
=LET(CurrentPrice_Underlying,18600.97,CurrentPrice_LETF,63.14,LeverageRatio,3,TargetPrice_Underlying,20000,MaxPrice_LETF,CurrentPrice_LETF*(TargetPrice_Underlying/CurrentPrice_Underlying)^LeverageRatio,MaxPrice_LETF)
計算LETF去到 x 嗰陣,underlying最大/最少係幾多。
=LET(CurrentPrice_Underlying,18600.97,CurrentPrice_LETF,63.14,LeverageRatio,3,TargetPrice_LETF,100,TargetPrice_Underlying,TargetPrice_LETF^(1/LeverageRatio)*CurrentPrice_Underlying/(CurrentPrice_LETF^(1/LeverageRatio)),TargetPrice_Underlying)