Home > Forum Home > Excel Portfolio Optimization Template > Questions > Min and Max constraints Share

Min and Max constraints

Excel Help for Min And Max Constraints in Excel Portfolio Optimization Template


Forum TopicLogin

Min And Max Constraints

Rate this:
(3/5 from 1 vote)
ConfusedIndeed the risk/return for the entire portfolio would have to be recalculated after adding back the newly weighted assets.

The minimum and maximum constraints work by ignoring portfolio iterations that fall outside of the prescribed constraints.  We have just tested this with one product at both Min and Max of 10% which held for the optimal portfolio.   If there are too many constraints (i.e. on other assets), it may be impossible to find weightings with a better return/risk profile.  Could this be the case?

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Min and Max constraints in the