ROLLINGAVERAGE

Calculates the rolling averages of a column

ROLLINGAVERAGE(column, window, [Minimum Period])

Returns the rolling averages, weighted with specified inputs, in a column.

Arguments

Argument

Description

column

Column on which to compute the rolling average. Must be numeric.

window

Size of rolling window for calculating the rolling averages.

[Minimum Period]

Minimum number of observations to calculate an output. Defaults to window size.

Outputs

Weighted rolling averages.

Example

Last updated