Database Handicapping Software- JCapper

JCapper Message Board

          General Discussion
                      -- Data Base - MatchUp Question

Home Register
Log In
By Data Base - MatchUp Question
jeff
11/7/2008
2:26:12 AM

--quote:
"Jeff, this question was posed on another BBS. Is this possible using your software with it's DB capabilities? Thanks for any information.-----Mike.

Data Base - MatchUp Question


Query:

Two or three early horses in a race with first call times within 1/5 second of each other.

Race projection other than early.

I'm curious how often the early horse wins anyway. (Average odds would be interesting too.)

I'm sure there might be some here with data base capabilities or records of such information.

I could make a "ballpark" guess, but that's all it would be.

Obviously, the early horses are going to win "some" percentage of the time when there is other matching speed in the race, but I'm curious what that might be broken down for sprint/route, turf, poly, overall, etc. There might even be a big difference between maiden and claimers, allowance and stakes races.

I'm not talking about using Quirin speed points, but actual first call times.

Thanks to anyone that can help."
--end quote


Received the above question from someone who posts at Binder's Pace and Cap (Sartin) Board via email on Thurs. Thought I would take a stab at it. Here's the answer I sent back:

Hi Mike,

The "gotcha" that you threw in is the phrase "Race projection other than early."

What I have to say might ruffle a few feathers because it goes against the grain of current discussions on Sartin match up concepts...

But my own research very clearly indicates the most accurate means of projecting a race as either "early" or "other than early" has far more to do with the surface being either speed friendly or speed tiring than the amount of pace pressure within a race or the way that the horses within the race match up. On speed tiring surfaces early horses tire early and spit the bit. On speed favoring surfaces even cheap speed has the ability to wire almost any field.

My research very clearly indicates two long term patterns as the public bets the races:

1. Early speed is consistently ignored while late speed is consistently overbet.

2. Form or readiness is a measurable commodity and the public has very little idea of how to go about doing that. Workouts can be a good way to identify readiness. Horses with 5f or longer bullet drills are frequently ignored by the public. Yet if the same "move" were made in the afternoon during a race the public would be all over the horse.

Ok. That said, back to your question: "How often does the early horse win?"

I'll try to run a few data samples and shoot them your way (time allowing) later.


-jp

.


Reply
jeff
11/7/2008
3:36:54 AM
Before I start posting actual data, a few explanations about the data itself might be in order. First, all data used in this study was compiled using Bris DRF Single Format Data Files. All races used in the study were run during the first 3 calendar quarters of 2008.

Second, in the results presented below, I didn't make any attempt to pre-project races as being "early" or "other than early." My philosophy has always been to basically let the data point the way.

Second, the fields in my database do not include raw fractional time. There are fields for E1 and E2 pace figures (Bris) which are based on raw fractional time and variant.

For purposes of this study I used a number in JCapper known as CompoundE1. CompoundE1 is generated by an algorithm I wrote designed to pick relevant pace lines found in a horse's record. Understand that pace lines picked by the algorithm may well be different from lines that individual handicappers might pick. The algorithm is 100 pct mechanical. And like most algorithms it won't ever get flustered by a rash of recent bad results. The algorithm itself is the result of several hundred hours of R&D time spent at the Data Window by yours truly during the latter part of 2007.

CompoundE1 is (I think) the best number in JCapper that can be used to approximate "1/5 of a second."

Constraint: Two or three early horses in a race with first call times within 1/5 second of each other.

I purposely ignored the run style aspect of this constraint. I decided I wanted to see results for any and all horses within "1/5 of a second" of each other no matter what their run style might be. I promise I'll break out the results by run style later.

To satisfy the "1/5 of a second" requirement I merely grabbed those races where two or more horses that had previously run existed where CompoundE1 was within 2 points of each other. The phrase "previously run" means that the study does not include data for races full of first time starters. Why 2 points? I found the following explanation in the Library section of the Bris site: "the BRIS Pace Ratings use a fixed scale of 2-points-per-length for all pace calls." Going on the assumption that 1 length equals 1/5 of a second I used 2 points of CompoundE1 as my dividing line.

