Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Basic Handicapping

Home Register
Log In
By Basic Handicapping
Caveat
4/1/2013
8:55:15 AM

Hi Guys...

How do you determine what posts are bad in this situation..Do you go by wins,roi,pct,or impact values?


code:
By: Rail Position

Rail Pos Gain Bet Roi Wins Plays Pct Impact
1 -212.80 478.00 0.5548 17 239 .0711 0.6256
2 -192.00 478.00 0.5983 24 239 .1004 0.8832
3 -149.40 478.00 0.6874 25 239 .1046 0.9200
4 -188.00 478.00 0.6067 30 239 .1255 1.1040
5 33.20 478.00 1.0695 33 239 .1381 1.2144
6 0.80 472.00 1.0017 31 236 .1314 1.1553
7 -176.00 446.00 0.6054 24 223 .1076 0.9465
8 -76.40 350.00 0.7817 22 175 .1257 1.1057
9 53.80 248.00 1.2169 15 124 .1210 1.0639
10 1.80 162.00 1.0111 12 81 .1481 1.3030
11 -49.80 94.00 0.4702 4 47 .0851 0.7485
12 39.40 42.00 1.9381 2 21 .0952 0.8376
13 0.00 0.00 0.0000 0 0 .0000 0.0000
14 0.00 0.00 0.0000 0 0 .0000 0.0000
15 0.00 0.00 0.0000 0 0 .0000 0.0000
16 0.00 0.00 0.0000 0 0 .0000 0.0000
17 0.00 0.00 0.0000 0 0 .0000 0.0000
18 0.00 0.00 0.0000 0 0 .0000 0.0000
19 0.00 0.00 0.0000 0 0 .0000 0.0000



Thxs
Mike

Reply
AndrewH
4/1/2013
8:59:05 AM
I'd personally go by impact seeing how the factor is post position. If the factor was a factor that I was using to find value then I'd go by ROI but in this case you are trying to handicap instead of find value.

I'd also like to hear what others have to say.

AJ

Reply
jeff
4/1/2013
12:46:04 PM
Win rate, impact value, and roi... those are just measurements programmed into an app like the Data Window used to report attributes found in a data sample.

How the player interprets a sample - that can be everything.

Whenever I look at a data sample - I find myself constantly asking the following question:

"How does this data sample compare to the big picture?"

More often than not - I find that the act of contrasting the individual sample against the big picture - enables me to interpret the individual sample with better clarity.

Win rate, impact value, and roi?... Each of those measurements helps me get there.




Here are some big picture rail position results pulled from the Data Window...

First up - all dirt races no matter what the track code or distance over the past 365 days:


