Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Running style

Home Register
Log In
By Running style
chrisl
5/14/2016
2:44:28 PM
How would this be spelled in a SQL UDM. Rstyle, Runningstyle is not being accepted. Thanks

Reply
jeff
5/14/2016
8:39:24 PM
Here's a link to an older thread:
http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=833&forum=JCapper%20101


--quote:
"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
"
--end quote



Basically the numbers on the left hand side of the Data Window breakout rows for each runstyle represent min and max boundaries for HDW runstyle - while the letters on the far right of each row are the labels we intuitively use when we refer to runstyle.

To reference individual HDW runstyles in a sql expression use the following table:

E runstyle only:

AND RUNSTYLE < 15



EP runstyle only:

AND RUNSTYLE >= 15 AND RUNSTYLE < 30



P runstyle only:

AND RUNSTYLE >= 30 AND RUNSTYLE < 45



PS runstyle only:

AND RUNSTYLE >= 45 AND RUNSTYLE < 60


S runstyle only:

AND RUNSTYLE >= 60 AND RUNSTYLE < 75



SS runstyle only:

AND RUNSTYLE >= 75 AND RUNSTYLE < 90



U runstyle only:

AND RUNSTYLE >= 90





-jp

.


Reply
Reply

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