Home > Forum Home > Excel Portfolio Optimization Template > How highly correlated can products be without causing problems? Share

How highly correlated can products be without causing problems?

Excel Help for How Highly Correlated Can Products Be Without Causing Problems? in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

How Highly Correlated Can Products Be Without Causing Problems?

Rate this:
(3/5 from 1 vote)
ConfusedI am trying to optimize a portfolio for which a number of the products turn out to be highly correlated (greater than 99%).  My approach has been to delete one of a highly correlated pair to leave whichever product shows the least correlation with the other products in the portfolio.  How far do I need to carry this process?  I started out with 14 products and removed 2 due to high correlation.  Correlations in excess of 95% remain.  My concern has to do with very small values amplifying round off error and possible near divide by zero if my products are highly correlated.  This could cause the results to be unreliable.  Do you have any rule of thumb regarding how correlated is too correlated?  
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Shocked C'est ainsi que je procède. 
Je saisie 100 colonnes et supprime progressivement les actifs les moins pertinents pour n'en retenir entre 10 et 30.Parfois 3 pour la France. 
 Leloup
 Posted by on
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
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for How highly correlated can products be without causing problems? in the