True Range

The True Range is a measure of volatility introduced by Welles Wilder in his book: New Concepts in Technical Trading Systems.

The True Range indicator is the greatest of the following:

• current high less the current low
• the absolute value of the current high less the previous close
• the absolute value of the current low less the previous close

Syntax:

TrueRange
TrueRange()
TrueRange(“OutPutStartCell”)

Inputs:

'High', 'Low', 'Close', and 'Volume' columns values

Parameters:

• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

TrueRange
TrueRange()
TrueRange(“G2”)
TrueRange(G2)