query start: 4/1/2013 8:53:19 AM
query end: 4/1/2013 8:55:18 AM
elapsed time: 119 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
Betting Instructions: Testing Purposes Only
`
UDM: 0_1TrackDateExpression
`
SQL: SELECT * FROM STARTERHISTORY
WHERE DATEDIFF('D',[DATE],NOW()) <= 365
AND INTSURFACE <= 3
`
`
Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 491112.90 490867.60 490227.10
Bet -651848.00 -651848.00 -651848.00
-----------------------------------------------------
P/L -160735.10 -160980.40 -161620.90
`
Wins 42814 85194 124095
Plays 325924 325924 325924
PCT .1314 .2614 .3807
`
ROI 0.7534 0.7530 0.7521
Avg Mut 11.47 5.76 3.95
`
`
By: Rail Position
`
Rail Pos P/L Bet Roi Wins Plays Pct Impact
-----------------------------------------------------------------------
1 -20242.40 84314.00 0.7599 6096 42157 .1446 1.1008
2 -19344.90 84314.00 0.7706 5892 42157 .1398 1.0640
3 -18781.80 84304.00 0.7772 5999 42152 .1423 1.0834
4 -22833.20 84154.00 0.7287 5753 42077 .1367 1.0408
5 -20503.30 82884.00 0.7526 5667 41442 .1367 1.0410
6 -21123.80 76440.00 0.7237 4910 38220 .1285 0.9780
7 -15563.30 60616.00 0.7432 3520 30308 .1161 0.8841
8 -11496.90 42242.00 0.7278 2309 21121 .1093 0.8322
9 -4984.70 26652.00 0.8130 1413 13326 .1060 0.8072
10 -3987.80 15502.00 0.7428 788 7751 .1017 0.7739
11 -1113.00 6354.00 0.8248 288 3177 .0907 0.6901
12 -586.30 3166.00 0.8148 143 1583 .0903 0.6877
13 -23.90 600.00 0.9602 26 300 .0867 0.6598
14 -170.40 294.00 0.4204 9 147 .0612 0.4661
15 -2.00 2.00 0.0000 0 1 .0000 0.0000
16 -2.00 2.00 0.0000 0 1 .0000 0.0000
17 -2.00 2.00 0.0000 0 1 .0000 0.0000
18 -2.00 2.00 0.0000 0 1 .0000 0.0000
19 28.60 4.00 8.1500 1 2 .5000 3.8063





Next up - all turf races no matter what the track code or distance over the past 365 days:


query start: 4/1/2013 8:56:41 AM
query end: 4/1/2013 8:57:03 AM
elapsed time: 22 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
Betting Instructions: Testing Purposes Only
`
UDM: 0_1TrackDateExpression
`
SQL: SELECT * FROM STARTERHISTORY
WHERE DATEDIFF('D',[DATE],NOW()) <= 365
AND INTSURFACE >= 4
`
`
Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 82723.40 82306.20 81866.50
Bet -108814.00 -108814.00 -108814.00
-----------------------------------------------------
P/L -26090.60 -26507.80 -26947.50
`
Wins 6179 12344 18377
Plays 54407 54407 54407
PCT .1136 .2269 .3378
`
ROI 0.7602 0.7564 0.7524
Avg Mut 13.39 6.67 4.45
`
`
By: Rail Position
`
Rail Pos P/L Bet Roi Wins Plays Pct Impact
-----------------------------------------------------------------------
1 -2548.60 12200.00 0.7911 790 6100 .1295 1.1403
2 -1607.80 12200.00 0.8682 829 6100 .1359 1.1966
3 -2296.10 12200.00 0.8118 791 6100 .1297 1.1418
4 -2899.50 12198.00 0.7623 782 6099 .1282 1.1290
5 -2417.70 12160.00 0.8012 735 6080 .1209 1.0644
6 -3123.30 11902.00 0.7376 631 5951 .1060 0.9336
7 -2936.90 10922.00 0.7311 537 5461 .0983 0.8658
8 -2248.70 9300.00 0.7582 456 4650 .0981 0.8635
9 -2683.10 7034.00 0.6186 307 3517 .0873 0.7686
10 -1776.70 4890.00 0.6367 195 2445 .0798 0.7023
11 -774.00 2338.00 0.6689 84 1169 .0719 0.6327
12 -615.80 1262.00 0.5120 36 631 .0571 0.5024
13 -102.00 138.00 0.2609 5 69 .0725 0.6381
14 -60.40 70.00 0.1371 1 35 .0286 0.2516
15 0.00 0.00 0.0000 0 0 .0000 0.0000
16 0.00 0.00 0.0000 0 0 .0000 0.0000
17 0.00 0.00 0.0000 0 0 .0000 0.0000
18 0.00 0.00 0.0000 0 0 .0000 0.0000
19 0.00 0.00 0.0000 0 0 .0000 0.0000





Using each of the available metrics, win rate, impact value, and roi - when you compare your sample to the above big picture samples, what do you see in terms of rail position?

I see a dead rail.





-jp

.



~Edited by: jeff  on:  4/1/2013  at:  12:46:04 PM~

Reply
Caveat
4/2/2013
7:40:50 AM

Thxs Andrew , I was see it the same way

Jeff , I don't get your response here...

The statement that the fastest time between 2 points is the shortest distance traveled....so its obvious that post 1 will be the fastest, post 2 is the second fastest, post 3 is the third fastest, etc, etc..
But all tracks are not created equal..


