Spreadsheet: 849006d1699569882-mmult-formula-for-portfolio-variance-value-error-solver-help
Sheet: Before Solver

 |  |  |  | ELF | MSFT |  |  | TESLA | AAPL
 |  | Mean month
 |  | Standard deviation month
 |  | Mean year
 |  | Standard deviation year
 |  | Weights |  | 0.1234 | 0.4567 |  |  | 0.0987 | 0.3212 |  |  | Weights*STdev |  | 0.06624970179716808 | 0.1004626119260985 | 0.0693793791345541 | 0.1060183342087965
 |  | Weights*STdev
 |  | Correlations |  |  | Column 1 |  |  | Column 2 | Column 3 | Column 4
 |  |  |  | Column 1 | 1 |  |  | 0.4522745645743725 | 0.2730717414070495 | 0.4102839138413171 |  |  |  | 0.06624970179716808
 |  |  |  | Column 2 | 0.4522745645743725 | 1 |  | 1 | 0.5521348870071978 | 0.7112054239541155 |  |  |  | 0.1004626119260985
 |  |  |  | Column 3 | 0.2730717414070495 | 0.5521348870071978 | 1 | 0.5521348870071978 | 1 | 0.6748939558089605 |  |  |  | 0.0693793791345541
 |  |  |  | Column 4 | 0.4102839138413171 | 0.7112054239541155 | 0.6748939558089605 | 0.7112054239541155 | 0.6748939558089605 | 1 |  |  |  | 0.1060183342087965
 |  | Port Mean |  |  | 0.12
 |  | Port Variance
 |  | Port Sigma
