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


yahoo finance currency historical datacboe quotesipath fundsaapl implied volatilityformula for coefficient of variation in excelcredit suisse etnwhat does rsi mean in stockscboe ruleswhat is the formula for waccpercentile calculator standard deviation meancalculate kurtosiscboe rulesatr volatilityhow to calculate implied volatility of a stockvix trading strategycalculating variance in excelfifo and weighted average methodthe black scholes merton modelnatural log in excelsample variance formula statisticsvix settlementn d1 black scholessmoothed rsiiron butterfly optionmoment coefficient of kurtosisblack scholes gammaskew in statisticsblack scholes volatilitybearish stock definitioncalculating the sample variancedelta symbol in excelvxv etfs&p500 vixaverage annual rate of return calculatorubs e tracssharpe calculationweighted average accounting formulafixed income arbitrage exampleghi stockexcel normsdistdelta greeksformula sharpe ratiosample variance formula in excelskewness formula statisticshow to calculate weighted average cost of debtwhat is a price weighted indexuvxy tickercalculate population meanhow to calculate portfolio weightbull call debit spreadsimple exponential smoothing calculatorinception calculatoretf vxxvolatility calculation black scholesoptions profit and loss calculatormeaning of rsi in stock marketcalculating the standard deviation in excelderivation of black scholes modelrsi indicator formulaleveraged inverse vix etftrading option greeksmicrosoft excel weighted averagecalculating implied interest ratecboe vix indexcalculating variance in excelsquare root of 3.24greeks thetablack scholes valuationmoneyness of an optionvix short etfnikkei index definitionwhat is straddle positionvix option chainexcel mean deviation