According to your stats, post 1 is "dead" OK
But there are tracks where post one is golden , post 2 is terrible, outside posts are better ( Tampa) and so on..
But not doing R & D wont make you aware of track tendencies.
And when one of your "universal" UDM's pop one up, how would you bet it pertaining to the track bias's?

Here's March..

Post 1 on dirt


code:
UDM Definition:   POST_1
Divisor: # UDM Def Divisor: 999
Surface Req: D*
Distance Req: *ANY Distance*

Rail Position: MinVal= 1 MaxVal= 1
Running Style: ALL


query start: 4/2/2013 8:19:18 AM
query end: 4/2/2013 8:19:28 AM
elapsed time: 10 seconds

Data Window Settings:
Divisor = 999 Odds Cap: None
Filters Applied:

Dirt (All*) Distance: (All*) (From Index File: C:\2013_MAR\pL_profile.txt)


Data Summary Win Place Show
Mutuel Totals 4582.60 4456.60 4371.80
Bet -6058.00 -6058.00 -6058.00
Gain -1475.40 -1601.40 -1686.20

Wins 457 859 1204
Plays 3029 3029 3029
PCT .1509 .2836 .3975

ROI 0.7565 0.7357 0.7217
Avg Mut 10.03 5.19 3.63






Here's Post 2 on dirt


code:
UDM Definition:   POST_2
Divisor: # UDM Def Divisor: 999
Surface Req: D*
Distance Req: *ANY Distance*

Rail Position: MinVal= 2 MaxVal= 2
Running Style: ALL


query start: 4/2/2013 8:21:35 AM
query end: 4/2/2013 8:21:45 AM
elapsed time: 10 seconds

Data Window Settings:
Divisor = 999 Odds Cap: None
Filters Applied:

Dirt (All*) Distance: (All*) (From Index File: C:\2013_MAR\pL_profile.txt)


Data Summary Win Place Show
Mutuel Totals 4230.80 4565.00 4653.80
Bet -6058.00 -6058.00 -6058.00
Gain -1827.20 -1493.00 -1404.20

Wins 387 808 1189
Plays 3029 3029 3029
PCT .1278 .2668 .3925

ROI 0.6984 0.7535 0.7682
Avg Mut 10.93 5.65 3.91



Here's post 3


code:
UDM Definition:   post_3
Divisor: # UDM Def Divisor: 999
Surface Req: D*
Distance Req: *ANY Distance*

Rail Position: MinVal= 3 MaxVal= 3
Running Style: ALL


query start: 4/2/2013 8:30:39 AM
query end: 4/2/2013 8:30:49 AM
elapsed time: 10 seconds

Data Window Settings:
Divisor = 999 Odds Cap: None
Filters Applied:

Dirt (All*) Distance: (All*) (From Index File: C:\2013_MAR\pL_profile.txt)


Data Summary Win Place Show
Mutuel Totals 4908.50 4601.00 4551.40
Bet -6058.00 -6058.00 -6058.00
Gain -1149.50 -1457.00 -1506.60

Wins 436 839 1210
Plays 3029 3029 3029
PCT .1439 .2770 .3995

ROI 0.8103 0.7595 0.7513
Avg Mut 11.26 5.48 3.76



So betting post 2 plays would have cost you in March..

