Home > Forum Home > Excel Portfolio Performance Tracking Template > Portfolio Performance Monitoring and Valuation > Portfolio optimization points Share

Portfolio optimization points

Excel Help for Portfolio Optimization Points in Excel Portfolio Performance Tracking Template


Forum TopicLogin

Portfolio Optimization Points

Rate this:
(4/5 from 2 votes)
Surprised These questions actually relate to the portfolio optimization template and not the monitoring template.  To respond to the points raised:
  1. Ranking assets can be done by modifying returns in the correlation matrix before optimization. Higher expected future returns will force higher weightings depending on risk (standard deviation).
  2. We can set minimum and maximum constraints to set some assets to be the same weight as current thereby essentially removing them from optimization.
  3. Once optimization has run, we can select points along the efficient frontier to a selected risk amount for example.
  4. Setting a minimum weighting of 30% for one asset will constrain the optimization to have at least that weighting.
 
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Portfolio optimization points in the