JCapper Message Board

JCapper 101
-- HOW TO FORM A QUERY USING HDW RUNNING STYLES

Home	Register Log In

HOW TO FORM A QUERY USING HDW RUNNING STYLES

beissner
4/18/2011
11:45:45 AM

Jeff I've attempted to write an "RS" query. So far no go. example runstyle = 0 or any other coded number....results "zero" out. Please help. Regards Fred

jeff
4/19/2011
2:09:57 PM

First, playlist file mode:

Create a UDM and select Running Style (Valid) from the factors drop down on the Modify Screen. Check the test Box and key in the letters representing the code(s) (E-EP-P-S-NA) of the run style(s) you want to flag. If you want to flag more than one srun style, separate your run style codes with a dash character.

Screenshot here:
http://www.jcapper.com/messageboard/avatars/rsudmplaylist.jpg

In the above linked to screenshot, I created a UDM that flags EP and P run styles. Note that the procedure is the same for both Brisnet and HDW data.

After creating the UDM (it doesn't have to be active) run the UDM through the Data Window using the UDM button.

Data Window results for the UDM from a recently build database folder (HDW) are shown below:


UDM Definition:   RS_Test
Divisor:          # UDM Def  Divisor: 999
Surface Req:      *ANY Surface*
Distance Req:     *ANY Distance*
`
Running Style:    EP-P
`
query start:         4/19/2011 10:00:40 AM
query end:           4/19/2011 10:00:59 AM
elapsed time:        19 seconds
`
`
Data Window Settings:
Divisor = 999      Odds Cap: None
Filters Applied: 
`
Surface: (ALL*)  Distance: (All*) (From Index File: C:\2011\Q2_2011\pL_profile.txt)

`
Data Summary         Win     Place      Show
Mutuel Totals    8256.60   8366.90   8124.90
Bet            -10686.00 -10686.00 -10686.00
Gain            -2429.40  -2319.10  -2561.10
`
Wins                 717      1411      2049
Plays               5343      5343      5343
PCT                .1342     .2641     .3835
`
ROI               0.7727    0.7830    0.7603
Avg Mut            11.52      5.93      3.97
`
`
By: Running Style
`
Running Style       Gain       Bet       Roi   Wins  Plays     Pct     Impact
            0       0.00      0.00    0.0000      0      0   .0000     0.0000  Missing
            1       0.00      0.00    0.0000      0      0   .0000     0.0000  E
            2    -914.40   2284.00    0.5996    139   1142   .1217     0.9070  EP
            3   -1515.00   8402.00    0.8197    578   4201   .1376     1.0253  P
            4       0.00      0.00    0.0000      0      0   .0000     0.0000  S
            5       0.00      0.00    0.0000      0      0   .0000     0.0000  NA

jeff
4/19/2011
2:26:15 PM

Next, Sql Mode using HDW Data:

In Sql Mode there is a min and max numeric integer value associated with each run style.

If you run a Data Window query with the results broken out by Run Style - you will see the min integer value associated with each run style displayed to the left of the breakout line for that run style.

In Sql Mode, for HDW data, use these integer codes in your sql expressions to "grab" desired run styles.

The Data Window query that would flag the same EP and P horses found in the above playlist file mode post is as follows:


query start:         4/19/2011 11:16:52 AM
query end:           4/19/2011 11:17:03 AM
elapsed time:        11 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor  Odds Cap: None
`
SQL:  SELECT * FROM STARTERHISTORY
      WHERE [YEAR]=2011 
      AND [MONTH]=4 
      AND RUNSTYLE >= 15
      AND RUNSTYLE < 60
`
`
Data Summary         Win     Place      Show
Mutuel Totals    8256.60   8366.90   8124.90
Bet            -10686.00 -10686.00 -10686.00
Gain            -2429.40  -2319.10  -2561.10
`
Wins                 717      1411      2049
Plays               5343      5343      5343
PCT                .1342     .2641     .3835
`
ROI               0.7727    0.7830    0.7603
Avg Mut            11.52      5.93      3.97
`
`
By: Running Style
`
Running Style HDW       Gain       Bet       Roi   Wins  Plays     Pct     Impact
                0       0.00      0.00    0.0000      0      0   .0000     0.0000  E
               15    -914.40   2284.00    0.5996    139   1142   .1217     0.9070  EP
               30    -704.80   2456.00    0.7130    157   1228   .1279     0.9527  P
               45    -810.20   5946.00    0.8637    421   2973   .1416     1.0552  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

Note: 15 is the min value for EP run style. 60 is the min val for S run style.

Note: In the above Data Window query, I added month and year constaints to capture the same set of starters found in the playlist file query example. My starterhistory table spans multiple folders and contains data for the past year or so. In the playlist file example I simply pointed the Data Window at the current target folder.

-jp

.

beissner
4/19/2011
5:25:58 PM

Jeff thank you for the detailed fix.....Regards Fred

JCapper Message Board

JCapper 101 -- HOW TO FORM A QUERY USING HDW RUNNING STYLES

JCapper 101
-- HOW TO FORM A QUERY USING HDW RUNNING STYLES