Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- ADDITION OF RUN STYLES TO UDM'S

Home Register
Log In
By ADDITION OF RUN STYLES TO UDM'S
beissner
9/30/2010
5:19:17 PM
Jeff I am having a problem adding RUN STYLES to UDM'S in the SQL mode. I've tried all combinations of HDW equivalents without success. Regards Fred

Reply
jeff
10/1/2010
12:15:42 PM
RunStyle in sql mode is numeric. Numbers for HDW run styles can be seen in the Data Window when you run a Data Window query and break the results data out by Run Style.

For sql mode UDMs use min and max run style as seen in the Data Window.

Example - The following sql expression can be used to add an HDW run style constraint for E and EP runners to a sql mode UDM:

AND RUNSTYLE < 30

query start: 10/1/2010 9:11:08 AM
query end: 10/1/2010 9:11:25 AM
elapsed time: 17 seconds
`
Data Window Settings:
999 Divisor Odds Cap: None
`
SQL: SELECT * FROM STARTERHISTORY
WHERE RANKJPR=1
AND RUNSTYLE < 30
`
`
Data Summary Win Place Show
Mutuel Totals 8458.70 8113.50 8076.30
Bet -9196.00 -9196.00 -9196.00
Gain -737.30 -1082.50 -1119.70
`
Wins 1294 2111 2667
Plays 4598 4598 4598
PCT .2814 .4591 .5800
`
ROI 0.9198 0.8823 0.8782
Avg Mut 6.54 3.84 3.03
`
`
By: Running Style
`
Running Style HDW Gain Bet Roi Wins Plays Pct Impact
0 -365.00 6634.00 0.9450 934 3317 .2816 1.0005 E
15 -372.30 2562.00 0.8547 360 1281 .2810 0.9986 EP
30 0.00 0.00 0.0000 0 0 .0000 0.0000 P
45 0.00 0.00 0.0000 0 0 .0000 0.0000 PS
60 0.00 0.00 0.0000 0 0 .0000 0.0000 S
75 0.00 0.00 0.0000 0 0 .0000 0.0000 SS
90 0.00 0.00 0.0000 0 0 .0000 0.0000 U
105 0.00 0.00 0.0000 0 0 .0000 0.0000
120 0.00 0.00 0.0000 0 0 .0000 0.0000
135 0.00 0.00 0.0000 0 0 .0000 0.0000
150 0.00 0.00 0.0000 0 0 .0000 0.0000
165 0.00 0.00 0.0000 0 0 .0000 0.0000
180 0.00 0.00 0.0000 0 0 .0000 0.0000
195 0.00 0.00 0.0000 0 0 .0000 0.0000
210 0.00 0.00 0.0000 0 0 .0000 0.0000
225 0.00 0.00 0.0000 0 0 .0000 0.0000
240 0.00 0.00 0.0000 0 0 .0000 0.0000
255 0.00 0.00 0.0000 0 0 .0000 0.0000
270 0.00 0.00 0.0000 0 0 .0000 0.0000



-jp

.

Reply
beissner
10/1/2010
2:03:47 PM
Jeff thank you. I used the HDW numbers for RS but I had them RUNSTYLE = 0, 45 ETC. Regards Fred

Reply
Reply

Copyright 2008 JCapper Software              back to the JCapper Message Board              www.JCapper.com