i noticed something with the excel sheet for this exercise - portfolio var.xls. the non-diagnol elements of the var-cov matrix are supposed to contain the covariances, right? but in the file, the cells D12 & E11 have just been assigned the value of the correlation from cell D9. perhaps you forgot to multiply it with the individual standard deviations? correct me if i'm wrong.
Great video.. Thanks David..
manchesterunitedvind 2 years ago
hi david,
i noticed something with the excel sheet for this exercise - portfolio var.xls. the non-diagnol elements of the var-cov matrix are supposed to contain the covariances, right? but in the file, the cells D12 & E11 have just been assigned the value of the correlation from cell D9. perhaps you forgot to multiply it with the individual standard deviations? correct me if i'm wrong.
srikbond 3 years ago
brutal
shkdgg 3 years ago