calculate annual standard deviation, sharpe ratio for each of 4 exchange funds

G H 1 1 1 M N 0 PERIOD DATE 24 23 -2.30% -3949 165 1.266 1.296 5 7194 21 19 18 17 16 15 14 13 12 11 10 9 8 1.282 1.258 1.186 1.168 1.113 0.985 1.130 1.225 1.223 1.192 5 D Beta - 1.08 Beta-101 Beta 0.34 Beta - 0 10.2020 275.92 342.58 93.42 13450 09 2020 284 30 350.4 93.03 10.707 08.2020 301 44 365.01 93.86 11,679 07.2020 271.43 340.51 93.83 11,346 06.2020 252.60 320.93 9,547 05.2020 237.83 316.09 89.76 9,505 04.2020 222.38 301.12 87.20 8,427 03.2020 193.66 266.66 83.18 6.481 02.2020 209 12 305.88 92.45 8.63) 01.2020 22238 331.52 93.63 9,354 12.2019 215.61 330.99 93.65 11.2019 207.78 322.58 92.17 7.710 10.2019 199.46 310.69 91.62 9,589 09.2019 190 90 303.36 91.58 8.241 08.2019 189 35 29.35 91.16 9,626 07.2019 19283 30289 90.51 10,027 06.2019 18824 90.37 11,393 05.2019 175 17 279.15 87.61 8,503 04.2019 290.68 292.57 5.238 03.2019 180.56 285.32 88.43 4.093 02.2019 17388 280.90 87.30 3.101 01.2019 168.66 271.55 86.26 3417 12.2013 154.57 250.22 81.83 3,674 11.2018 169 54 27620 83.98 3.930 10.2018 16982 270,63 8.35 6,302 qulytisk Premium-52% US Trawy 100% Exp Mat Natur-5.2.0-60 -2.95 -565 11.06% 7.45% 6.21% 6.71% 15.09% -7.39% -5.96 3.14% 3.77% 4.17% 4.48% 0.82% 1.HON 2.44 7 AN 8.13 5.60 3.84 300 9.12 BAN -0.17% 0.00% 1574 1775 1.599 1487 1401 1312 1140 1231 1.309 2.270 1234 1.175 1124 7.158 29.36 32 2.93 24.04% 3.77 7.69% 36.18% 24.93% -7.71% 30.6N -7.16% 16.10N 11.51 -14.39% 3.99 -11.99% 338 62.MN 27.97% 7.64N 0.43% -ON 0.02% 5.09% 0.53% 2.99 4.83 10.02% 1.26 -0.02 1.61% 0.60N 0.04 0.46N 0.72 0.36% 3.15% 1.SIN 1.00 1.29N 1.IN SAZN 2.55 0.44 0.00N 6.30 1.53% 4.97% 12.925 -12.82% 7.73% 0.16% 2.61% 3.83 2.41% 1.68% 1.48% 1218 6.65 6.199 4.29% 1.57 34 8.22 9.15 2.00% 0.00% 1.108 1103 1113 1112 1.09 1.064 1,034 0.986 1.036 1.110 L110 1.093 L.ORG 1086 1.081 1073 1.073 1.039 L059 1.048 1.05 1023 0.970 0.996 1.000 2198 1699 1859 1 800 1451 1508 1401 1028 1370 1.484 11.36 1.223 145 1 308 1.527 1.591 1.800 1.349 0831 0.649 0.603 0.542 OSAS 0.624 1000 1115 297.72 2 1.121 1.102 1.119 1.500 1.031 1.100 1,054 1.038 1.003 0.927 1021 1.000 1.135 1.103 1032 1123 1.06) 1.004 0.993 0.910 0.990 1.000 5 4 3 2 1 -7.00 6.52 -37.64% 0.00N G H 1 1 1 M N 0 PERIOD DATE 24 23 -2.30% -3949 165 1.266 1.296 5 7194 21 19 18 17 16 15 14 13 12 11 10 9 8 1.282 1.258 1.186 1.168 1.113 0.985 1.130 1.225 1.223 1.192 5 D Beta - 1.08 Beta-101 Beta 0.34 Beta - 0 10.2020 275.92 342.58 93.42 13450 09 2020 284 30 350.4 93.03 10.707 08.2020 301 44 365.01 93.86 11,679 07.2020 271.43 340.51 93.83 11,346 06.2020 252.60 320.93 9,547 05.2020 237.83 316.09 89.76 9,505 04.2020 222.38 301.12 87.20 8,427 03.2020 193.66 266.66 83.18 6.481 02.2020 209 12 305.88 92.45 8.63) 01.2020 22238 331.52 93.63 9,354 12.2019 215.61 330.99 93.65 11.2019 207.78 322.58 92.17 7.710 10.2019 199.46 310.69 91.62 9,589 09.2019 190 90 303.36 91.58 8.241 08.2019 189 35 29.35 91.16 9,626 07.2019 19283 30289 90.51 10,027 06.2019 18824 90.37 11,393 05.2019 175 17 279.15 87.61 8,503 04.2019 290.68 292.57 5.238 03.2019 180.56 285.32 88.43 4.093 02.2019 17388 280.90 87.30 3.101 01.2019 168.66 271.55 86.26 3417 12.2013 154.57 250.22 81.83 3,674 11.2018 169 54 27620 83.98 3.930 10.2018 16982 270,63 8.35 6,302 qulytisk Premium-52% US Trawy 100% Exp Mat Natur-5.2.0-60 -2.95 -565 11.06% 7.45% 6.21% 6.71% 15.09% -7.39% -5.96 3.14% 3.77% 4.17% 4.48% 0.82% 1.HON 2.44 7 AN 8.13 5.60 3.84 300 9.12 BAN -0.17% 0.00% 1574 1775 1.599 1487 1401 1312 1140 1231 1.309 2.270 1234 1.175 1124 7.158 29.36 32 2.93 24.04% 3.77 7.69% 36.18% 24.93% -7.71% 30.6N -7.16% 16.10N 11.51 -14.39% 3.99 -11.99% 338 62.MN 27.97% 7.64N 0.43% -ON 0.02% 5.09% 0.53% 2.99 4.83 10.02% 1.26 -0.02 1.61% 0.60N 0.04 0.46N 0.72 0.36% 3.15% 1.SIN 1.00 1.29N 1.IN SAZN 2.55 0.44 0.00N 6.30 1.53% 4.97% 12.925 -12.82% 7.73% 0.16% 2.61% 3.83 2.41% 1.68% 1.48% 1218 6.65 6.199 4.29% 1.57 34 8.22 9.15 2.00% 0.00% 1.108 1103 1113 1112 1.09 1.064 1,034 0.986 1.036 1.110 L110 1.093 L.ORG 1086 1.081 1073 1.073 1.039 L059 1.048 1.05 1023 0.970 0.996 1.000 2198 1699 1859 1 800 1451 1508 1401 1028 1370 1.484 11.36 1.223 145 1 308 1.527 1.591 1.800 1.349 0831 0.649 0.603 0.542 OSAS 0.624 1000 1115 297.72 2 1.121 1.102 1.119 1.500 1.031 1.100 1,054 1.038 1.003 0.927 1021 1.000 1.135 1.103 1032 1123 1.06) 1.004 0.993 0.910 0.990 1.000 5 4 3 2 1 -7.00 6.52 -37.64% 0.00N