Fill

Syntax

Fill(Input: ITimeSeries,
     Method: MsFillMethod,
     NumberOfPoints: Integer,
     SpecifiedValue: Double,
     AdditionalSeries: ITimeSeries,
     FillBound: MsFillBoundType)

Parameters

Input. Output variable

Method. Missing data treatment method

NumberOfPoints. An additional parameter for the missing data treatment method, which determines the number of points or periods (depending on the method used). Optional parameter. By default the parameter is 1.

SpecifiedValue. Value to treat missing data. Parameter is used for the Specified Value method. Optional parameter. By default the parameter is 0.

AdditionalSeries. The variable, which values are used for missing data treatment. The parameter is used for the Pattern Overlay methods. Optional parameter. By default parameter is set to Null

FillBound. Period of missing data substitution. Optional parameter. By default the parameter is set to MsFillBoundType.EndForecast - missing data is substituted up to the end of the forecast period.

Description

It fills in empty series values using various methods of missing data treatment.

Comments

The NumberOfPoints parameter can take only positive values. The parameter is relevant for the following missing data treatment methods:

NPointsAverage. N-point average. InterpolateParam determines the N, that is the number of neighbor points
PreviousGrowthRate. SucceedingGrowthRate. Growth rate to previous or succeeding period. InterpolateParam determines the number of periods.

Example

Formula	Result	Application
= Fill({Brazil\|BCA}, MsFillMethod.Pattern, 0, 0, {China\|BCA}, MsFillBoundType.EndIdentify)	Pattern interpolation using the pattern specified with the China\|BCA time series is used to substitute missing data at the sample period for the Brazil\|BCA time series.	It can be used in formulas of calculated series of time series database and in formulas of attribute-based models.
= Fill(X1,MsFillMethod.Value)	The random value from interval [minimum value of the X1 series; maximum value of the X1 series] is used for filling of empty points of the X1 factor.	It can be used in model formulas of modeling container.