I don't see 21 THEODDS as an option - at least not in the current version Data Window.... I seem to recall it being an option in an older program version - and one that has been replaced in the current version of the Data Window with Odds Range. Assuming that 21 THEODDS and Odds Range are one and the same, when you run a Data Window query with the data broken out by odds range, you can see win rates, impact values, and win pool roi for each of the incremental odds ranges displayed in the breakout of your query.
For example, here's a Data Window query (JCapper EarlyConsensus rank=1 horses at GPX during calendar year 2011) with the results broken out by odds range:
query start: 1/5/2012 9:08:57 AM
query end: 1/5/2012 9:08:58 AM
elapsed time: 1 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
`
SQL: SELECT * FROM STARTERHISTORY
WHERE RANKF19=1
AND TRACK='GPX'
AND INTSURFACE <= 3
`
`
Data Summary Win Place Show
Mutuel Totals 1216.30 1181.60 1118.60
Bet -1140.00 -1140.00 -1140.00
Gain 76.30 41.60 -21.40
`
Wins 132 233 308
Plays 570 570 570
PCT .2316 .4088 .5404
`
ROI 1.0669 1.0365 0.9812
Avg Mut 9.21 5.07 3.63
`
`
By: Odds Range
`
>=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 1.00 -4.50 112.00 0.9598 34 56 .6071 2.6218
1.00 2.00 -4.40 156.00 0.9718 32 78 .4103 1.7716
2.00 3.00 -0.40 166.00 0.9976 24 83 .2892 1.2486
3.00 4.00 -35.00 124.00 0.7177 10 62 .1613 0.6965
4.00 5.00 -5.00 92.00 0.9457 8 46 .1739 0.7510
5.00 6.00 -30.80 70.00 0.5600 3 35 .0857 0.3701
6.00 7.00 0.00 44.00 1.0000 3 22 .1364 0.5888
7.00 8.00 -17.60 52.00 0.6615 2 26 .0769 0.3322
8.00 9.00 -10.00 28.00 0.6429 1 14 .0714 0.3084
9.00 10.00 30.60 32.00 1.9563 3 16 .1875 0.8097
10.00 11.00 20.80 24.00 1.8667 2 12 .1667 0.7197
11.00 12.00 -12.00 12.00 0.0000 0 6 .0000 0.0000
12.00 13.00 -16.00 16.00 0.0000 0 8 .0000 0.0000
13.00 14.00 36.40 20.00 2.8200 2 10 .2000 0.8636
14.00 15.00 72.80 20.00 4.6400 3 10 .3000 1.2955
15.00 16.00 20.20 12.00 2.6833 1 6 .1667 0.7197
16.00 17.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
17.00 18.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
18.00 999999.00 39.20 152.00 1.2579 4 76 .0526 0.2273
Keep in mind that when breaking data out by odds range you are not bound by the default Data Window settings for for interval and start range; you can use the drop downs to adjust the incremental odds ranges you want to see the data broken out by to your liking.
Here is the same query rerun, this time with the interval drop down set at 5:
By: Odds Range
`
>=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 -49.30 650.00 0.9242 108 325 .3323 1.4350
5.00 10.00 -27.80 226.00 0.8770 12 113 .1062 0.4586
10.00 15.00 102.00 92.00 2.1087 7 46 .1522 0.6571
15.00 20.00 80.80 32.00 3.5250 3 16 .1875 0.8097
20.00 25.00 -16.00 16.00 0.0000 0 8 .0000 0.0000
25.00 30.00 74.60 36.00 3.0722 2 18 .1111 0.4798
30.00 35.00 -18.00 18.00 0.0000 0 9 .0000 0.0000
35.00 40.00 -16.00 16.00 0.0000 0 8 .0000 0.0000
40.00 45.00 -10.00 10.00 0.0000 0 5 .0000 0.0000
45.00 50.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
50.00 55.00 -10.00 10.00 0.0000 0 5 .0000 0.0000
55.00 60.00 -6.00 6.00 0.0000 0 3 .0000 0.0000
60.00 65.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
65.00 70.00 0.00 0.00 0.0000 0 0 .0000 0.0000
70.00 75.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
75.00 80.00 -6.00 6.00 0.0000 0 3 .0000 0.0000
80.00 85.00 -2.00 2.00 0.0000 0 1 .0000 0.0000
85.00 90.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
90.00 999999.00 -4.00 4.00 0.0000 0 2 .0000 0.0000
Not a whole lot of data to go by... but the sweet spot appears to be within the incremental odds range of about 9-1 to 30-1.
-jp
.
~Edited by: jeff on: 1/5/2012 at: 12:31:32 PM~
| 