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

2 line macdarithmetic average calculatorstandard error of skewnesspopulation covariance formulamean mode median exceliron butterfly optionsblack scholes option pricing model formulacost of preferred equity formulaaverages in excelhedge fund definition exampleintrinsic value of a put optionexponential moving average definitionwhat is rsi stand forblack scholes put optionshort vixtechnical analysis momentum indicatorsberkshire hathaway sec filingsbutterfly option exampleoption payoff calculatoroption payoff graphhow to calculate intrinsic value of stock optionshow is the dow jones calculatedvalue of a call option formulaoption payoff graphfat tails kurtosiscovariance formula in excelgarman kohlhagen modelmoving average graph excelskewness definition in statisticsstatistics skewness and kurtosisimplicit volatilitycalculating implied volatilityexponential smoothing calculatorcalculate smaexcel calculations formulaskurtosis exampleswhat is a price weighted indexoption pricing black scholeshow to calculate excel formulashow to trade the vixshort call payoff diagramformula to calculate average in exceletf listsunbiased estimate of population varianceblack scholes delta calculatorfinding the median calculatorberkshire hathaway 13f filingsum of squares in exceljohn c hull solutionsstandard deviation calculator percentileaapl stock price chartetf listmacd bullish divergencecost of ending inventory formulawhat is the formula for calculating standard deviationkurtosiintrinsic value of call optionimplied volatility calculatorhow to calculate percent deviationadvantages and disadvantages of a spreadsheetoption payoff diagram generatoraapl earnings historyoptions expiration calendarspx settlement valueexcel formula to calculate average percentageexcel cdfaverage deviation calculatorsharpe formulaarithmetic basicsvxx tickervix stockblack scholes explained