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


computation formula for sample varianceexplain skewness and kurtosisstandard deviation formula in excelwhat does overbought and oversold meancalculating standard deviation on calculatorhedge fund filingsblack scholes model equationbear call spread exampleshare price volatility calculatoroption pricing calculator black scholeswhat is the formula for standard deviation in exceloption pricing greeksformula for standard deviation excelvariance mathsvix dow jonesrelative strength index explainedcalculate emasample variance and population varianceweighted average cost of capital wacc formulareturn calculator excelrealized rate of return calculatorcalculator for variancedays calculator formula excelrsi indicator pdfimplied volexcel macdstandard deviation calculation excelmarket cap weightingskewness and kurtosis values for normal distributionrsi overbought oversoldvix backwardationoption position simulatorcboe delayed quotesgeometric average return calculatorsharpe ratio interpretationc# exponential moving averageexplain skewnessn d1 black scholesoption probability calculatorcalculate averages in exceltrue standard deviation formulasec filings 13faverage real return formulaoption notional valueprofit loss graph excelexcel stdev ifweighted standard deviation excelformula of average deviationwhat is delta hedgingvxz ipathcalculate sample mean and standard deviationmean variance standard deviation formularsi indicator calculationetf and etnwacc computationmacro formula excelexcel var formulakurtosis formula in statisticshedging with putslifo fifo weighted averageputs and calls for dummiesstraddle deltastatistics skewness and kurtosisthe black scholes formulavix short term futurescalculating median in exceldelta hedge optionsroot sum square excelcalculating average annual returnspvxstr indexweighted average unit cost formula