Calculate Range in Excel

Calculating Range In Excel

Range is the difference between High and Low in a particular time period. The Range formula is very straightforward:

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: Screenshot from ATR Calculator

Obviously, unlike with many other financial calculations, you need market data in the OHLC or HLC format, as High and Low enter the Range calculation.

Calculate Range in Excel ATR Calculator

The Average True Range (ATR) Calculator is available in Free Downloads. I have designed it to calculate ATR, but there is also Range (High less Low) calculated in column F in the sheet “ATR Calculation” (as calculating Range is part of the more complex process of calculating 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.

Here you can download the ATR Excel Calculator.


Related pages


black scholes calculator with dividendsvelocityshares daily inverse vixcalculating the sample variancevariance mathshow to figure out standard deviation on excelfutures roll datesxxv vxxstandard deviation computational formula3x vixkurtosis equationcost of preferred equity formuladefining formula standard deviationexcel macro averageexcel var functioncboe volatility futuresoption skew explainedcalculate weighted average calculatoreuro stoxx 50 quoterelative value hedge fundspx vixblack scholes methodnormdist functionhow to calculate rhoproshares short s&p 500 etfwhat is coefficient of skewnessannualize a numbercboe paper tradeblack scholes pricing model calculatorwhat is vxx etfhistorical stock return calculatorcost of ending inventory calculatoroptions probability calculatorwhat is skew in statisticssimple exponential smoothing calculatorstandard deviation of returns calculatorfifo and weighted average methodfx volatility calculationskewness formula statisticskurtosis in excelhow to trade vix futureswww.proshares.comproshares vixymeaning of kurtosisnotepad optionscomputational formula for variancewww.cboetypes of hedge fund strategiesexcel calculation formulaslong term vix charthow to calculate a variance in excels&p 500 csvlong short equity hedge fundsgeometric vs arithmetic averagespy historical returnshow to calculate sigma squaredrsi indicator formulaarithmetic formulas in excelhow to calculate option deltacboe volatility index vixaverage deviation meaninginterpreting kurtosisformula for coefficient of skewnesspositive kurtosis2x s&p 500 etfskewness statistics formulahow to divide big numbers without a calculatorstraddle strategymarket sharpe ratiounderstanding kurtosisdelta formulasdifferent formulas in excelvix fundscboe volatility index chartstrike price put optiondetermining skewnessvxx etncoloured notepadchange notepad background colorcall option gamma