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


black scholes callblack scholes delta calculatorforex volatility calculatorblack scholes delta calculatormacro formula excelexcel formulas spreadsheetmerits and demerits of harmonic meanformula distdow weightingrealized volatility calculationprice weighted index calculationblack scholes formula with dividendsadvantages and disadvantages of mean median modeformula black scholesfinance tvixbull put spreadoption straddle exampleshort put option payoffdelta option formulaimplied volatility black scholespercent variation calculatoroptions yahoo financeoption implied volatility calculatorblack-scholes option pricing model calculatornotepad stylesgeometric mean formula excelspectral skewnessrsi calculation formulasoros fund management holdingswhat does rsi stand forvolatility etfsinverse etfs listspx cboevega option greekitm calculatorwhat is rsi in stock marketkurtosis valuessample kurtosisadvantages and disadvantages of median in statisticsyahoo finance historical exchange ratesdifference of squares calculatorsec 13f faqshort etf s&pexcel volatilitytrading puts and calls for dummiesbull put spread strategyfinding waccjpmorganstockspot markets versus futures marketscontinuously compounded returnscboe quotesvxx ipathfat tails kurtosisexcel median calculationput option strike priceipath etnfloat adjusted market caphow to draw break even chart in exceldividend yield calculationcboe delayed quotesnegative and positive numbers calculatordefine kurtosis and skewnessbearish call spreadlist of inverse etfshow to find 13f filingsinverse vxxgreeks black scholesblack scholes model equationmaximum profit equationpositive kurtosis