The functions return averages of specified information in the past records of the horse, jockey, or stable respectively.
Syntax
HrAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
JrAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
SrAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
Argument |
Description |
Example |
||||||||
'nValueExpr' |
|
'HrDvdWin( )' |
||||||||
nRaces |
|
6 |
||||||||
'fCondition' |
|
'For HrFP( )=1 While HrDate( )>Date(1999,9,1)' |
||||||||
nDefaultValue |
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
Numeric
Examples
HrAverage('HrWeight( )',3)
The above example returns the average loading of the past 3 races of the horse.
SrAverage('HrSpeed( )',4,'For HrDistance( )=1400')
The above example returns the average speed of the last 4 1400m starts of the stable.
JrAverage('HrSpeed( )',,'For HrDistance( )=1400 and HrAveRating( )>100',95)
The above example returns the average speed of all runs meeting the following conditions:
1. | 1400m race |
2. | Average rating of the race is greater than 100 |
If no race meeting the condition can be found, return 95.
SrAverage('HrFP( )',10,,'R')
The above function returns the average of the finishing position of last 10 starts including the starts in the underlying race.
Page url: http://www.racematenet.com/english/help/index.html?hraverage.htm