--quote:"Hi Jeff, Is it possible to track jockey trainer combinations for an individual track that is currently running or would you need a spreadsheet? Can't find those stats with a Google search. Easy to find jockey and trainer individual stats,but, no combo stats. Don M" --end quote
Armed with a JCapper database, doing R&D into jockey - trainer combos is ridiculously easy.
Pick a trainer, a track, and a time period.
Example:
Trainer: KOBISKIE DANE
Track: LRL
Time period: 90 days (current meet)
Create a sql expression based on that and run it through the Data Window broken out BY RIDER:
query start: 12/9/2011 1:05:34 PM
query end: 12/9/2011 1:05:35 PM
elapsed time: 1 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
`
SQL: SELECT * FROM STARTERHISTORY
WHERE TRAINER='KOBISKIE DANE'
AND TRACK='LRL'
AND DATEDIFF('D',[DATE],NOW()) <= 90
`
`
Data Summary Win Place Show
Mutuel Totals 201.80 165.20 151.60
Bet -170.00 -170.00 -170.00
Gain 31.80 -4.80 -18.40
`
Wins 31 48 56
Plays 85 85 85
PCT .3647 .5647 .6588
`
ROI 1.1871 0.9718 0.8918
Avg Mut 6.51 3.44 2.71
`
`
****************************************************************************************
BY RIDER sorted by wins Run Date: 12/9/2011 1:05:35 PM
****************************************************************************************
WIN WIN WIN PLACE PLACE
UDM PLAYS WINS PCT IMPACT ROI PLACES PCT ROI
****************************************************************************************
DELGADO ALBERTO 53 22 0.4151 1.1382 1.3981 30 0.566 1.0104
ROOK SARAH 19 7 0.3684 1.0101 1.1895 11 0.5789 0.95
DUNKELBERGER TRAVIS 3 1 0.3333 0.9139 0.7 2 0.6667 1.0333
NAVARRO JOSHUA 6 1 0.1667 0.4571 0.35 3 0.5 0.75
NAVARRO KEVIN 1 0 0 0 0 1 1 1.1
COLON LUIS H 1 0 0 0 0 1 1 2.3
RUSSELL SHELDON 1 0 0 0 0 0 0 0
KARAMANOS HORACIO 1 0 0 0 0 0 0 0
****************************************************************************************
8 Riders from file: StarterHistory Table
****************************************************************************************
The above combo(s) may or may not continue to perform well going forward. (Most combos have a shelf life.) However, breaking the data out BY RIDER easily lets you see which rider has been getting first call with the barn's live mounts.
-jp
.
| 