Coppock Curve

The Coppock Curve is a long-term price momentum indicator used primarily to identify major bottoms in the stock market. It is calculated as a 10-month weighted moving average of the sum of the 14-month rate of change and the 11-month rate of change.

COPPOCK

=COPPOCK(data, longROC, shortROC, wmaPeriod)

Example Usage

=COPPOCK(A2:F500)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
longROC
Number
The period for the long-term Rate of Change. Default is 14.
 Optional
shortROC
Number
The period for the short-term Rate of Change. Default is 11.
 Optional
wmaPeriod
Number
The period for the Weighted Moving Average (WMA). Default is 10.
 Optional

Returns

A two-column array of dates and their corresponding Coppock Curve values.

Coppock Curve Formula Result in Google Sheets