Average True Range

The True Range indicator is defined by Wilder to be the greatest of the following for each period:

• The distance from today's high to today's low
• The distance from yesterday's close to today's high
• The distance from yesterday's close totoday's low

The Average True Range is simply the average of the true ranges over the past x periods (where x is specified by the user).

Syntax:

AverageTrueRange
AverageTrueRange()
AverageTrueRange(“Period”)
AverageTrueRange(“OutPutStartCell”, ”Period”)

Inputs:

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

Parameters:

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

Examples:

AverageTrueRange
AverageTrueRange()
AverageTrueRange(“14”)
AverageTrueRange(14)
AverageTrueRange(10)
AverageTrueRange(“G2”,”14”)
AverageTrueRange(“G2”,14)
AverageTrueRange(G2,”14”)
AverageTrueRange(G2,14)