Aroon Indicator

The Aroon indicator is used to identify whether a security is trending and the strength of the trend. It consists of two lines: “Aroon Up” measures how long it has been since the highest high, and “Aroon Down” measures how long it has been since the lowest low.

AROON

=AROON(data, period)

Example Usage

=AROON(A2:F500, 25)

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. Default is 25.
 Optional

Returns

A multi-column array containing:

  1. Date
  2. Aroon Up: (periods since high / period) * 100.
  3. Aroon Down: (periods since low / period) * 100.
Aroon Formula Result in Google Sheets