Calculating Range In Excel

Range is the difference between high and low in a particular time period, such as a trading day. The range formula is very simple:

Range = High – Low

In Excel, you simply take the cell containing the high and subtract the cell containing the low from it – see screenshot from ATR Calculator below.

Calculating Range in Excel - ATR Calculator

Obviously, unlike many technical indicators and other financial calculations, for calculating range you need the history of high and low, not close. Typically you need historical price data in the OHLC or HLC format.

Calculating Range in ATR Calculator

You can calculate average range in the ATR Calculator by selecting “Range” in the drop-down box in cells K4/L4/M4. You can also see the range for each bar in column G.

What Is ATR?

Average True Range (ATR) is a more advanced concept of range and more suitable in some types of markets compared to the traditional range. Here you can see a detailed explanation of true range and ATR calculation.


Related pages


variance statsvix chartstandard deviation example in excelweighted cost of capital calculatorinterpreting variance and standard deviationimplied volatility explainedexcel stdevhow to calculate averages on excelblack scholes in excelblack scholes model explainedstock market rsisharpes ratiocalculate skewcalculating historical volatilityblack scholes calculator with dividendsuses of arithmetic mean in daily lifevix backwardationblack scholes merton calculatorformula for sample variance statisticvix index cboeapple stock history calculatorhow many shares in 1 option contractmaximum profit equationdouble vix etfhow to buy the vixskewness and kurtosis examplesexcel formula macroetfs that track the vixmean and sd calculatorannualised volatilitykurtosis definition in statisticsstandard deviation formula in financeoptions delta calculatorexcel stdevtrading days calculatordescriptive statistics calculatorintrinsic value excelwhat is stdevdividends equationvxx options settlementcovariance formula statisticsstock momentum formulaarithmetic mean roughnesspayoff diagramrsi indicator settingssample variance excel formulawhat is skewness and kurtosisimplicit volatilityderivation of black scholes modelcontango curvewhat is a straddle in optionsstrike price stock optionsmacd formulawhat is the cboe volatility indexcalculate cv in excelcfe vixmacd divergence strategynatural log excelvix chart yahoocredit suisse etnsmacd bullish divergenceoption greeks formulastock market return calculator historicalhow to measure skewnessblack scholes modelsannualized volatility formulaoptions vs forwardschicago board options exchange volatility indexcalculate annualized volatilitysp500 vixgeorge soros 13f