Home > Forum Home > Excel Portfolio Optimization Template > Is there a max number of products per optimised portfolio? Share

Is there a max number of products per optimised portfolio?

Excel Help for Is There A Max Number Of Products Per Optimised Portfolio? in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Is There A Max Number Of Products Per Optimised Portfolio?

Rate this:
(3/5 from 1 vote)
ConfusedHi.  Just bought the worksheet and everytime I optimise a 30-product portfolio it always returns a portfolio with 18 on it.  This, despite having min constraint at higher than 0%.  Is there a setting I need to adjust so I can use all the products in the optimised portfolio?

Thanks!

 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Fedup
Rate this:
(3/5 from 1 vote)
The template is limited to 30 investment products.  You must make sure that all product tiles in row 6 are filled in so that the prgram takes into account the product data.

If you require more assistance, please reply to the email you will recieve for notification of this post with your template attached so that we can investigate and resolve this issue as soon as possible for you.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Is there a max number of products per optimised portfolio? in the