ComputeCloud Formula Examples
From dataZoa Wiki
Formulas with just one input Variable V1:
| Purpose | Formula | Notes |
| Simple 10 Point Moving Average | Movavg(V1,10) | |
| Remove Mean | V1-Mean(V1) | |
| Index to 100 | Index(V1) | |
| Percent Change | Index(v1)-100 | |
| Convert to Quarterly | SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim') | Many details to consider in Periodicity conversions! |
| Replicate a series but with a constant value | (v1-v1)+3.14159 | Subtracting V1 from itself gives a series with all zeroes but preserves the Periodicity and dates. |
| Average just the latest 10 points of a Series | v1-v1+mean(extract(V1,length(V1)-9,10)) | Preserves Periodicity and dates. |
