Difference between revisions of "ComputeCloud Formula Examples"
From dataZoa Wiki
(→Formulas with just one input Variable:) |
|||
| Line 4: | Line 4: | ||
<table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;"> | <table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;"> | ||
<tr> | <tr> | ||
| − | <td style="width: | + | <td style="width:20%;font-size:larger;"><b>Purpose</b></td> |
| − | <td style="width: | + | <td style="width:30%;font-size:larger;"><b>Formula</b></td> |
| − | <td style="width: | + | <td style="width:50%;font-size:larger;"><b>Notes</b></td> |
</tr> | </tr> | ||
<tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr> | <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr> | ||
| Line 13: | Line 13: | ||
<tr><td>Percent Change</td><td>Index(v1)-100</td><td></td></tr> | <tr><td>Percent Change</td><td>Index(v1)-100</td><td></td></tr> | ||
<tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td><td>Many details to consider in Periodicity conversions!</td></tr> | <tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td><td>Many details to consider in Periodicity conversions!</td></tr> | ||
| − | <tr><td>Replicate a series but with a constant value</td><td>(v1-v1)+3.14159</td><td>Subtracting V1 from itself gives a series with all zeroes but | + | <tr><td>Replicate a series but with a constant value</td><td>(v1-v1)+3.14159</td><td>Subtracting V1 from itself gives a series with all zeroes but preserves the Periodicity and dates.</td></tr> |
| − | <tr><td>Average just the latest 10 points of a Series</td><td>v1-v1+mean(extract(V1,length(V1)-9,10))</td><td> | + | <tr><td>Average just the latest 10 points of a Series</td><td>v1-v1+mean(extract(V1,length(V1)-9,10))</td><td>Preserves Periodicity and dates.</td></tr> |
| − | </table> | + | </table> |
</div> | </div> | ||
Revision as of 11:26, 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. |
