Question: How do get the number 0.4633469 in Excel ??? please show me in a way, thank you PORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith

How do get the number 0.4633469 in Excel ???
please show me in a way, thank you
PORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith return geo SD RETURN ARITH RETURN GEO VAR PORTFOLIO 1 2 TLKM 0,2 2,96% 2,76% 7% 1,16% 2,359% 0,002413138 4,91% 3 JSMR 0,5 0,29% 0% 7% 4 BBCA 0,3 1% 6% 6% 5 6 7 CORR 8 TLKM JSMR 33% 9 TLKM BBCA 36% 10 JSMR BBCA 28% 11 12 0,4633469 0,0797424 0,456911 13 TLKM JSMR BBCA return 14 0,4633469 TLKM 0,00535607 0,0015895 0,001513 2,96% 15 0,07974243 JSMR 0,00158947 0,0041419 0,001029 0,29% 16 0,45691067 BBCA 0,00151309 0,0010289 0,003235 1% 17 1 0,00152896 0,0001226 0,001033 18 0,02032941 mean 19 0,00134234 sd 20 15,1447913 sharpe PORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith return geo SD RETURN ARITH RETURN GEO VAR PORTFOLIO 1 2 TLKM 0,2 2,96% 2,76% 7% 1,16% 2,359% 0,002413138 4,91% 3 JSMR 0,5 0,29% 0% 7% 4 BBCA 0,3 1% 6% 6% 5 6 7 CORR 8 TLKM JSMR 33% 9 TLKM BBCA 36% 10 JSMR BBCA 28% 11 12 0,4633469 0,0797424 0,456911 13 TLKM JSMR BBCA return 14 0,4633469 TLKM 0,00535607 0,0015895 0,001513 2,96% 15 0,07974243 JSMR 0,00158947 0,0041419 0,001029 0,29% 16 0,45691067 BBCA 0,00151309 0,0010289 0,003235 1% 17 1 0,00152896 0,0001226 0,001033 18 0,02032941 mean 19 0,00134234 sd 20 15,1447913 sharpe
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