Continued...


-jp

.


~Edited by: jeff  on:  11/7/2008  at:  3:36:54 AM~

Reply
jeff
11/7/2008
5:33:51 AM
As promised here is the data itself.

First, to give perspective to the numbers that I'll post shortly, here are all starters during the time period of the study:

Data Window Settings:
999 Divisor Odds Cap: None
Surface: (ALL*) Distance: (All*)
From Index File: C:\2008\pl_2008.txt)

`
Data Summary Win Place Show
Mutuel Totals 259466.00 257474.70 257357.00
Bet -341222.00-341222.00-341222.00
Gain -81756.00 -83747.30 -83865.00
`
Wins 21080 41920 61740
Plays 170611 170611 170611
PCT .1236 .2457 .3619
`
ROI 0.7604 0.7546 0.7542
Avg Mut 12.31 6.14 4.17





Now, here are all horses meeting the constraint of being within "1/5 of a second" based on there being at least 2 horses in a race where CompoundE1 gap for those horses is within 2 points:


Surface: (ALL*) Distance: (All*)
From Index File: C:\2008\pl_2008.txt)

`
Data Summary Win Place Show
Mutuel Totals 39339.50 37414.20 36856.60
Bet -44802.00 -44802.00 -44802.00
Gain -5462.50 -7387.80 -7945.40
`
Wins 3920 7169 9906
Plays 22401 22401 22401
PCT .1750 .3200 .4422
`
ROI 0.8781 0.8351 0.8227
Avg Mut 10.04 5.22 3.72

The first thing that catches the eye is that the above sample (restricted to horses that are within 1/5 of a second or grouped within 2 points of CompoundE1) outperforms all horses that ran within the time period of the sample. Not just for win rate but roi-wise as well. This is to be expected. Almost every large sample based on early speed that I've ever looked at does this. Simply put: The public almost always underestimates early speed.

Be aware that the "breakout" numbers I post from this point forward in this thread are all based on the above table for "1/5 of a second" horses.

Here is data for for "1/5 of a second" horses broken out by CompoundE1 Rank:

By: CompoundE1 Rank
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -1734.10 18628.00 0.9069 1753 9314 .1882 1.0755
2 -2922.90 18376.00 0.8409 1563 9188 .1701 0.9721
3 -229.90 5918.00 0.9612 483 2959 .1632 0.9328
4 -433.40 1524.00 0.7156 103 762 .1352 0.7724
5 -135.80 306.00 0.5562 16 153 .1046 0.5976
6 -2.40 46.00 0.9478 2 23 .0870 0.4969
7 -4.00 4.00 0.0000 0 2 .0000 0.0000

What should catch the eye here is that even though the horses in the sample are all within 1/5 of a second of each other, the data shows a nice orderly distribution. The top ranked horse wins more often than the second ranked horse and so on right down the line. That should tell you that being within 1/5 of a second of each other does not make them equal. Keep this in mind as you start to ask yourself "Which of these is the most likely winner?"

Specifically take note of the top 3 vs ranks 4 and lower.

jp

.

Continued...

~Edited by: jeff  on:  11/7/2008  at:  5:33:51 AM~

Reply
jeff
11/7/2008
4:59:37 AM
Now, here is the data broken out by run style:

