ATR Calculation

ATR and True Range Calculation

ATR (Average True Range), as its name suggests, is the average of True Range. If you want to understand and calculate ATR, you first need to understand and calculate True Range.

Calculating ATR from True Range

When you want to calculate Average True Range from True Range data, you need to average the ranges of individual bars. There are several different methods for that and the three most common are the following:

1. Simple Moving Average (“Simple MA” in the calculator) is mathematically arithmetic average – the sum of last n bars divided by n:

Average True Range formula (simple moving average)

… where:

n is the ATR period length

TRi is True Range i bars ago

2. Exponential Moving Average (“Exponential MA”) puts greater weight on the most recent bars and smaller weight on older bars:

Average True Range formula (exponential moving average)

… where:

TR0 is True Range for the current bar

ATR1 is ATR calculated for the previous bar

a is the smoothing factor, which is a function of the period length (n):

Average True Range formula (exponential moving average)

3. Wilder’s Smoothing Method (“Wilder”) is the method originally used for ATR calculation by ATR inventor J. Welles Wilder Jr. (explained in his New Concepts in Technical Trading Systems, page 23). It has the same logic as exponential moving average (puts greater weight on the most recent bars), from which it only differs in the exact calculation of the smoothing factor:

Average True Range formula (Wilder's method)

Which of the Methods is the Correct One?

In various resources you will find that one of the methods is the “right one” and the others are “incorrect”. If you are looking for the “original” ATR, as invented by J. Welles Wilder Jr., use Wilder’s smoothing method.

However, there is no such thing as “correct” or “incorrect” calculation method and none of the methods is universally more profitable than the others when using ATR as part of the investment decision making process.

Of course, different methods lead to slightly different behaviour of ATR and may have strengths and weaknesses, depending on the particular purpose, trading style, and market conditions. But personally I find the selection of particular method less important than simply knowing what you are using and using it consistently. If you are familiar with trading strategies based on moving averages, it is very similar to the SMA vs. EMA (vs. another MA) discussion and also to the discussion about the “best” period length.

Comparing EMA/Wilder’s vs. SMA ATR Calculation

Note: The EMA and Wilder methods are actually quite similar (you could already see that in the formulas above). There is in fact a direct relationship between period lengths of the two (2x-1), although it is not 100% accurate due to the data start problem explained below.

Disadvantages of EMA/Wilder’s ATR calculation method

One disadvantage is that both EMA and Wilder’s method are more complicated to calculate, though this does not play any role if you have Excel or common technical analysis software. For some people it may also be less comfortable to think about and interpret.

A more serious issue is that the resulting ATR at a particular point of time can show different values for the same set of data depending on when you started to calculate ATR in the past. This is because EMA and Wilder’s ATR calculation includes all data from start to the particular point of time (the data in distant past have very little weight in the final ATR value, but still do have some).

Disadvantage of SMA ATR calculation method

One drawback of the simplified ATR calculation is that ATR sometimes changes due to a sharp True Range change N bars back, as the simple moving average window rolls, even when current True Range remains stable.

ATR Calculation Methods Compared in One Chart

Below you can see the three ATR calculation methods in one chart. I have used S&P500 index daily data in 4Q2012, but I have changed the value on one day (to 1,000 on 14 November 2012) to create an extreme True Range value. You can see how ATR reacts differently to the spike in True Range under the three methods (blue = SMA, orange = EMA, red = Wilder, the period is 14 on all):

Average True Range (ATR) Calculator

As a result of the logic of individual calculation methods, the SMA ATR is elevated for 14 days (= ATR period) following the extreme price day, while the EMA and Wilder ATR start to gradually decline immediately after the True Range spike. However, EMA and Wilder ATR take longer time to return to the original level in the end. The difference is the same as the way simple and exponential moving averages react differently to price spikes, because the calculations are mathematically the same (you just use True Range instead of price on ATR).

Notice also the difference between EMA and Wilder ATR, which is a result of the difference in the smoothing factor. The numerator in the “a” formula is 2 under EMA, but 1 under Wilder’s method. Therefore, Wilder ATR with a particular period (n) is approximately the same as EMA ATR with double the period (2n, or 2n-1 to be precise). The chart below shows the same as the one above, only the EMA ATR period was doubled to 28. You can see the EMA and Wilder ATR are almost the same now:

Average True Range (ATR) Calculator

For more information see Average True Range (ATR) Excel Calculator + PDF Guide

Related pages

theta tradingvariance and standard deviation calculatorput and call options for dummiesfutures contract multiplierdefinition skewnesscalculating annual returnexplain skewnessshortcut formula for varianceexercise price and strike pricevix symboldelta hedging explainede excel formulacalculate weighted average calculatorkurtosis tradingoptions trading bookexponential moving average calculationparametric var formulablack shoelssquaring numbers in excelproshares leveraged etfshow to calculate averages in excelcalculating implied volatilityexample of stock indexcboe delayed quotesstandard deviation formula for grouped datarsi share priceyahoo finance msftexplain kurtosisultra vix etfrange variance and standard deviation calculatorhow to calculate intrinsic value of an optionmsft stock historyfinding the median calculatordescriptive statistics calculatorformula wacchow to calculate kurtosis by handrsi formula excelcalculator with negative numbersnormdist excel 2010implied volatility term structureexcel kurtosisoptions futures and other derivatives 8th editionhow to calculate ending inventory using average coststatistics skewrsi interpretationmethods of measuring skewnessproshare ultraformula for finding average in excelspectral skewnessblack scholes formula with dividendspopulation and sample variancedelta of a call optionpopulation standard deviation in excelexponential moving average in excelvix chicagoultra short vixoptions vs futures advantagesstraddle holdstats varianceubs etnstock sharpe ratiohow many shares in 1 option contractform 13f-hrdelta hedge calculatorthe straddle positionfutures roll datesetnsmeaning of skewness in statisticsdow jones vixsd calcvelocityshares daily inverse vixhow do i calculate variance in excelpopulation variance and sample variancesharpe ratio example