Hi Henrique,

Tks for replying

The data file structure is csv of text file below

The actual file has 6000 rows and 100 columns

The first column is date and second to 100 columns are name d1 to d100

Some columns have blank with no data

Date	d1	d2	d3	d4	d5	d6	d7	d8
2/8/2011	0.064711		0.001324		0.000586			0.001102
2/9/2011	0.065808		0.001365		0.000667			0.001101
2/10/2011	0.06506		0.0015		0.000652			0.001093
2/11/2011	0.06511		0.001492		0.000615	0.001886		0.001072
2/14/2011	0.063594		0.001514		0.000629	0.00184		0.001113
2/15/2011	0.063345	0.0577	0.00147		0.000593	0.001374		0.001258
2/16/2011	0.064223	0.05828	0.00147		0.000523	0.00142		0.001145
2/17/2011	0.062627	0.05525	0.001484	0.000523	0.00041	0.001542		0.00159
2/18/2011	0.062208	0.05525	0.001431	0.00041	0.000401	0.001145	0.001709	0.001568
2/22/2011	0.061251	0.05502	0.001474	0.000401	0.000452	0.00159	0.001925	0.001367
2/23/2011	0.060523	0.05442	0.00148	0.000452	0.000502	0.001568	0.001557	0.05458
2/24/2011	0.061141	0.05458	0.001457	0.001382	0.000463	0.001367	0.001584	0.05534
2/25/2011	0.062448	0.05534	0.001453	0.001075	0.000532	0.001382	0.001217	0.05558
2/28/2011	0.062498	0.05558	0.001404	0.001382	0.000431	0.001075	0.001418	0.05515
3/1/2011	0.062448	0.05515	0.001384	0.001075	0.000465	0.001101	0.001264	0.05591
3/2/2011	0.062837	0.05591	0.001391	0.001285	0.000529	0.001293	0.001152	0.064223
3/3/2011	0.064272	0.05655	0.001404	0.001268	0.000565	0.001429	0.001101	0.062627
3/4/2011	0.063604	0.05638	0.001374	0.001235	0.00056	0.001208	0.000951	0.062208
3/7/2011	0.062866	0.05538	0.001354	0.00125	0.00049	0.001153	0.0012	0.061251
3/8/2011	0.063893	0.056	0.001406	0.001244	0.000576	0.001613	0.001185	0.060523
3/9/2011	0.064322	0.05596	0.001393	0.001205	0.000602	0.00142	0.000938	0.05638

Want to do is to use a rolling 10 rows data points or 20 rows data or other custom number of rows data points to compute the corr between the d1 - d100 columns

Tks