Matrix with squared differences

[Grotifant]

Dear all,

I've to create a matrix that gives me the squared differences between two time series. For example, for the below two series the sum of the squared differences between the two series would be:

____A___________B_______(A-B)^2)____
0.990234375 0.991675916 2.07804E-06
1.021972656 1.027469478 3.02151E-05
1.022460938 1.045504994 0.000531029
Sum (A-B)^2 = 0.000563322


The problem is that I have to create a matrix with 250 time series that gives the the sum of the squared differences for each possible pair. Therefore I'd like to create a VBA code that does this calculation for me.

I would greatly appreciate any help on this as I'm a VBA newby and don't know how to get started on this.

Thank you very much.

Rgds,
Manuel