Home > Forum Home > Excel Portfolio Optimization Template > How highly correlated can products be without causing problems? > Correlation magnitude rules for optimization Share

Correlation magnitude rules for optimization

Excel Help for Correlation Magnitude Rules For Optimization in Excel Portfolio Optimization Template


Forum TopicLogin

Correlation Magnitude Rules For Optimization

Rate this:
(3/5 from 1 vote)
ConfusedThere is no rule of thumb regarding correlation magnitude that we know of. Logically this would depend on the other correlations within the matrix. If two products are highly correlated but negatively correlated to other products, one would expect them to be weighted accordingly to their independent risk and return dynamics accordingly under the maximum Sharpe ratio for the portfolio. The correlation is only one attribute contributing to the optimal weighting as average return and standard deviation of returns for each product are also factors.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Correlation magnitude rules for optimization in the