Average True Range

The average true range is a technical indicator used to measure volatility by decomposing the range of asset price for a period (generally 14 days)

How calculated

Moving average of true range

Example usage

=AverageTrueRange("MSFT") - Returns ATR value for 14 day period
=AverageTrueRange("MSFT",30) - Returns ATR value for 30 day period
=AverageTrueRange("MSFT",30,"9/1/2021") - Returns ATR value for 30 day period with start date 1 September 2021


A stock with a high level of volatility has a higher ATR, and a low volatility stock has a lower ATR.


Stocks ETFs Mutual Funds Currencies Cryptocurrencies

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!