GAPFILL()

Definition Fill gaps. gapfill() closes any gaps in a data series using a value based on an expression you provide. (If the GAPFILL() function is not used, gaps are filled using the preceding non-gap value.)

Syntax images/aspen00000279.gif

Formula NA

Parameters SERIES
Required if the formula name declares the SERIES parameter.

INPUT
Required if the formula name declares the INPUT parameter.

<fill>

Specifies a value for use in replacing data gaps. If the fill value is not specified, the value of the preceding non-gap bar is used to fill the gap.