I'm trying to use a template to see what it says about my stock portfolio. It uses a covariance matrix with the data from excess returns. The template instructions say to use an add-on to calculate the matrix but the add-on doesn't work. I tried a formula but it didn't work. =MMULT(TRANSPOSE('Excess Returns'!B3:F252),'Excess Returns'!B3:F252)/251

I've got 5 stocks and 250 dates of data. in a video I watched on how to make a matrix it says to highlight the 5x5 matrix and hit control shift enter and it will apply the formula to the grid but it doesn't work.

Does anyone know what I am doing wrong or a better way of doing it?

covariance matrix with formula

adjusted matrix with freedom added

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.