The functions return the sum of a racing datum over a set of the past records of a horse, a jockey or a stable.
Syntax
HrSum('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
JrSum('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
SrSum('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
HrSum('HrWinTickets( )',3)
The above example returns the sum of win investment of the last 3 races of the horse.
HrSum('HrWinTickets( )',4,'For HrDistance( )=1400')
The above example returns the sum of win investment of the last 4 1400m races of the horse.
HrSum('HrWinTickets( )',,'For HrDistance( )=1400 and HrAveRating( )>100',95003)
The above example returns the sum of win investment of all races meeting the following conditions:
1. 1400m race
2. Average rating of the race is greater than 100
Page url: http://www.racematenet.com/english/help/index.html?hrsum.htm