View Single Post
  #1   Report Post  
Walker
 
Posts: n/a
Default CORRELATION / COVARIANCE MATRIX

Hello all,

I'm stumped on a question and hoping someone can help me out.

When I produce a matrix it gives me only one half of the matrix (Bottom
Left). I realize that the Upper Right half would be a mirror image but I
need both halves in order to construct a Markowitz Optimal Portfolio Model.
I have so much information that copying and pasting will not work. Does
anyone know how to get Excel to produce a complete matrix or if there is an
easy way to build a complete matrix from the data?

Thanks in advance.