Rate of Change (ROC)

Rate of Change (ROC) is a pure momentum oscillator that measures the percentage change in price from one period to the next. The ROC calculation compares the current price with the price “n” periods ago.

ROC

=ROC(data, period)

Example Usage

=ROC(A2:F500, 9)

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 (e.g., 9 or 12).
 Required

Returns

A two-column array of dates and their corresponding ROC percentage values.

Rate of Change (ROC) Formula Result in Google Sheets