Percent Change (PCTCHANGE)

Percent Change (PCTCHANGE) measures the percentage difference between the current price and a past price. It is the simplest form of momentum and is identical to a Rate of Change (ROC) calculation where the result is typically expressed as a decimal (e.g., 0.05 for 5%).

PCTCHANGE

=PCTCHANGE(data, period)

Example Usage

=PCTCHANGE(A2:F500, 1)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
period
Number
The number of periods to look back. Defaults to 1 (daily return).
 Optional

Returns

A two-column array of dates and their corresponding percent change values.

Percent Change (PCTCHANGE) Formula Result in Google Sheets