Keltner Channels

Keltner Channels are volatility-based envelopes set above and below an Exponential Moving Average (EMA). The width of the channels is determined by the Average True Range (ATR). They are used to identify trend direction, reversals, and breakouts.

KELTNER

=KELTNER(data, length, mult)

Example Usage

=KELTNER(A2:F500, 20, 2)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
length
Number
The period for the EMA and ATR calculations. Default is 20.
 Optional
mult
Number
The multiplier for the ATR to determine the channel width. Default is 2.
 Optional

Returns

A multi-column array containing:

  1. Date
  2. Upper: EMA + (ATR * mult).
  3. Basis: The Exponential Moving Average (EMA).
  4. Lower: EMA - (ATR * mult).
Keltner Channels Formula Result in Google Sheets