Tuesday, September 27, 2011

How do you calculate the inter correlations of a number of investments?

I am aware that one can use the MMULT formula in excel but I would like to understand how to calculate the Covariance of returns between one group of funds and another to calculate the portfolio Standard Deviation made up of a group of funds - on paper not with a computer.|||The basic maths behind the 'magic Excel formula' is usually spelled out in Wikipedia ..





(one look at the maths behind Standard Deviations %26amp; you will understand why no-one uses pen %26amp; paper anymore :-) )

No comments:

Post a Comment