Suppose you set up the Solver in EXCEL to minimize the stand…
Suppose you set up the Solver in EXCEL to minimize the standard deviation of a portfolio by varying the portfolio weights on several asset classes. The only constraint you impose in the Solver is that the portfolio weights sum up to 1. There is no constraint on the expected return of the portfolio. The portfolio found by the EXCEL Solver is:
Read Details