Difference between revisions of "ComputeCloud Formula Examples"
From dataZoa Wiki
| Line 17: | Line 17: | ||
</table> | </table> | ||
</div> | </div> | ||
| + | [[Category:Calculations]][[Category:Creating]][[Category:Advanced]] | ||
Latest revision as of 11:31, 24 January 2019
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. |
