Dynamic Covariance Matrix

Good afternoon,

I am trying to construct a series of covariance matrices, I know they can be done using the data analysis tool pack but I need it to be able to update dynamically. I could write the formula for each cell manually but that will take a very long time. So I am trying to find a way to write a single formula which I can drag down and across.

I have attached a sheet to this post showing the format I have the data in, it is sorted by columns for each time point.

Thanks in advance for any help you can offer.

Kind regards,

Dave