Home > Forum Home > Excel Portfolio Optimization Template > problems creating the optimal portfolio analysis > Minimum and maximum constraints Share

Minimum and maximum constraints

Excel Help for Minimum And Maximum Constraints in Excel Portfolio Optimization Template


Forum TopicLogin

Minimum And Maximum Constraints

Rate this:
(3/5 from 1 vote)
SadIt could be that the minimum and maximum constraints and maintain return level are set so that the optimal portfolio cannot be created from the current one. Try removing these and running the optimization.  If you land on the CoVar sheet then the option has been selected to modify the matrix and you will need to click to optimize again from there.


If the status bar at the bottom shows the process stages working then the program is running.  If not, then there is still an issue with the macro settings.

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Minimum and maximum constraints in the