Forum Discussion

HansVogelaar's avatar
HansVogelaar
MVP
Oct 20, 2020

madpak2 

There must be something missing - all other weights are set to 0, so all weighted calculations will return 0 regardless of the values in Q3:Z3.

madpak2's avatar
madpak2
Copper Contributor
Oct 20, 2020
I went and changed the weights in q3:z3 to having nothing in them and I am still not able to have any of the information changed.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 20, 2020

    madpak2 

    Of course not - all results will still be 0.

    • madpak2's avatar
      madpak2
      Copper Contributor
      Oct 20, 2020
      Then how do I get it to solve for the weights, standard deviation, and variance at a specific return%? I got it to work on another document with just 4 stocks.

Resources