Average Negative Changes

The Average Negative Changes show average of successive decreases of value for last PERIOD time periods.

Syntax:

AverageNegativeChanges
AverageNegativeChanges()
AverageNegativeChanges(“Period”)
AverageNegativeChanges(“OutPutStartCell”, ”Period”)

Inputs:

'Close' column values

Parameters:

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

Examples:

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