Hunting through data folders on different machines, I was able to scrape together 7 sets of Derby files... 2006-2012.
From there I put each on its own folder, and built a database in mode 1 on each folder.
From there I used Data Window Export to create a quick index file for the starters in those 7 derby day cards only.
From there I used Data Window Export to load the starters from those 7 Derby cards into the starterhistory table of a fresh blank JCapper2.mdb file.
Admittedly, 7 races makes for a small sample. That said, I came up with a simple sql UDM (Hey, it's probably a complete back fit) that managed to peg 6 of the last 7 Derby winners...
query start: 5/4/2013 11:53:05 AM query end: 5/4/2013 11:53:05 AM elapsed time: 0 seconds ` Data Window Settings: Connected to: C:\JCapper\exe\JCapper2_Derby.mdb 999 Divisor Odds Cap: None ` SQL: SELECT * FROM STARTERHISTORY WHERE TRACK='CDX' AND DIST=2200 AND INTSURFACE <= 3 AND FCYCLE <= 2 AND LEN2CALL >= 0.5 AND LEN2CALL < 3.75 AND XTHSTARTRIDER <= 4 AND XTHSTARTLASIX <= 7 ` ` Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 218.60 115.40 87.80 Bet -58.00 -58.00 -58.00 ----------------------------------------------------- P/L 160.60 57.40 29.80 ` Wins 6 7 9 Plays 29 29 29 PCT .2069 .2414 .3103 ` ROI 3.7690 1.9897 1.5138 Avg Mut 36.43 16.49 9.76
The 5 horses it pegged this year?
#3 REVOLUTIONARY 45.00 (ML 10) #5 NORMANDY INVASION 74.47 (ML 12) #7 GIANT FINISH 45.00 (ML 50) #13 FALLING SKY 45.00 (ML 50) #20 VYJACK 45.00 (ML 15)
Just for fun, I edited the above factor constraints for dirt races at all tracks everywhere and ran it through the Data Window. Here's what I have for the races of calendar year 2013 only:
query start: 5/4/2013 12:30:49 PM query end: 5/4/2013 12:30:55 PM elapsed time: 6 seconds ` Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None ` SQL: SELECT * FROM STARTERHISTORY WHERE INTSURFACE <= 3 AND FCYCLE <= 2 AND LEN2CALL >= 0.5 AND LEN2CALL < 3.75 AND XTHSTARTRIDER <= 4 AND XTHSTARTLASIX <= 7 AND [DATE] >= #01-01-2013# AND [DATE] <= #12-31-2013# ORDER BY [DATE], TRACK, RACE ` ` Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 5844.70 5630.50 5727.70 Bet -7426.00 -7426.00 -7426.00 ----------------------------------------------------- P/L -1581.30 -1795.50 -1698.30 ` Wins 756 1322 1828 Plays 3713 3713 3713 PCT .2036 .3560 .4923 ` ROI 0.7871 0.7582 0.7713 Avg Mut 7.73 4.26 3.13
Note that both samples have almost identical win rates (but vastly different roi.)
Could it be that 20 horse fields and tons of money from casual fans make them pay more in the Derby?
And could the "they pay more in the Derby" effect be true in the long run for just about any UDM or decent contender methodology many of us might devise?
Food for thought.
-jp
.
|