This game is so difficult..:(
What I was considering to do was to do some sort of R & D for whats happening now as compared to the big picture.
I'm lost

mike

~Edited by: Caveat  on:  4/2/2013  at:  7:36:42 AM~

~Edited by: Caveat  on:  4/2/2013  at:  7:40:50 AM~

Reply
jeff
4/2/2013
1:13:13 PM
I'm guessing that the rail position stats in post #1 at the very top of this thread are track specific.

Going with that assumption...

Purposely setting background color for the inner 3 posts in red to make them stand out - here's a cut and paste of those rail position stats again:

Rail Pos Gain Bet Roi Wins Plays Pct Impact
1 -212.80 478.00 0.5548 17 239 .0711 0.6256
2 -192.00 478.00 0.5983 24 239 .1004 0.8832
3 -149.40 478.00 0.6874 25 239 .1046 0.9200

4 -188.00 478.00 0.6067 30 239 .1255 1.1040
5 33.20 478.00 1.0695 33 239 .1381 1.2144
6 0.80 472.00 1.0017 31 236 .1314 1.1553
7 -176.00 446.00 0.6054 24 223 .1076 0.9465
8 -76.40 350.00 0.7817 22 175 .1257 1.1057
9 53.80 248.00 1.2169 15 124 .1210 1.0639
10 1.80 162.00 1.0111 12 81 .1481 1.3030
11 -49.80 94.00 0.4702 4 47 .0851 0.7485
12 39.40 42.00 1.9381 2 21 .0952 0.8376




Purposely setting background color for the inner 3 posts in blue to make them stand out - here's a re-post of the dirt surface rail position stats from the big picture sample that I posted above:

Rail Pos Gain Bet Roi Wins Plays Pct Impact
1 -20242.40 84314.00 0.7599 6096 42157 .1446 1.1008
2 -19344.90 84314.00 0.7706 5892 42157 .1398 1.0640
3 -18781.80 84304.00 0.7772 5999 42152 .1423 1.0834

4 -22833.20 84154.00 0.7287 5753 42077 .1367 1.0408
5 -20503.30 82884.00 0.7526 5667 41442 .1367 1.0410
6 -21123.80 76440.00 0.7237 4910 38220 .1285 0.9780
7 -15563.30 60616.00 0.7432 3520 30308 .1161 0.8841
8 -11496.90 42242.00 0.7278 2309 21121 .1093 0.8322
9 -4984.70 26652.00 0.8130 1413 13326 .1060 0.8072
10 -3987.80 15502.00 0.7428 788 7751 .1017 0.7739
11 -1113.00 6354.00 0.8248 288 3177 .0907 0.6901
12 -586.30 3166.00 0.8148 143 1583 .0903 0.6877...



Now, compare the track specific (or small picture) sample for posts 1-3 (in red) to the the big picture sample for posts 1-3 in blue.

How does the small picture sample compare to the big picture sample?

The small picture sample for posts 1-3 shows markedly lower win rate, impact value, and roi than the big picture sample.

If the small picture sample is track specific, the first question that needs to be answered is:

Why?

Why is there such a disparity between the two samples?

Are the numbers in the small picture sample simply the result of small sample "noise?"

Or is there some physical cause behind the difference?

Often times, I can get a sense by watching replays... especially the head on.

Is there a dead rail at the track where the small picture sample was taken?




Going forward with the idea that I do in fact think the track where the small picture sample was taken does in fact have a dead rail...

You asked:
"And when one of your "universal" UDM's pop one up, how would you bet it pertaining to the track bias's?"


Great question.

Suppose I have a speed-pace-form-cxn-value business UDM (universal in nature/not track specific) that produces good results overall.

In addition, I also have several negative layering UDMs that are track specific - and some of these negative layering UDMs are designed to do nothing more than point out horses unlucky enough to have drawn an inner post at a track-surf-dist configuration where the small picture stats for rail position are similar to the numbers posted in red above.

Let's further suppose a look at my html report reveals a horse flagged by both types of UDMs.

The business UDMs tell me the horse has good speed-pace-form-cxn and potentially value...

But the negative layering UDMs tell me the value part might be questionable because the horse will likely be compromised by the course layout...

• How best to approach this?

Every single one of us has probably encountered this situation - or a situation nearly identical to it - many times in the past.

What do my wager history records indicate?

FYI, this is the approach that I've adopted over the past 15 months. I can easily run the intersection of Business and Layering UDMs through JCapper's WagerHistory Module and break the data out by nearly every data point available in the Data Window.

From this I gain the ability to (hopefully) make an informed decision ahead of time how I will act when I am confronted by this (or similar) situations on race day.

Based on the performance of my own UDMs - at the tracks that I bet - the numbers in my WagerHistory table suggest that my best course of action in this situation is to:

1. Require higher odds than I normally would if the horse "fit" the track profile.

2. Scale bet size down a little (in accordance with those higher odds.)



-jp

.




~Edited by: jeff  on:  4/2/2013  at:  1:13:13 PM~

Reply
Reply

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