Hello,
I recorded a macro in the attached file that computes a rolling correlation of a price series (column B) against a series of ascending numbers (column C). The macro then plots a histogram using the data analysis function.
It was recorded using 100 rows of price data. If the input data has fewer than 100 rows, the macro will have an error. May I know how I can tweak the code to make it independent of the number of rows of input data? i.e. It will run the correlation until the last row of prices for any number of rows.
Thank you for your guidance.
Bookmarks