STOCK NAME | ELF |  |  | MSFT |  |  |  | TESLA |  | AAPL |  |  | Monthly returns |  |  |  |  | LN(1+Monthly returns)
Date | Open | Close | Date | Open | Close | Date | Date | Open | Close | Open | Close | Date | ELF | MSFT | TESLA | AAPL | Date | ELF | MSFT | TESLA | AAPL
Sep 30, 2023 | 110.35 | 92.63 | Sep 30, 2023 | 316.28 | 338.11 | Sep 30, 2023 | Sep 30, 2023 | 244.81 | 200.84 | 171.22 | 170.77 | Sep 30, 2023 |  |  |  |  | Sep 30, 2023
Aug 31, 2023 | 139.1 | 109.83 | Aug 31, 2023 | 331.31 | 315.75 | Aug 31, 2023 | Aug 31, 2023 | 257.26 | 250.22 | 189.49 | 171.21 | Aug 31, 2023 |  |  |  |  | Aug 31, 2023
Jul 31, 2023 | 116 | 138.71 | Jul 31, 2023 | 335.19 | 327.76 | Jul 31, 2023 | Jul 31, 2023 | 266.26 | 258.08 | 196.24 | 187.87 | Jul 31, 2023 |  |  |  |  | Jul 31, 2023
Jun 30, 2023 | 114.76 | 116.72 | Jun 30, 2023 | 339.19 | 335.92 | Jun 30, 2023 | Jun 30, 2023 | 276.49 | 267.43 | 193.78 | 196.45 | Jun 30, 2023 |  |  |  |  | Jun 30, 2023
May 31, 2023 | 104.71 | 114.23 | May 31, 2023 | 325.93 | 340.54 | May 31, 2023 | May 31, 2023 | 202.59 | 261.77 | 177.7 | 193.97 | May 31, 2023 |  |  |  |  | May 31, 2023
Apr 30, 2023 | 93.2 | 104.02 | Apr 30, 2023 | 306.97 | 328.39 | Apr 30, 2023 | Apr 30, 2023 | 163.17 | 203.93 | 169.28 | 177.25 | Apr 30, 2023 |  |  |  |  | Apr 30, 2023
Mar 31, 2023 | 81.84 | 92.76 | Mar 31, 2023 | 286.52 | 307.26 | Mar 31, 2023 | Mar 31, 2023 | 199.91 | 164.31 | 164.27 | 169.68 | Mar 31, 2023 |  |  |  |  | Mar 31, 2023
Mar 01, 2023 | 75.07 | 82.35 | Mar 01, 2023 | 250.76 | 288.3 | Mar 01, 2023 | Mar 01, 2023 | 206.21 | 207.46 | 146.83 | 164.9 | Mar 01, 2023 |  |  |  |  | Mar 01, 2023
Feb 01, 2023 | 57.39 | 74.75 | Feb 01, 2023 | 248 | 249.42 | Feb 01, 2023 | Feb 01, 2023 | 173.89 | 205.71 | 143.97 | 147.41 | Feb 01, 2023 |  |  |  |  | Feb 01, 2023
Jan 01, 2023 | 56.17 | 57.55 | Jan 01, 2023 | 243.08 | 247.81 | Jan 01, 2023 | Jan 01, 2023 | 118.47 | 173.22 | 130.28 | 144.29 | Jan 01, 2023 |  |  |  |  | Jan 01, 2023
Dec 01, 2022 | 54.88 | 55.3 | Dec 01, 2022 | 253.87 | 239.82 | Dec 01, 2022 | Dec 01, 2022 | 197.08 | 123.18 | 148.21 | 129.93 | Dec 01, 2022 |  |  |  |  | Dec 01, 2022
Oct 31, 2022 | 43.55 | 54.96 | Oct 31, 2022 | 234.6 | 255.14 | Oct 31, 2022 | Oct 31, 2022 | 234.05 | 194.7 | 155.08 | 148.03 | Oct 31, 2022 |  |  |  |  | Oct 31, 2022
Sep 30, 2022 | 38.01 | 43.26 | Sep 30, 2022 | 235.41 | 232.13 | Sep 30, 2022 | Sep 30, 2022 | 254.5 | 227.54 | 138.21 | 153.34 | Sep 30, 2022 |  |  |  |  | Sep 30, 2022
Aug 31, 2022 | 37.95 | 37.62 | Aug 31, 2022 | 258.87 | 232.9 | Aug 31, 2022 | Aug 31, 2022 | 272.58 | 265.25 | 156.64 | 138.2 | Aug 31, 2022 |  |  |  |  | Aug 31, 2022
Jul 31, 2022 | 33.56 | 38.13 | Jul 31, 2022 | 277.82 | 261.47 | Jul 31, 2022 | Jul 31, 2022 | 301.28 | 275.61 | 161.01 | 157.22 | Jul 31, 2022 |  |  |  |  | Jul 31, 2022
Jun 30, 2022 | 30.37 | 33.53 | Jun 30, 2022 | 256.39 | 280.74 | Jun 30, 2022 | Jun 30, 2022 | 227 | 297.15 | 136.04 | 162.51 | Jun 30, 2022 |  |  |  |  | Jun 30, 2022
May 31, 2022 | 26.61 | 30.68 | May 31, 2022 | 275.2 | 256.83 | May 31, 2022 | May 31, 2022 | 251.72 | 224.47 | 149.9 | 136.72 | May 31, 2022 |  |  |  |  | May 31, 2022
Apr 30, 2022 | 24.4 | 26.62 | Apr 30, 2022 | 277.71 | 271.87 | Apr 30, 2022 | Apr 30, 2022 | 286.92 | 252.75 | 156.71 | 148.84 | Apr 30, 2022 |  |  |  |  | Apr 30, 2022
Mar 31, 2022 | 26.13 | 24.33 | Mar 31, 2022 | 309.37 | 277.52 | Mar 31, 2022 | Mar 31, 2022 | 360.38 | 290.25 | 174.03 | 157.65 | Mar 31, 2022 |  |  |  |  | Mar 31, 2022
Mar 01, 2022 | 26.21 | 25.83 | Mar 01, 2022 | 296.4 | 308.31 | Mar 01, 2022 | Mar 01, 2022 | 289.89 | 359.2 | 164.7 | 174.61 | Mar 01, 2022 |  |  |  |  | Mar 01, 2022
Feb 01, 2022 | 29.44 | 26.43 | Feb 01, 2022 | 310.41 | 298.79 | Feb 01, 2022 | Feb 01, 2022 | 311.74 | 290.14 | 174.01 | 165.12 | Feb 01, 2022 |  |  |  |  | Feb 01, 2022
Jan 01, 2022 | 33.26 | 29.56 | Jan 01, 2022 | 335.35 | 310.98 | Jan 01, 2022 | Jan 01, 2022 | 382.58 | 312.24 | 177.83 | 174.78 | Jan 01, 2022 |  |  |  |  | Jan 01, 2022
Dec 01, 2021 | 30.75 | 33.21 | Dec 01, 2021 | 335.13 | 336.32 | Dec 01, 2021 | Dec 01, 2021 | 386.9 | 352.26 | 167.48 | 177.57 | Dec 01, 2021 |  |  |  |  | Dec 01, 2021
Oct 31, 2021 | 32.52 | 30.12 | Oct 31, 2021 | 331.36 | 330.59 | Oct 31, 2021 | Oct 31, 2021 | 381.67 | 381.59 | 148.99 | 165.3 | Oct 31, 2021 |  |  |  |  | Oct 31, 2021
Sep 30, 2021 | 29.27 | 32.31 | Sep 30, 2021 | 282.12 | 331.62 | Sep 30, 2021 | Sep 30, 2021 | 259.47 | 371.33 | 141.9 | 149.8 | Sep 30, 2021 |  |  |  |  | Sep 30, 2021
Aug 31, 2021 | 31.05 | 29.05 | Aug 31, 2021 | 302.87 | 281.92 | Aug 31, 2021 | Aug 31, 2021 | 244.69 | 258.49 | 152.83 | 141.5 | Aug 31, 2021 |  |  |  |  | Aug 31, 2021
Jul 31, 2021 | 27.73 | 30.95 | Jul 31, 2021 | 286.36 | 301.88 | Jul 31, 2021 | Jul 31, 2021 | 233.33 | 245.24 | 146.36 | 151.83 | Jul 31, 2021 |  |  |  |  | Jul 31, 2021
Jun 30, 2021 | 27.31 | 27.61 | Jun 30, 2021 | 269.61 | 284.91 | Jun 30, 2021 | Jun 30, 2021 | 227.97 | 229.07 | 136.6 | 145.86 | Jun 30, 2021 |  |  |  |  | Jun 30, 2021
May 31, 2021 | 28.13 | 27.14 | May 31, 2021 | 251.23 | 270.9 | May 31, 2021 | May 31, 2021 | 209.27 | 226.57 | 125.08 | 136.96 | May 31, 2021 |  |  |  |  | May 31, 2021
Apr 30, 2021 | 30.24 | 28 | Apr 30, 2021 | 253.4 | 249.68 | Apr 30, 2021 | Apr 30, 2021 | 234.6 | 208.41 | 132.04 | 124.61 | Apr 30, 2021 |  |  |  |  | Apr 30, 2021
Mar 31, 2021 | 26.8 | 30.25 | Mar 31, 2021 | 238.47 | 252.18 | Mar 31, 2021 | Mar 31, 2021 | 229.46 | 236.48 | 123.66 | 131.46 | Mar 31, 2021 |  |  |  |  | Mar 31, 2021
Mar 01, 2021 | 26.32 | 26.83 | Mar 01, 2021 | 235.9 | 235.77 | Mar 01, 2021 | Mar 01, 2021 | 230.04 | 222.64 | 123.75 | 122.15 | Mar 01, 2021 |  |  |  |  | Mar 01, 2021
Feb 01, 2021 | 21.74 | 25.65 | Feb 01, 2021 | 235.06 | 232.38 | Feb 01, 2021 | Feb 01, 2021 | 271.43 | 225.17 | 133.75 | 121.26 | Feb 01, 2021 |  |  |  |  | Feb 01, 2021
Jan 01, 2021 | 25.31 | 21.76 | Jan 01, 2021 | 222.53 | 231.96 | Jan 01, 2021 | Jan 01, 2021 | 239.82 | 264.51 | 133.52 | 131.96 | Jan 01, 2021 |  |  |  |  | Jan 01, 2021
Dec 01, 2020 | 22 | 25.19 | Dec 01, 2020 | 214.51 | 222.42 | Dec 01, 2020 | Dec 01, 2020 | 199.2 | 235.22 | 121.01 | 132.69 | Dec 01, 2020 |  |  |  |  | Dec 01, 2020
Oct 31, 2020 | 20.29 | 21.74 | Oct 31, 2020 | 204.29 | 214.07 | Oct 31, 2020 | Oct 31, 2020 | 131.33 | 189.2 | 109.11 | 119.05 | Oct 31, 2020 |  |  |  |  | Oct 31, 2020
Sep 30, 2020 | 18.44 | 20.27 | Sep 30, 2020 | 213.49 | 202.47 | Sep 30, 2020 | Sep 30, 2020 | 146.92 | 129.35 | 117.64 | 108.86 | Sep 30, 2020 |  |  |  |  | Sep 30, 2020
Aug 31, 2020 | 19.76 | 18.37 | Aug 31, 2020 | 225.51 | 210.33 | Aug 31, 2020 | Aug 31, 2020 | 167.38 | 143 | 132.76 | 115.81 | Aug 31, 2020 |  |  |  |  | Aug 31, 2020
Jul 31, 2020 | 17.85 | 19.53 | Jul 31, 2020 | 211.52 | 225.53 | Jul 31, 2020 | Jul 31, 2020 | 96.61 | 166.11 | 108.2 | 129.04 | Jul 31, 2020 |  |  |  |  | Jul 31, 2020
Jun 30, 2020 | 19.06 | 17.86 | Jun 30, 2020 | 203.14 | 205.01 | Jun 30, 2020 | Jun 30, 2020 | 72.2 | 95.38 | 91.28 | 106.26 | Jun 30, 2020 |  |  |  |  | Jun 30, 2020
May 31, 2020 | 17.38 | 19.07 | May 31, 2020 | 182.54 | 203.51 | May 31, 2020 | May 31, 2020 | 57.2 | 71.99 | 79.44 | 91.2 | May 31, 2020 |  |  |  |  | May 31, 2020
Apr 30, 2020 | 12.64 | 17.14 | Apr 30, 2020 | 175.8 | 183.25 | Apr 30, 2020 | Apr 30, 2020 | 50.33 | 55.67 | 71.56 | 79.49 | Apr 30, 2020 |  |  |  |  | Apr 30, 2020
Mar 31, 2020 | 9.64 | 13.07 | Mar 31, 2020 | 153 | 179.21 | Mar 31, 2020 | Mar 31, 2020 | 33.6 | 52.13 | 61.63 | 73.45 | Mar 31, 2020 |  |  |  |  | Mar 31, 2020
Mar 01, 2020 | 16.1 | 9.84 | Mar 01, 2020 | 165.31 | 157.71 | Mar 01, 2020 | Mar 01, 2020 | 47.42 | 34.93 | 70.57 | 63.57 | Mar 01, 2020 |  |  |  |  | Mar 01, 2020
Feb 01, 2020 | 15.72 | 15.96 | Feb 01, 2020 | 170.43 | 162.01 | Feb 01, 2020 | Feb 01, 2020 | 44.91 | 44.53 | 76.07 | 68.34 | Feb 01, 2020 |  |  |  |  | Feb 01, 2020
Jan 01, 2020 | 16.23 | 15.68 | Jan 01, 2020 | 158.78 | 170.23 | Jan 01, 2020 | Jan 01, 2020 | 28.3 | 43.37 | 74.06 | 77.38 | Jan 01, 2020 |  |  |  |  | Jan 01, 2020
Dec 01, 2019 | 16.6 | 16.13 | Dec 01, 2019 | 151.81 | 157.7 | Dec 01, 2019 | Dec 01, 2019 | 21.96 | 27.89 | 66.82 | 73.41 | Dec 01, 2019 |  |  |  |  | Dec 01, 2019
Oct 31, 2019 | 16.88 | 16.57 | Oct 31, 2019 | 144.26 | 151.38 | Oct 31, 2019 | Oct 31, 2019 | 21.09 | 22 | 62.38 | 66.81 | Oct 31, 2019 |  |  |  |  | Oct 31, 2019
Sep 30, 2019 | 17.45 | 16.8 | Sep 30, 2019 | 139.66 | 143.37 | Sep 30, 2019 | Sep 30, 2019 | 16.1 | 20.99 | 56.27 | 62.19 | Sep 30, 2019 |  |  |  |  | Sep 30, 2019
Aug 31, 2019 | 16.3 | 17.51 | Aug 31, 2019 | 136.61 | 139.03 | Aug 31, 2019 | Aug 31, 2019 | 14.94 | 16.06 | 51.61 | 55.99 | Aug 31, 2019 |  |  |  |  | Aug 31, 2019
Jul 31, 2019 | 16.73 | 16.32 | Jul 31, 2019 | 137 | 137.86 | Jul 31, 2019 | Jul 31, 2019 | 16.18 | 15.04 | 53.47 | 52.19 | Jul 31, 2019 |  |  |  |  | Jul 31, 2019
Jun 30, 2019 | 14.27 | 16.59 | Jun 30, 2019 | 136.63 | 136.27 | Jun 30, 2019 | Jun 30, 2019 | 15.35 | 16.11 | 50.79 | 53.26 | Jun 30, 2019 |  |  |  |  | Jun 30, 2019
May 31, 2019 | 10.16 | 14.1 | May 31, 2019 | 123.85 | 133.96 | May 31, 2019 | May 31, 2019 | 12.37 | 14.9 | 43.9 | 49.48 | May 31, 2019 |  |  |  |  | May 31, 2019
Apr 30, 2019 | 12.83 | 10.19 | Apr 30, 2019 | 130.53 | 123.68 | Apr 30, 2019 | Apr 30, 2019 | 15.92 | 12.34 | 52.47 | 43.77 | Apr 30, 2019 |  |  |  |  | Apr 30, 2019
Mar 31, 2019 | 10.64 | 12.79 | Mar 31, 2019 | 118.95 | 130.6 | Mar 31, 2019 | Mar 31, 2019 | 18.84 | 15.91 | 47.91 | 50.17 | Mar 31, 2019 |  |  |  |  | Mar 31, 2019
Mar 01, 2019 | 8 | 10.6 | Mar 01, 2019 | 112.89 | 117.94 | Mar 01, 2019 | Mar 01, 2019 | 20.46 | 18.66 | 43.57 | 47.49 | Mar 01, 2019 |  |  |  |  | Mar 01, 2019
Feb 01, 2019 | 8.4 | 7.95 | Feb 01, 2019 | 103.78 | 112.03 | Feb 01, 2019 | Feb 01, 2019 | 20.36 | 21.33 | 41.74 | 43.29 | Feb 01, 2019 |  |  |  |  | Feb 01, 2019
Jan 01, 2019 | 8.53 | 8.4 | Jan 01, 2019 | 99.55 | 104.43 | Jan 01, 2019 | Jan 01, 2019 | 20.41 | 20.47 | 38.72 | 41.61 | Jan 01, 2019 |  |  |  |  | Jan 01, 2019
Dec 01, 2018 | 12.89 | 8.66 | Dec 01, 2018 | 113 | 101.57 | Dec 01, 2018 | Dec 01, 2018 | 24 | 22.19 | 46.12 | 39.44 | Dec 01, 2018 |  |  |  |  | Dec 01, 2018
Oct 31, 2018 | 10.68 | 12.76 | Oct 31, 2018 | 107.05 | 110.89 | Oct 31, 2018 | Oct 31, 2018 | 22.55 | 23.37 | 54.76 | 44.65 | Oct 31, 2018 |  |  |  |  | Oct 31, 2018