DEUSHARVEST
Average True Range (ATR)
The Average True Range (ATR) is a technical analysis indicator, developed by J. Welles Wilder Jr., used to measure market volatility. It quantifies the degree of price movement by taking the average of the ‘true range’ over a specified number of periods. A higher ATR value indicates higher market volatility, while a lower ATR signifies a period of lower volatility or consolidation. Importantly, ATR does not provide an indication of price direction, only the magnitude of its movement.
ATR
=ATR(data, period) Example Usage
=ATR(A2:F500, 14)
Parameters
| Parameter | Type | Description | Status |
|---|---|---|---|
data | Range | Range of columns containing the date, Open, high, Low, close, volume data. | Required |
period | Number | Number of (periods) days over which to calculate the ATR. | Required |
Returns
A two-column array of dates and their corresponding ATR values.
