INIT

The numerical value of the recursive function at time (t-1).

The numerical value of the recursive function at time (t-n), where n is the parameter number. This parameter can be repeated multiple times to provide initial values for an indefinite number of previous time steps.

column

A column of numerical values. The first cell will be assigned to the time step (t-1), the second cell value to (t-2), and so on.

Description

INIT specifies the initial values for a recursive function definition. The first provided value is assigned to the time step (t-1), the second to (t-2), and so on. If a time step is not initialized using INIT, its value is assumed to be zero. For example, given the statement

V1 = INIT(1, 2, 3)

the value for time step (t-4) is zero (as are all other time steps further back in time). An INIT statement is required before defining any recursive function.

To initialize all values to zero, you can simply specify INIT() without any arguments.

The INIT macro function does not return any values. If used alone in a function definition, it returns a blank column.

Examples

TEMP = INIT() t = 1 to 10 TEMP = 1 + TEMP[t-1]

Creates a new column named TEMP containing the values 1-10.

TEMP = INIT(1) t = 1 TO 100 TEMP = TEMP[t-1]+TEMP[t-1]

Creates a new column named TEMP containing the values 2, 4, 8, 16, 32, and so on. The first 100 cells of TEMP will contain values.

TEMP = INIT(1, 2, 3, 4, 5) t = 1 to 500 TEMP = TEMP[t-5]

Creates a column named TEMP containing the sequence of values 5, 4, 3, 2, 1 repeated 100 times.

TEMP = INIT(1, 2, 3) t = 1 to 1000 TEMP = 2*TEMP[t-1] + 4*TEMP[t-2]^2 - TEMP[t-3]

Creates a new column named TEMP containing values for the cursive function:

1000 cell values are computed.

Related Functions

Function	Description
TO	Generate range operator