enter image description here


So I was asked to calculate the maximum sharpe ratio using solver in excel but it gave me really big numbers for the portfolio weights. So I was wondering what is a good constraint to add and why is it bad or if it is even feasible to have portfolio weights so heavily in a long or short position?


  • 1
    $\begingroup$ if your issue is large portfolio weights then consider ridge regression or lasso regression. They are both regularisation techniques which you can investigate on wikipedia $\endgroup$
    – Attack68
    Oct 13, 2020 at 5:12
  • $\begingroup$ You can also add constraints for the following: 1. Beta of the portfolio 2. Volatility of the portfolio (Standard Deviation) 3. Leverage of the portfolio, as defined as sum(abs(weight)) $\endgroup$
    – JPN
    Oct 13, 2020 at 12:46
  • $\begingroup$ Don’t use excel if you want to be taken seriously. R and python both have really good libraries (eg cvtopt or scipy) to optimize including constraints. $\endgroup$
    – user50421
    Oct 17, 2020 at 2:20


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.