I'm trying to use a template to see what it says about my stock portfolio. it uses a covariance mattrix 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 didnt work. =MMULT(TRANSPOSE('Excess Returns'!B3:F252),'Excess Returns'!B3:F252)/251 ive got 5 stocks and 249 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. do you anyone no what i am doing wrong or a better way of doing it?
Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by Ted via Recent Questions - Web Applications Stack Exchange
No comments:
Post a Comment