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


avco methodlong straddle optionput option strike priceexponential function in excelhow to calculate the square root in exceltrading vix derivativesblack scholes delta calculatordescriptive statistics in excel 2007sample variance formula statisticsvxv etfvix futures expiration calendarskewness and kurtosis calculatormacd strategyhow to determine the strike price of an optionbear call spread payoffvalue of call option formulamacd formulamomentum indicators in technical analysisoption strategies straddlemoving average c#option pricing model black scholesshort straddle optionsample variance formula in exceltimevalue calculatorsn d1 black scholesweighted average cost of capital wacc formulahow to work out skewnessema excelfinding averages in excelthinkback thinkorswimexponential moving average definitioncalculate sample mean in excelwhat is an etn vs etfpercent relative standard deviation calculatorimplied volatility formula excelcboe paper tradingskewness exampleblack scholes calculator excelwacc formulasshort straddlesnormal backwardation vs backwardationvariance formula for grouped datarsi valuesstraddle deltachicago board options exchange volatility indexblack scholes price calculatorweighted average cost of inventory formulawacc market valuestraddle payoff diagramcall options for dummiesoptions greeks explainedsample variance formula in excelshort term vixformula of population meanvolatility vs standard deviationnormdist in exceldividend formula financespy historical returnshow to calculate ending inventory using average costvix option pricingaverage cost method ending inventorystandard variance calculatorstandard error of skewnessexcel normsdistatr average true rangevelocityshareswhat is the wacc formulacalculate variance on excelskew statisticsblack scholes calculator with dividendsrelative strength index excelnormal density function excels&p 500 methodologyhistorical volatility chartshortcut formula for variance