This view shows the W,Q,P counts of horses, jockeys and stables. You can double-click on a column to show the corresponding hist/stat view to verify the data on the column.

The screen capture below shows the figures for the 19/10/2011 meeting. We have set the statistical period to 120 days for jockeys and stables and all starts for horses.

View Columns

Columns: "No.", "Horse", "Jockey" and "Stable"

Shows horse no., horse name, jockey name and stable name.

Column: "Horse: DistTrack(W,Q,P,L(Tot) W% WQP%)"

This column shows the W,Q,P counts and the winning percentage of each horse. For example the line "1000Turf(0,0,0,2(2) w:0% p:0%)" on the top row of the column shows no winning, 2nd, and 3rd for "Golden Treasure". It has lost in 2 starts and the its total starts are 2. Both winning and 2nd percentage of it are 0.

Column: "Jockey: DistTrack(W,Q,P,L(Tot) W% WQP%)"

This column shows the W,Q,P counts and the winning percentage of each jockey during the period defined by MCL variable {1}. For example the line "1000Turf(0,0,1,5(6) w:0% p:17%)" on the top row of the column shows, during the latest 120 days, no winning and 2nd for "T Angland". He has one 3rd and lose in 5 races. His total races are 6. The winning percentage was 0 while the top-3 percentage of it are 17%.

Column: "Stable: DistTrack(W,Q,P,L(Tot) W% WQP%)"

This column shows the W,Q,P counts and the winning percentage of each stable during the period defined by MCL variable {1}. For example the line "1000Turf(0,0,1,4(5) w:0% p:20%)" on the top row of the column shows, during the latest 120 days, no winning and 2nd for "A Schutz". He has one 3rd and lose in 4 races. His total races are 5. The winning percentage was 0 while the top-3 percentage of it are 20%.

How to Change Statistical Period

You can change the statistical period by clicking on [Set/Choose MCL Variables...] on the right of the form. The "MCL Variables" form will be shown. Check the left-most boxes on the form to select an item or combine items. Learn more by opening the page Setting Values & Choosing MCL Variables.

How Chaining is Set

The statistics columns for Horse, Jockey and Stable have specific settings. When double-clicked, they will chain to the Horse, Jockey and Stable forms respectively and open the "* Distance WQP Stats" view. The data range will be set by argument 1. (See Using MCL Variables As View Arguments and MCL Variables to Set Data Range for details.)

Lets take "Jockey: DistTrack(W,Q,P,L(Tot) W% WQP%)" as an example. Highlight the column on the columns list at the left hand side of the "Edit View" form. The click the [Advanced] button at the right. You will see the following form.

Field |
Value |
Remark |
||||

Open Form |
Jockey |
Open the "Jockey" form on double-clicking |
||||

Target View |
* Distance WQP Stats |
Jump to the "* Distance WQP Stats" view |
||||

Arguments |
Gel(HrDate()-{2},',',HrDate()-1) |
In this example {2} is 120. And HrDate() is 19/10/2011. Therefore
The Gel() function combines the items (including the ',' inserted in the middle) into "21/06/2011,18/10/2011", which confirms the data range argument standard of RaceMate.
Since the argument if passed through argument 1, you must prepare {1} to receive it. |

History/Statistics Views after Double-Clicking

When one of the statistics columns is double-clicked, the form set on the "Edit View Advanced Settings" will be shown. The data range will be set according to the argument set there.

For example, when you double-click on the "Jockey: DistTrack(W,Q,P,L(Tot) W% WQP%)" column, the [* Distance WQP Stats] view of the Jockey form will be opened. The period is set to 21/06/2011 to 18/10/2011 which is equivalent to race 720 of season 10-11 to race 101 of season 11-12.

See Also

Using MCL Variables As View Arguments | MCL Variables to Set Data Range

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