JCapper Message Board

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

Home	Register Log In

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

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

.

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

JCapper Message Board

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

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