Average Directional Index (ADX)

The Average Directional Index (ADX) is used to quantify trend strength without regard to trend direction. It is derived from the Smoothed Moving Average of the Expanding Ranges (True Range). ADX is typically used with the Plus Directional Indicator (+DI) and Minus Directional Indicator (-DI) to identify the direction of the trend.

ADX

=ADX(data, period)

Example Usage

=ADX(A2:F500, 14)

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 for the smoothing of the direction lines and the ADX itself. Default is 14.
 Optional

Returns

A multi-column array containing:

  1. Date
  2. ADX: The trend strength.
  3. +DI: The Positive Directional Indicator.
  4. -DI: The Negative Directional Indicator.
ADX Formula Result in Google Sheets