By: Running Style
`
Running Style Gain Bet Roi Wins Plays Pct Impact
1 -2100.00 18970.00 0.8893 1587 9485 .1673 0.9561 E
2 -1314.40 16112.00 0.9184 1541 8056 .1913 1.0931 EP
3 -525.00 5366.00 0.9022 535 2683 .1994 1.1395 P
4 -400.90 1678.00 0.7611 137 839 .1633 0.9331 S
5 -1122.20 2676.00 0.5806 120 1338 .0897 0.5125 NA

Note that these are Bris run styles which may be quite different than either Sartin run styles or run styles assigned by an individual handicapper. Despite that, note the difference in the numbers for E, EP, & P runners vs S and NA runners.

The original question was sent to me by a Sartin handicapper looking for hard data to be used to help him match them up and decide which (if any) might be worth betting. I'd be remiss if I didn't point out that JCapper has a factor called CompoundPaceFit which is a number produced by an algorithm that does just that. Here is the data broken out by JCapper CompoundPaceFit:

By: CompoundPaceFit Rank `
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -1029.60 16700.00 0.9383 1737 8350 .2080 1.1888
2 -2531.30 13356.00 0.8105 1147 6678 .1718 0.9815
3 -450.30 7624.00 0.9409 591 3812 .1550 0.8860
4 -697.20 3338.00 0.7911 224 1669 .1342 0.7670
5 -231.60 1484.00 0.8439 103 742 .1388 0.7933
6 -218.20 834.00 0.7384 44 417 .1055 0.6030
7 -31.40 548.00 0.9427 33 274 .1204 0.6882
8 -86.50 412.00 0.7900 21 206 .1019 0.5826
9 -93.40 230.00 0.5939 9 115 .0783 0.4472
10 -28.80 188.00 0.8468 8 94 .0851 0.4863
11 -40.80 52.00 0.2154 1 26 .0385 0.2198
12 -9.40 22.00 0.5727 2 11 .1818 1.0390
13 -8.00 8.00 0.0000 0 4 .0000 0.0000
14 -6.00 6.00 0.0000 0 3 .0000 0.0000

Note the win rate and overall roi of the top 3 vs ranks 4 and lower.

In my initial answer I replied that Form was an important separator. Here is the data broken out by JCapper Form Rating:

By: Form Rating Rank
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -324.00 7562.00 0.9572 779 3781 .2060 1.1774
2 -214.40 6260.00 0.9658 631 3130 .2016 1.1520
3 -884.40 5808.00 0.8477 520 2904 .1791 1.0233
4 -690.00 5540.00 0.8755 472 2770 .1704 0.9737
5 -788.20 5266.00 0.8503 474 2633 .1800 1.0287
6 -703.10 4696.00 0.8503 365 2348 .1555 0.8883
7 -680.00 3748.00 0.8186 286 1874 .1526 0.8721
8 -502.80 2606.00 0.8071 193 1303 .1481 0.8464
9 -369.30 1722.00 0.7855 109 861 .1266 0.7234
10 -279.30 996.00 0.7196 57 498 .1145 0.6541
11 -143.50 402.00 0.6430 16 201 .0796 0.4549
12 110.50 172.00 1.6424 15 86 .1744 0.9967
13 8.00 22.00 1.3636 3 11 .2727 1.5585
14 -2.00 2.00 0.0000 0 1 .0000 0.0000
15 0.00 0.00 0.0000 0 0 .0000 0.0000

