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