| Home > Forum Home > Excel Portfolio Optimization Template > Still not working ! | Share |
Still not working !
Excel Help for Still Not Working ! in Excel Portfolio Optimization Template
| Forum Topic | Post Reply Login |
Still Not Working ! | Rate this: (3/5 from 1 vote) |
 | Hi , I am running the portfolio optimization for my portfolio and I see that every time I run it with additonal week of prices , I get major changes in the exisitng weights of assets. i understand that this influenced by the optimization algorithm but is there a way I can restrict the change in weights so that they do not change by more than say plus/minus 2%? I get theoretical weight changes from 1% to 6% , which is shooting up my trading costs. Best, Hansy | |
| Posted by hansy7 on | ||
| Replies - Displaying 1 to 3 of 3 | Order Replies By: Most recent | Chronological | Highest Rated |
 | Rate this: (3/5 from 1 vote) |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) Is there any other way to control this. I am getting values like 6000 trades which is enormous. I used the min/max limit too restrict the weight range but that doesn't work either. I was thinking more on the lines of having a condition wherein I could put contraints on the weight changes recommended. That way my portfolio might not be 100% optimum but it will still give me a better Sharpe ratio and trades that are manageable. Please help! Best, Hansy |
| Posted by hansy7 on |
 | Rate this: (3/5 from 1 vote) |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Still not working ! in the Excel Business Solutions Directory |