This calculates the maximum value for a series between two dates, or a moving maximum for a series over a time period. The MAX# function has three formats:
MAX#(Expression,Start Date,End Date)
This static format produces a single maximum value for a series between two dates. Actual dates are typed in using either the standard DD/MM/YY formator the displacement date formats.
It is also possible to use YRE, HFE, QTE, MTE, WKE, LYE,LYEXX, BDATE, BDATEXXF. One can also use MIN and MAX
MAX#(Expression)
If you do not specify start and end dates, the default dates are the start and end dates for the display period.
MAX#(Expression,Period)
This moving format calculates a moving maximum over a specified period. Use the period codes to specify the period. Please see the warning below.
MAX#(JAPDOWA,01/09/98,30/09/98)
This static format calculates the highest value for the Nikkei-Dow index in September 1998.
MAX#(JAPDOWA)
This default static format calculates the highest value for the Nikkei-Dow index over the display period.
MAX#(UKRPANNL,1Y)
This moving format calculates the highest UK inflation rate in each 12 month period between the display start and end dates.
You can also use the maximum function code as an argument in the ACHV#, PCHV#, and REB# functions. For example:
PCHV#(FTALLSH,MAX)
This calculates the percentage change between the actual FT All Share index and the maximum value it reached over the display period. See 'Using functions as arguments in other functions' for more details, Please see Using function codes as arguments:
You must use a maximum period that is consistent with the frequency of the stored data. That is, the period frequency you request for the function can be greater but not less than the data frequency. For example:
MAX#(UKBCJD..,30D)
is invalid because UK unemployment is a monthly data series, so you cannot calculate a maximum values using a daily time period.
Note You can use MAX# with a maximum of 4,000 values. If you request a maximum period which requires more than 4,000 values, an error message is displayed. To reduce the number of values, either reduce the display period or the maximum period. These time periods should not exceed 15 years.