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

etf correlation calculatoroption straddle strategyvariance formula financevix etf 3xstraddle strangle butterflymacd 2 lineinception calculatorweighted average market capinterpretation of sharpe ratiolist of section 13f securitieshow to calculate skewness and kurtosisoption spread calculatorlog formula excelhow to write ln in excelcall option payoff graphstrategies of hedge fundsbuffett 13fs&p 500 historical valuesmeaning of underlying assetscalculate sigma in excelvix future settlementexcel simple formulasdollar vs euro etfshort the vixannualized formula excelexcel macro averagesharpe ratio wikimerton option pricing modelvix futures chartbarclays etninterpreting variance and standard deviationweighted average cost of capital waccproshare ultrastdev formulahistorical volatility calculationlogarithm in excelarithmetic mean formulaseasy calculation mean median modehow to compute wacccalculate median excelcfe cboecboevixroot sum of squares formulapopulation formula calculatoroption stradlecalculating the sharpe ratioema calculationdelta hedging formulastandard deviation equation in exceltop options trading bookssample mean excelderiving square rootsskewness valuevix ticker symbolskewness statistics definitionvix index calculationstdev sroot sum of squares formulamethods of calculating varsharp ratio definitionhow to calculate sampling error in excelformula for calculating standard deviation in statisticscontango vs backwardationsharpe ratio wikiarithmetic progression calculatorvix futures contractyahoo finance symbolsskew formulaoptions calchow to read rsi chartput and call options for dummiesweighted average cost of capital formula exampleblack sholes modelcalculator with negative numberscost of equity formula waccvix futures contractstrike price put optionskewness examplescboe definitionhow to measure standard deviation in excel