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


squared deviation calculatorkurtosis is a measure ofproshares ultrahow to use normdist function in excelcalculate derivative in excelhow many shares in an option contractrho optionsfxf trackinghow to determine skewnessnotepad default fontrho calculationoptions trading greeksvix stock symbolwhat does a negative kurtosis meanwhat is an etn vs etfyahoo historical datamacd tutorialauc unitstock excel spreadsheetvix historical averagewhat is a macro hedge fundexcel formula for standard deviationexamples of hedge fundsnormsdist calculatorannualised volatilitycalculate rsiimplied volatility formulameasure of kurtosisvariance defformula to calculate skewnessfx volatility calculationoptions futures and other derivatives solution manualexcel profit formuladerivation of variance formulahow to calculate the standard deviation in excelvix spotsample variance excel formulamorgan stanley historical stock pricedirectional hedge fundderivatives book by john hullstraddle position optionsstandard deviation calculator exceloption greeks formulacalls and puts for dummiessharpe ratiossum of squares formula statisticsexcel formula explanationsvolatility calculation formulastandard deviation excel formulanotepad with fontsstraddle option calculatorkurtosis in excelmini futures contractsyahoo finance dow futureshow to calculate rate of return in excelthe greeks in financeannualized formula in excelwhat is kurtosis and skewness in statisticsmsft historical stock price13f databasesample mean formula excelbuying vixcost of equity formula wacctrading vixcalculating mean in excelstock price volatility formulahow to compute implied volatilitytvix optionscommitment of traders chartaugen the bookusd yen etfweighted average cost of debt formulaproshares trust ultra vix shortvix curvehow to calculate sem on excel