`
`
`
`
By: Form Rating Number
`
>=Min < Max Gain Bet Roi Wins Plays Pct Impact
-999.00 20.00 0.00 0.00 0.0000 0 0 .0000 0.0000
20.00 25.00 0.00 0.00 0.0000 0 0 .0000 0.0000
25.00 30.00 0.00 0.00 0.0000 0 0 .0000 0.0000
30.00 35.00 0.00 0.00 0.0000 0 0 .0000 0.0000
35.00 40.00 0.00 0.00 0.0000 0 0 .0000 0.0000
40.00 45.00 0.00 0.00 0.0000 0 0 .0000 0.0000
45.00 50.00 0.00 0.00 0.0000 0 0 .0000 0.0000
50.00 55.00 -338.10 1058.00 0.6804 57 529 .1078 0.6157
55.00 60.00 -631.40 1912.00 0.6698 119 956 .1245 0.7113
60.00 65.00 -870.00 4080.00 0.7868 305 2040 .1495 0.8544
65.00 70.00 -164.60 5940.00 0.9723 492 2970 .1657 0.9467
70.00 75.00 -1526.00 7554.00 0.7980 606 3777 .1604 0.9169
75.00 80.00 -688.40 8122.00 0.9152 738 4061 .1817 1.0385
80.00 85.00 -718.00 6170.00 0.8836 577 3085 .1870 1.0688
85.00 90.00 -494.80 5244.00 0.9056 512 2622 .1953 1.1159
90.00 95.00 -22.00 2428.00 0.9909 260 1214 .2142 1.2239
95.00 100.00 -38.00 1382.00 0.9725 147 691 .2127 1.2157
100.00 105.00 28.80 912.00 1.0316 107 456 .2346 1.3409
105.00 110.00 0.00 0.00 0.0000 0 0 .0000 0.0000
110.00 999999.00 0.00 0.00 0.0000 0 0 .0000 0.0000

Note the win rate and roi for the top 2 in Form vs ranks 3 and lower. Also note that near break even play appears possible with these horses when Form Rating is >= 90.

Here is the data broken out by JCapper BasicFitness:

By: BasicFitness
`
>=Min < Max Gain Bet Roi Wins Plays Pct Impact
-999.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.0000
0.00 5.00 -539.60 3156.00 0.8290 234 1578 .1483 0.8474
5.00 10.00 -2416.90 21094.00 0.8854 1816 10547 .1722 0.9839
10.00 15.00 -862.40 2884.00 0.7010 216 1442 .1498 0.8560
15.00 20.00 -1450.50 6352.00 0.7716 528 3176 .1662 0.9500
20.00 25.00 -251.50 5494.00 0.9542 521 2747 .1897 1.0838
25.00 30.00 -107.00 3232.00 0.9669 329 1616 .2036 1.1634
30.00 35.00 165.40 2590.00 1.0639 276 1295 .2131 1.2179

Note the win rate and roi when BF is >= 20 vs the same for those below 20.



-jp

.

To be continued...







~Edited by: jeff  on:  11/7/2008  at:  4:59:37 AM~

Reply
jeff
11/7/2008
5:21:19 AM
In my initial reply I said that track surface plays a big part in projecting "early" vs "other than early."

Off the top of my head tracks that ran noticeably other than early this year were TPX, SAX-OSA, and SAR.

Here is the data from Dirt races (in the case of SAX-OSA dirt can include bits of rubber and carpet fiber) at TPX-SAX-OSA-SAR:

Data Window Settings:
999 Divisor Odds Cap: None
Dirt (All*) Distance: (All*)
From Index File: C:\2008\pl_1FifthOfASecond.txt
Track: TPX-SAX-OSA-SAR
`
Data Summary Win Place Show
Mutuel Totals 1970.50 2103.80 2259.40
Bet -2716.00 -2716.00 -2716.00
Gain -745.50 -612.20 -456.60
`
Wins 214 399 582
Plays 1358 1358 1358
PCT .1576 .2938 .4286
`
ROI 0.7255 0.7746 0.8319
Avg Mut 9.21 5.27 3.88

Note the reduced win rate and roi for these horses on speed tiring surfaces vs win rate and roi for the overall sample.

-jp

.


To be continued...

Reply
jeff
11/7/2008
1:23:47 PM
Some more Form based numbers...

Here is the data broken out by Workout Brilliance:

By: Workout Brilliance (in fps)
`
>=Min < Max Gain Bet Roi Wins Plays Pct Impact
-999.00 50.00 -2948.70 19376.00 0.8478 1559 9688 .1609 0.9196
50.00 50.50 -110.70 396.00 0.7205 33 198 .1667 0.9524
50.50 51.00 -46.70 766.00 0.9390 54 383 .1410 0.8057
51.00 51.50 -90.40 720.00 0.8744 61 360 .1694 0.9683
51.50 52.00 -578.20 1630.00 0.6453 122 815 .1497 0.8554
52.00 52.50 -315.20 1678.00 0.8122 139 839 .1657 0.9467
52.50 53.00 -272.60 2500.00 0.8910 245 1250 .1960 1.1201
53.00 53.50 -490.90 3738.00 0.8687 315 1869 .1685 0.9631
53.50 54.00 -599.20 3250.00 0.8156 288 1625 .1772 1.0128
54.00 54.50 353.20 3098.00 1.1140 323 1549 .2085 1.1916
54.50 55.00 -171.10 2310.00 0.9259 225 1155 .1948 1.1132
55.00 55.50 -311.70 2956.00 0.8946 302 1478 .2043 1.1677
55.50 56.00 -64.60 1176.00 0.9451 114 588 .1939 1.1079
56.00 56.50 145.70 694.00 1.2099 86 347 .2478 1.4163
56.50 57.00 -25.40 312.00 0.9186 27 156 .1731 0.9891
57.00 57.50 -10.10 140.00 0.9279 15 70 .2143 1.2245
57.50 58.00 42.80 34.00 2.2588 8 17 .4706 2.6892
58.00 58.50 7.70 16.00 1.4813 3 8 .3750 2.1430
58.50 59.00 23.60 12.00 2.9667 1 6 .1667 0.9524
59.00 999999.00 0.00 0.00 0.0000 0 0 .0000 0.0000

