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


straddle strategy exampleintrinsic value of put option formulakurtosis explainedvix yahoounderstanding black scholeshow to calculate in excel formulablack scholes option price calculatorrate of return calculator for stocksdividends yield formulagreeks gammavix index cboevxx optionsoption theta formulahow to calculate kurtosis by handstandard error of skewness formulamarket breadthn d1 black scholesderivation of variance formulacombo option strategymedians definitionmean and standard deviation calculatormacd momentumskewness valuevix index wikiintrinsic value of call optioncalculating exponents in exceloption volatility calculatorthe black scholes option pricing modelhow to calculate volatility for black scholesformula distvix s&p 50013f filings hedge fundshow to calculate the standard deviation in excelhull options futuresexcel macro formulassample covariance calculatordj euro stoxx 50 historical pricesblack scholes normal distributiontrading hedge fundsmoothed rsi indicatorpayoff chartcalculate standard deviation using excelmonospace fonts listsharpe ratio portfoliomoving average chart excelvolatility index meaningfutures expirystraddle deltavix cboe volatility indexnorm.distskewness and kurtosis calculatorexcel median calculationsharpe theoryimplied volatility standard deviationadvantages and disadvantages of mean median and modepayoff chartquote vixrealized rate of return calculatoreur usd etfaverage standard deviation calculatorstocks at all time lowsequation for dividendskurtosis formulast dev calcdefine kurtosisiron condor calculatordefine contangoblack scholes pricingstandard deviation formula calculatorexplain skewnesscboe vix term structurevix backwardationwhat is rsi in stock marketfree float market capitalization