Navigation:  MCL Reference > Statistics on Past Records >

HrMaxStartID( ), JrMaxStartID( ), SrMaxStartID( )

Print this Topic Previous pageReturn to chapter overviewNext page

The functions return ID of the start at which the maximum of a racing datum is found.

 

Syntax

HrMaxStartID('eValueExpr',nRaces,'fCondition',cDefaultValue,cIncluding)

JrMaxStartID('eValueExpr',nRaces,'fCondition',cDefaultValue,cIncluding)

SrMaxStartID('eValueExpr',nRaces,'fCondition',cDefaultValue,cIncluding)

 

Argument

Description

Example

'eValueExpr'

Datum the maximum of which is to be found.
Data type of expression: Any

'HrDvdWin( )'

nRaces

Number of latest races, counting back from the underlying race, to be averaged. The races must be meeting the condition specified by 'fCondition'.
If nRaces is omitted, all races meeting 'fCondition' will be included.
If total number of races meeting 'fCondition' is smaller than nRaces, the function will perform calculations on only the available races. You may use the HrCount( ) function to check how many races have been counted.

6

'fCondition'

If argument 'fCondition' is passed, the races (nRaces) will only be selected from those meeting 'fCondition'. The 'fCondition' argument is composed of a For clause and a While clause.
A For clause causes the function to act on each record that meets the specified logical condition.
A While clause causes the function to stop action once the logical expression evaluates to false.
Both For and While clauses are optional.

'For HrFP( )=1 While

HrDate( )>Date(1999,9,1)'

cDefaultValue

Default value returned when no race satisfying the specified condition can be found. The data type of this value must be identical to that of normal return value.


cIncluding

When applying the function to past records, by default, races in the underlying meeting are not included. You may use this argument to change the scope. See the following page for details: The cIncluding Argument.

'R'

 

Returns

Character (Width=8)

 

Examples

HrMaxStartID('HrWeight( )',3)

The above example returns the ID of the start, among the last 3, at which the loading is a maximum.

 

HrMaxStartID('HrWeight( )',4,'For HrDistance( )=1400')

The above example returns the ID of the start, among the last 4 1400m races, at which the loading of the horse is a maximum.

 

HrMaxStartID('HrWeight( )',,'For HrDistance( )=1400 and HrAveRating( )>100',101)

The above example returns ID of the start, among the races satisfying the following conditions, at which the loading of the horse is a maximum:

1.1400m race
2.Average rating of the race is greater than 100

 

If no races satisfying the above conditions can be found 101 will be returned.

 

 


Page url: http://www.racematenet.com/english/help/index.html?hrmaxstartid.htm