View source for ComputeCloud Formula Examples


=== Formulas with just one input Variable <i>V1</i>: ===
<div style="margin:2em; margin-left:6em;">
<table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;">
 <tr>
  <td style="width:25%;font-size:larger;"><b>Purpose</b></td>
  <td style="width:35%;font-size:larger;"><b>Formula</b></td>
  <td style="width:40%;font-size:larger;"><b>Notes</b></td>
 </tr>
 <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr>
 <tr><td>Remove Mean</td><td>V1-Mean(V1)</td><td></td></tr>
 <tr><td>Index to 100</td><td>Index(V1)</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>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 preserving 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>Makes a single point series.</td></tr>
</table>
</div>