Donchian Channels

Donchian Channels are a volatility indicator that identifies the high and low price ranges over a specific period of time. They consist of three lines: the Upper Channel (highest high), the Lower Channel (lowest low), and the Basis (average of the upper and lower channels). They are widely used to identify breakouts and trend reversals.

DONCHIAN

=DONCHIAN(data, period)

Example Usage

=DONCHIAN(A2:F500, 20)

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 lookback period for finding the highest high and lowest low. Default is 20.
 Optional

Returns

A multi-column array containing:

  1. Date
  2. Upper: The highest price over the last n periods.
  3. Basis: The average of the Upper and Lower bands.
  4. Lower: The lowest price over the last n periods.
Donchian Channels Formula Result in Google Sheets