ComputeCloud Formula Examples

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 preserving the Periodicity and dates.
Average just the latest 10 points of a Series	v1-v1+mean(extract(V1,length(V1)-9,10))	Makes a single point series.