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?