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

arithmetic in excelvix futures symbolbuying vixsample mean calculatorexcel stdev sblack scholes put optionskewness of a distributionvix futures pricingapple stock closing price historys&p 500 methodologyoption notional valuevar parametricaapl stock price historymoving average c#vix futures symbolhedge fund arbitrageyahoo futures indicesvix funds etfberkshire hathaway 13f filingaapl share price historyformula standard deviation excelvix tickerkurtosis coefficienthow to read macd indicatorbackwardation curvegamma call optionskewness formula for ungrouped datavariance in mathsrsi oversoldubs e tracsdefine skewness and kurtosisblack scholes delta calculatoroption notional valuewhat does vix stand forvix futuresput option delta formulas&p 2x etfbloomberg volatility calculationleveraged etf optionstvix prospectusproshares.comexcel option calculatorultra etfsaverage deviation meaningguts option strategyvix future quotesoptions on vixprofit function calculatorstandard error of skewnessexcel sample meanetfs listsample mean calculatorcalculating skewnesscurrency options calculatorcalculating option deltaexcel macdhow to calculate variance in financesell put option graphshort term etfcumulative function in excelvxx futuresmerits and demerits of central tendencyhow is dow jones calculatedcalculating sample covariancehow to read the vixvix tradevix cboe volatility indextheta in options tradingreal time vix quotevix historicalhow to compute the average in excelyahoo finance vixweighted average cost calculatorsample covariance formularsi valuevix etf listyahoo finance symbols