Notice the win rate and roi for those rated at 54 or higher vs those below 54.


Here is the data broken out by Race Brilliance:

By: Race Brilliance (in fps)
`
>=Min < Max Gain Bet Roi Wins Plays Pct Impact
-999.00 48.00 -1947.80 11428.00 0.8296 928 5714 .1624 0.9281
48.00 48.50 0.80 2.00 1.4000 1 1 1.0000 5.7145
48.50 49.00 0.00 0.00 0.0000 0 0 .0000 0.0000
49.00 49.50 0.00 0.00 0.0000 0 0 .0000 0.0000
49.50 50.00 -2.00 2.00 0.0000 0 1 .0000 0.0000
50.00 50.50 -4.00 4.00 0.0000 0 2 .0000 0.0000
50.50 51.00 -12.00 12.00 0.0000 0 6 .0000 0.0000
51.00 51.50 -5.20 22.00 0.7636 2 11 .1818 1.0390
51.50 52.00 39.50 64.00 1.6172 7 32 .2188 1.2501
52.00 52.50 -28.10 138.00 0.7964 11 69 .1594 0.9110
52.50 53.00 -128.40 358.00 0.6413 23 179 .1285 0.7343
53.00 53.50 30.00 558.00 1.0538 48 279 .1720 0.9831
53.50 54.00 -147.60 1032.00 0.8570 93 516 .1802 1.0299
54.00 54.50 -47.00 1588.00 0.9704 128 794 .1612 0.9212
54.50 55.00 -423.20 2198.00 0.8075 174 1099 .1583 0.9048
55.00 55.50 -486.70 2776.00 0.8247 222 1388 .1599 0.9140
55.50 56.00 -252.00 3286.00 0.9233 268 1643 .1631 0.9321
56.00 56.50 -381.80 3790.00 0.8993 320 1895 .1689 0.9650
56.50 57.00 -892.40 4262.00 0.7906 358 2131 .1680 0.9600
57.00 999999.00 -774.60 13282.00 0.9417 1337 6641 .2013 1.1505

Note the win rate and roi for those rated at 57 or higher vs those below.


-jp

.



To be continued...

Reply
jeff
11/7/2008
1:28:32 PM
What about trainer intent?

Here is the data broken out by CLEAN/DIRTY and Route Debut:

By: CANTRUN/XFORM Attribute
`
CANTRUN Gain Bet Roi Wins Plays Pct Impact
0 -1785.10 22178.00 0.9195 2099 11089 .1893 1.0817 Clean Horse
1 -3241.90 20666.00 0.8431 1765 10333 .1708 0.9761 XFORM
2 -435.50 1958.00 0.7776 56 979 .0572 0.3269 CANTRUN
`
`
`
`
By: Route Debut
`
Route Debut Gain Bet Roi Wins Plays Pct Impact
0 -4622.20 42526.00 0.8913 3777 21263 .1776 1.0151 Route Debut: FALSE
1 -840.30 2276.00 0.6308 143 1138 .1257 0.7181 Route Debut: TRUE


Note the win rate and roi for CLEAN horses vs DIRTY horses. Also note what happens when "1/5 of a second" horses make their route debut.



-jp

.

To be continued

Reply
jeff
11/7/2008
1:48:47 PM
Let's have a look at a few other JCapper factors. Here is the data broken out by PMI, CMI, and Optimization Points:

By: PMI Rank
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -729.20 10680.00 0.9317 1444 5340 .2704 1.5453
2 -980.60 9198.00 0.8934 909 4599 .1977 1.1295
3 -1436.40 7398.00 0.8058 563 3699 .1522 0.8698
4 -519.20 6384.00 0.9187 451 3192 .1413 0.8074
5 -926.10 5492.00 0.8314 301 2746 .1096 0.6264
6 -934.60 4056.00 0.7696 150 2028 .0740 0.4227
7 69.60 1588.00 1.0438 102 794 .1285 0.7341
8 -4.00 4.00 0.0000 0 2 .0000 0.0000
9 -2.00 2.00 0.0000 0 1 .0000 0.0000

`
`
`
`
`


