MATD returns the Month-to-Date moving average. Meaning it caculates the average of all data from the begining of the month to the current date of a specified variable.

SYNTAX:

MATD(Cx)
where :
Cx is a conditional variable x
 

NOTES:

BLANK values are ignored when calculating the average.

This function requires the target and source variable frequencies to match. E.g. Hourly target variable = Hourly source variable, 5-Minute Target variable = 5-Minute Source Variable. If the frequencies do not match, the function will return incorrect values.

EXAMPLES:

V103 = MATD(C70)

Variable 103 will contain the month to date average of variable 70: