Average True Range (ATR)


Calculates market volatility using True Range values over a specified period.

Function Syntax

=ATR(data, period)  
  • data (array):
    Range of columns containing the date, Open, high, Low, close, volume data.
  • period (number):
    Number of (periods) days over which to calculate the ATR.

Returns:
A two-column array of dates and their corresponding ATR values.

Output Example

Below is an example of the resulting array when applying the custom =ATR() function.

atr return array