I want to optimize the return of my portfolio using solver with the following constraints
i) total portfolio size
ii) minimum number of funds
iii) each fund has a minimum investment threshold. This is particularly difficult to implement; I tried to set the constraint to great than or equal to, however the solver understands this as a must investment. I need to adjust it so that if it will give me the optimal solution it must invest at least the minimum amount and not consider it as mandatory investment.
Bookmarks