Portfolio optimization inputs

Excel Help for Portfolio Optimization Inputs in Excel Portfolio Optimization Template

Portfolio Optimization Inputs

Rate this: (4/5 from 2 votes)

	To hold weightinga at current level you should probably omit them from the analysis then add them back into the optmized weightings of the remaining products in the portfolio.  Alternatively, you can use the miminum constraint to ensure that they do not fall below the current level. If the frequency is monthly you should try and use the 30 day treasury rate for the risk free rate.  For annual rates, you should divide by 12.
	Excel Business Forums Administrator
	Posted by Excel Helper on 12 Feb 2007

View Full Post