By: CMI Rank
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -353.90 9876.00 0.9642 1198 4938 .2426 1.3864
2 -725.10 8546.00 0.9152 876 4273 .2050 1.1715
3 -1105.20 7868.00 0.8595 667 3934 .1695 0.9689
4 -1161.40 6970.00 0.8334 519 3485 .1489 0.8510
5 -1385.90 5828.00 0.7622 357 2914 .1225 0.7001
6 -771.40 4150.00 0.8141 205 2075 .0988 0.5646
7 42.40 1562.00 1.0271 98 781 .1255 0.7171
8 -2.00 2.00 0.0000 0 1 .0000 0.0000

`
`
`
`
`

By: Optimization Points Rank
`
Rank Gain Bet Roi Wins Plays Pct Impact
1 -690.80 10920.00 0.9367 1311 5460 .2401 1.3721
2 -370.80 7784.00 0.9524 829 3892 .2130 1.2172
3 -580.40 3664.00 0.8416 269 1832 .1468 0.8391
4 -1436.50 7962.00 0.8196 727 3981 .1826 1.0436
5 -1830.10 8042.00 0.7724 456 4021 .1134 0.6481
6 -435.00 5268.00 0.9174 275 2634 .1044 0.5966
7 -42.70 1080.00 0.9605 52 540 .0963 0.5503
8 -76.20 82.00 0.0707 1 41 .0244 0.1394

Note the win rate and roi of the top ranked horses for these factors vs win rate and roi for the lower ranked horses. Keep in mind that PMI emphasizes early speed and current form... CMI emphasizes class and current form... while Opt Points emphasizes both.

-jp

.

To be continued...

Reply
jeff
11/7/2008
2:01:26 PM
Ok. That's some basic data. To recap, the study looks at multiple horses grouped within 1/5 of a second of each other using JCapper CompoundE1.

From the above I'm going to attempt to draw a few conclusions:

1. Early speed is still underestimated by the betting public.

2. Being within 1/5 of a second of each other on paper means these horses are very close in ability. However (my opinion) very close in ability is not quite the same thing as equal in ability. Data in this study suggests there are ways of separating horses that are very close in ability.

3. Form appears to be one way of separating horses that are very close in ability.

4. Trainer intent also appears to be a way separating horses that are very close in ability.

5. Surface (if you are able to identify it ahead of time) can have a profound effect on the ability of early speed horses to finish their races.

Looking at the data I see several areas that would appear to offer solid UDM potential. For those who want to pursue things further and create a UDM or two - have at it.


-jp

.

Reply
JustRalph
11/7/2008
4:14:54 PM
after reading this thread, I realize one thing............



MY UDM's Suck!!

now wonder my horses keep stopping in the lane



Back to the drawing board...........LOL!@

~Edited by: JustRalph  on:  11/7/2008  at:  4:14:54 PM~

Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com