Database Handicapping Software- JCapper

JCapper Message Board

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

Home Register
Log In
By 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

Reply
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


Reply
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

.



Reply
beissner
4/19/2011
5:25:58 PM
Jeff thank you for the detailed fix.....Regards Fred

Reply
Reply

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