Calculating Portfolio Variance using the Variance Covariance Matrix in Excel
https://sites.google.com/view/brian-b...
This is the second video in a series that illustrates how to use the Variance Covariance Matrix to estimate the Portfolio Standard Deviation. Estimating the Variance of the portfolio is important for understanding the benefits of diversification and for also also estimating Value at Risk type metrics etc.
https://goo.gl/aWgRLw