How to build an extensible n-asset correlation matrix
Channel: Matt Nelson, MBA
Date: 2012-10-18

Hello, I'm Matthew Nelson and in this video I demonstrate how to build a n-asset correlation matrix in Microsoft Excel using relative points of reference. By using the OFFSET function, we create a completely extensible and self-adjusting table that correlates asset returns in a n-asset portfolio. By programming only one universal function just one time, we are free to focus on asset selection and changes rather than actively manage a nasty table that requires manual range selection.

Thanks for watching! Please subscribe, like, and comment.

*********
LinkedIn profile: http://www.linkedin.com/in/mattnelsoncontroller

Resume: http://1drv.ms/1WVHh4c

Spreadsheet: http://1drv.ms/1TRFTS8

CE Credit Fund (Bitcoin tip jar): 1QAG5wfxeFW1iC5mE7DmQBZhJUB7NVgNXq