Skip to main content

PGrow

Use this function to calculate successive values as a percentage, growing the values from one instance to the next.

Each successive value is calculated as follows:

V1

V2

V3

Open

Open*(1 + rate)

Open*(1 + rate)*(1 + rate)

This function must be used with the BY function. The BY function determines the dimension in which the successive values are calculated.

Syntax:

PGROW(OpenValue,Rate[, Periods])

where:

  • OpenValue is the opening value, which will be placed in the first symbol in the range.
  • Rate is the growth rate used, which can be negative.
  • Periods is optional and is the number of values calculated, if not specified, values are calculated for the entire range of the BY dimension.

Syntax example:

CdnSls = PGROW(CdnSls, 20, 4)

See also

Was this article helpful?

We're sorry to hear that.