Here's what I have in my database for 01-01-2018 current through yesterday 01-14-2019:
query start: 1/15/2019 6:15:17 PM
query end: 1/15/2019 6:15:42 PM
elapsed time: 25 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
SQL UDM Plays Report: Hide
`
SQL: SELECT * FROM STARTERHISTORY
WHERE INSTR(SIRESSIRE, '{1A}') > 0
AND [DATE] >= #01-01-2018#
AND [DATE] <= #01-14-2019#
ORDER BY [DATE], TRACK, RACE
`
`
Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 3250.60 3399.70 3371.40
Bet -4350.00 -4350.00 -4350.00
-----------------------------------------------------
P/L -1099.40 -950.30 -978.60
`
Wins 467 860 1164
Plays 2175 2175 2175
PCT .2147 .3954 .5352
`
ROI 0.7473 0.7815 0.7750
Avg Mut 6.96 3.95 2.90
`
`
****************************************************************************************
BY TRACK sorted by Track Code Run Date: 1/15/2019 6:15:42 PM
****************************************************************************************
WIN WIN WIN PLACE PLACE
TRACK PLAYS WINS PCT IMPACT ROI PLACES PCT ROI
****************************************************************************************
AQU 68 15 0.2206 1.0274 0.5331 32 0.4706 0.7485
BEL 70 15 0.2143 0.9981 0.59 23 0.3286 0.5464
BTP 82 15 0.1829 0.8518 0.7854 31 0.378 0.6555
CDX 40 3 0.075 0.3493 0.3375 9 0.225 0.4175
CLS 7 0 0 0 0 1 0.1429 0.2714
DED 43 15 0.3488 1.6245 0.893 22 0.5116 0.8919
DEL 61 14 0.2295 1.0689 0.9557 21 0.3443 0.7049
ELP 17 4 0.2353 1.0959 0.6059 7 0.4118 1.0118
EVD 64 16 0.25 1.1643 0.6437 30 0.4688 0.8391
FGX 74 11 0.1486 0.6921 0.523 25 0.3378 0.6507
FLX 181 41 0.2265 1.0549 0.732 82 0.453 0.7666
FON 12 1 0.0833 0.388 0.1417 2 0.1667 0.5833
HOU 32 9 0.2813 1.3101 0.8406 14 0.4375 0.8266
HPO 3 0 0 0 0 1 0.3333 1.6
IND 59 9 0.1525 0.7103 0.8 15 0.2542 0.5907
KDX 1 0 0 0 0 1 1 1.05
KEE 17 5 0.2941 1.3697 1.7765 6 0.3529 0.8176
LAD 56 17 0.3036 1.414 0.8 24 0.4286 0.7741
LRL 110 17 0.1545 0.7196 0.63 37 0.3364 0.7286
LSX 52 17 0.3269 1.5225 0.6423 28 0.5385 0.8875
MTH 6 1 0.1667 0.7764 1.15 1 0.1667 0.4333
MVR 180 32 0.1778 0.8281 0.6406 66 0.3667 0.8094
OPX 52 9 0.1731 0.8062 1.0827 19 0.3654 1.0212
PEN 138 31 0.2246 1.046 0.7754 56 0.4058 0.733
PHA 268 60 0.2239 1.0428 0.909 108 0.403 0.9429
PID 152 30 0.1974 0.9194 0.7237 61 0.4013 0.8362
PIM 8 2 0.25 1.1643 0.7 2 0.25 0.4125
RET 28 9 0.3214 1.4969 0.8357 13 0.4643 0.6929
SAR 38 8 0.2105 0.9804 0.4724 16 0.4211 0.6382
SUF 12 3 0.25 1.1643 0.6083 4 0.3333 0.5083
TDN 175 45 0.2571 1.1974 0.7251 77 0.44 0.8111
TIM 1 0 0 0 0 1 1 2.6
TPX 68 13 0.1912 0.8905 1.1279 25 0.3676 0.9051
****************************************************************************************
33 Track Codes from file: StarterHistory Table
****************************************************************************************
About the above sql expression: Prior to my first db build for 2018 I used the Factor Reassignment Screen in the SQL Factor Setup Tool to assign SQL DataBits to the SIRESSIRE field.
Link to screenshot - here:
http://www.jcapper.com/Messageboard/Avatars/FactorReassignmentScreen01.jpg
From there it's a case of looking at the Help Doc for the SQL Databits Field and noting that each horse's saddlecloth number is wrapped inside of curly brackets like this "{1A}" (without the quotes.)
The Data Window query results, which I've broken out BY TRACK, show 33 track codes where the chart data contains at least one runner wearing a saddlecloth bearing "{1A}" (without the quotes.)
I'm thinking the above list should be pretty close to a right answer.
-jp
.
| 