MCL Reference > Track Work Information > HrTwCount( ), JrTwCount( ), SrTwCount( )

The functions return the statistics on activities of a horse during a number of days (specified by the first argument) before the underlying race. You may specify which types of activities you want by passing a list of control symbols into the second argument of the function. The following figure shows how data are displayed in a column.

Syntax 1

HrTwCount(nDays,cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

JrTwCount(nDays,cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

SrTwCount(nDays,cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

Syntax 2

HrTwCount('DayX-DayY',cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

JrTwCount('DayX-DayY',cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

SrTwCount('DayX-DayY',cTemplate,cZeroMark,nBackRaces,'fCondition',nDefaultVal)

Argument

nDays (Syntax 1)

Number of days, e.g., 60.

If nDays is missing (or equals 0), the activities since last start will be returned.

'DayX-DayY' (Syntax 2)

Specifies a period from day X to day Y, counting back from the underlying race. For example '8-14' mean from day 8 to day 14 back from the underlying race.

cTemplate

A template containing the following control symbols which control the return value of the function:

Symbols	Returns	Remark
G g	Number of turf barrier trials	Capital letters for formal barrier trials while small letters for Jump-out
R r	Number of river-side turf barrier trials
A a	Number of all weather track barrier trials
L1	Gallop (no partner)
L2	Gallop (1 partner)
L3	Gallop (2 or more partners)
L	Gallop (with or without partners)
J	Jog
S	Swim
C	Start
P	Spelling
N	No activity (including spelling days)
I	No activity (excluding spelling days)

•	In the template, you may separate different types of Activities by commas or other punctuation marks. More than one type of activity may be grouped together by putting more than one symbol together.

•	cReturnList is default to 'L,J,S /gra,A,G'

cZeroMark

A character string which will replace the zero value in the returned value list. If you don't pass a character string into this parameter, zero values will be replaced with blank spaces.

Returns

Character (width is template dependent; 31 for the default template)

Remark

Under normal circumstances, you may need to push the [Recalc] button to refresh the data of the column (see Cache for View Data for details).

Examples

HrTwCount( ,'GA,gra,L,J,S','- ')

'GA' stands for total number of formal barrier trials. 'gra' stands for the total number of jump-outs. L, J, S stand for gallop, jog and swim respectively. If we apply the function to race number 9 of 17 Sept 2005, the following list will be returned for the horse Chinsola:

" 1,- , 3,32,- " (1 format barrier trial, 0 jump-out, 3 gallops, 32 jogs, 0 swim)

HrTwCount('425-453','GA,gra,L,J,S','- ')

Similar to the example above. The only difference is the statistical period is specified as 453 days ago to 424 days ago (30 days in total) from the underlying race.

HrTwCount( ,'GA,gra,L,J,S','0')

We will get the same values as shown in the above example except that zero will be shown as '0':

" 1, 0, 3,32, 0"

Trim(HrTwCount(28,'gra,A,G'),' ',',')

The functions in this example will return the counts of all jump-outs, formal AW barrier trials and turf barrier trials in last 28 days. The Trim( ) function removes all trailing spaces (' ') and commas (',').

HrTwCount(14,'G,gr')

The function will return the number of formal and turf jump-outs in last 14 days.

HrTwCount(30,'L1,L2L3,L')

HrTwCount(30,'L1,L2L3,L1L2L3')

The 2 functions above will return the same result, which is the numbers of single-horse gallops (no partner), partnered gallops, and all gallops in last 30 days. The sum of the first 2 figures (L1 and L2L3) will be equal to the 3rd figure (L or L1L2L3).