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


excel probability formulablack scholes implied volatilitydaily volatility calculation formulaoptions straddle strategycontango vixcalculate population meanexcel log formulameasures of skewnessexcel cdfrsi barscalculating the sample variancedefinition of std deviationd2 calcstandard variance calculatorvariance and standard deviation practice problemshow to calculate population mean from sample meanoptions straddle examplewhat is kurtosis and skewnessipath s&psample variance formulasannualized volatility formulavix futures pricingfinding averages in excelblack scholes model formulamodel black scholessample deviation calculatorbullish put spreadreverting meansexcel stdevstandard deviation formula financeskewness and kurtosis in statisticsvxx indexusing normdist in excelstd deviation excelskewness and kurtosis formulavix stock symbolblack scholes calculator with dividend yieldhow to calculate market value of debt for waccthe black scholes option pricing modelthinkorswim historical datarsi meaning stocknormdist calculatormodelo black scholeskurtosis calculationcboe options quoteswhat does oversold mean in stocksexcel norm dists&p 2x etfdescriptive statistics calculatorhow to put standard deviation in excelrsi oscillatorproshares short s&p 500formula kurtosisaverage inventory cost methodberkshire hathaway 13-frsi formula excelexcel option calculatorwhat is market capitalization with examplemedians definitionsell straddlestock market return calculator historicalyahoo vixhow to figure out standard deviation on excelxl formulasyahoo finance indexbloomberg vixshort term macd settingsnotepad with fontsstandard deviation calculatorsyahoo finance csv downloadbook on options tradingexercise price and strike pricersi conditionformulae of profit and lossblack scholes merton modelproshare ultra