Contents x
      MovingAverage
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      MovingAverage

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Calculates a moving average across a configurable number of rows

      Purpose

      Use this function to:

      • Calculate rolling averages for various intervals


      Parameters

      ParameterDescription
      Column NameThe name of the output column
      ColumnThe source column to use when calculating the MovingAverage
      Interval

      The number of rows to include in the average.

      • If Interval = 2, Avg = [Row(X) + Row(X-1)] / 2
      • If Interval = 3, Avg = [Row(X) + Row(X-1) + Row(X-2)] / 3
      Plot Axis0 / 1.  Y-Axis to use when plotting graph. Default = 0
      Plot As

      Bar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose

      Determines the graph style for the output column.

      PlotY / N. Specifies whether measure’s output column should be plotted on graph. Default = Y
      Popup ModeDefault / None / Extended
      Prefix£ / $ / E / %


      Examples





      MovingAverage is a more flexible version of Post Function 7avg.  Whereas 7avg always calculates intervals of 7, MovingAverage can be used to calculate other intervals. 


      Was this article helpful?
      What's Next