Portfolio Optimization Software

I'm thinking of putting together a portfolio of about 10 ETFs, and I'd like to try Mean-Variance Optimization to establish the component weights. Has anyone tried this? With satisfactory or unsatisfactory
results? What software can you recommend? How easy or difficult was it?
Dave
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

This can be done in Excel -- search online for spreadsheets. Probably you want to impose a long-only constraint. If your expected return estimates are from trailing returns, the expected returns for many stock ETFs may be negative, and the optimizer will tell you not to own them. You should come up with your own expected return estimates, perhaps based on your estimate of the equity risk premium.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.