You can use MAX and MIN as date parameters within functions to specify the date of the maximum or minimum value of a series between the start and end dates.
Function#(Expression,X,Y) where:
X = Start date, or the date of the MIN or MAX value within the period defined by the display dates
Y = End date, or the date of the MIN or MAX value within the period defined by the display dates
MAX and MIN operate at the data frequency (the frequency at which data is stored), and not the display frequency. For example, if daily data is plotted in a chart displaying monthly values, the MAX parameter may return a maximum value that does not appear in the chart if this value falls between the monthly display points.
Note MAX and MIN used as date parameters do not give absolute maximum or minimum values for the entire series, but operate within display period. For example:
AVG#(FTSE100,MIN,31/12/98)
gives the average value of the FTSE 100 index between the date of the minimum value (within the start and end dates) and the end of 1998. The minimum value date is constrained by the start date specified on the input screen and 31/12/98 end date.