Hi all,

I'm new to this forum so bear with me. I have a macro written thus far that automatically pulls dates into the first column, and then after a series of calculations, pulls two different sets of data into the second and third column.

What I need to do:

Write code to be able to calculate rolling correlations (so for instance, a rolling 30 day correlation from date x to date y)