Summation [Sum]

Return to Complete List of Functions

The Summation function adds together the values of a data series over a given period. Parameters ------------------ Data          The data to use in the calculation. This is typically a field in a data series or a calculated value. Period        The number of bars of data to include in the sample, including the current value.                   For example, a period of 3 includes the current value and the two previous values. Note: An end point to the Period parameter can be simulated using the Lag function to obtain a previous value of this function. See the notes for the Lag function for more information. Function Value ------------------------ This function adds together the values of a data series over a given period. This is useful for creating moving averages and other calculations which include more than one previous value. The summation at the beginning of a data series is not defined until there are enough values to fill the given period. Data    Sum(Data,3) --------------------------------   0   1   2               3   4               7   8               14   7               19   6               21 The summation function can also be used with the Summation Bars Ago function or the Summation Index function to vary the processing of the elements. See the description of those functions for more information.