This calculates an average value for a series between two dates.
AVG#(Expression,Start Date,End Date)
This calculates a single average value between the Start Date and End Date. Actual dates are typed in using either the standard DD/MM/YY format, or the displacement date formats.
As a date parameter one can also use YRE, HFE, QTE, MTE, WKE, LYE, BDATE, BDATEXXF
AVG#(Expression)
As above. If you do not specify start and end dates, the defaults are the start and end dates for the display period.
AVG#(FOODSUS(PE),1/1/98,31/12/98)
This static format calculates the average PE for the US food sector for 1998.
AVG#(FOODSUS(PE),-1Q,)
This calculates the average PE for the US food sector for the previous quarter. The blank end date parameter defaults to the end date of the display period.
AVG#(FOODSUS(PE))
This default static format calculates the average PE for the US food sector for the period between the start and end dates for the display period.
You can also use AVG function as an argument within an expression. For example, ACHV#, PCHV#, and REB#:
PCHV#(U:F,AVG)
This moving format calculates the percentage change of the actual Ford share price from the average share price over the display period.