Trying to find rolling correlation between two time series fields
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Binu_04
5 - Atom
‎05-20-2024
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Labels:
- Labels:
- Dynamic Processing
- Expression
- Workflow
1 REPLY 1
aatalai
14 - Magnetar
‎05-20-2024
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
