This calculates a minimum value for a series between two dates, or a moving minimum for a series over a time period. The MIN# function has three formats.
MIN#(Expression,Start Date,End Date)
This static format produces the minimum value for a series between two dates. Actual dates are typed in using either the standard DD/MM/YY format or 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
MIN#(Expression)
If you do not specify start and end dates, the default dates are the start and end dates for the display period.
MIN#(Expression,Period)
This moving format calculates the moving minimum value for a series over a specified time period. Please see the warning below. Use the period codes to specify the period.
MIN#(JAPDOWA,01/09/98,30/09/98)
This static format calculates the lowest value for the Nikkei-Dow index during September 1998.
MIN#(JAPDOWA)
This default static format calculates the lowest value for the Nikkei-Dow index over the display period.
MIN#(UKRPANNL,1Y)
This moving format calculates the lowest UK inflation rate for each 12 month period between the display start and end dates.
You can also use the minimum function as an argument in the ACHV#, PCHV#, and REB# functions. For example:
ACHV#(FTALLSH,MIN)
This calculates the actual difference between the FT All Share index and the minimum value it reached over the display period. See format as an argument within a larger expression :
ACHV#(FTALLSH,MIN)
This calculates the actual difference between the FT All Share index and the minimum value it reached over the display period.
You must use a minimum 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:
MIN#(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 MIN# with a maximum of 4,000 values. If you request a minimum 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 minimum period. These time periods should not exceed 15 years.