Forum Discussion
Excel Solver
I am wanting to use Excel Solver to find find the weights, standard deviation, and variance at a specific return%. When I go and use solver and click solve the parts in yellow beside the target retur...
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.
Of course not - all results will still be 0.
- 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.
I have no idea.