In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Trying to find rolling correlation between two time series fields

Binu_04
5 - Atom

I have a time series data, lets say close prices of S&P 500 and microsoft over the last two years. What I have to do is pretty simple - calculate rolling 7 day, 30 day and 90 day correlations for this dataset.
Doing this in MS excel is pretty simple by writing the regular formula, but finding some trouble implementing the same in Alteryx!

1 REPLY 1
aatalai
14 - Magnetar

@Binu_04 Have you found the rolling 7/30/90 days averages/ values? If not try looking at the crew macros moving summarize, after which tehn start looking at the time series tool.

 

http://www.chaosreignswithin.com/p/macros.html

 

Let me know how you get on

 

 

Labels
Top Solution Authors