Sunday, December 22, 2019

Given a correlation martrix, calculate portfolio's correlation with its assets


Find correlation vector like [def] where d, e and f represent correlation of P(portfolio) with its assets A, B and C respectively. The assets A, B, C can be another portfolio.


In order for that, is it possible to find a correlation matrix including the portfolio along with its asset, given the correlation matrix for the assets in the portfolio? For example, for 3 assets A,B, C you have correlation matrix as (1aba1cbc1) Now, using this or some other data concisely get a new correlation matrix for assets A,B,C, and P(for portfolio) like (1abda1cebc1fdef1)


Solution: The real interest is getting the [def] vector, which can be generalized in matrix form. Let P be combined portfolio consisting of N assets or sub portfolios. Let Vector Cov(P)= [Cov(P,1) Cov(P,2) ... Cov(P,N)]', Σ is the variance covariance matrix of portfolio P, and vector w=[w(P,1) w(P,2) ... w(P,N)] then Cov(P)=Σw D=diag(sqrt(diag(Σ)) Corr(P)=D1Cov(P)D1



Answer



It's probably easiest to think about it in terms of a covariance matrix and then convert it to a correlation matrix after. If instead of the first matrix you have some covariance matrix of the assets Σ, then you could get the portfolio variance, for one portfolio, as wΣw, where you could have w(w1,w2,w3). Alternately, you could construct a matrix W, such that W[Iw], where I is a 3×3 identity matrix in your case (but really could be something more general). Calculating WΣW would give you a matrix such that the top left 3×3 is the original covariance matrix and then is appended with the variance of the portfolio and its covariance with the securities. You can then convert the covariance matrix to a correlation matrix to have the final result you want.


No comments:

Post a Comment

technique - How credible is wikipedia?

I understand that this question relates more to wikipedia than it does writing but... If I was going to use wikipedia for a source for a res...