JCapper Message Board

General Discussion
-- Shippers - BY TK_LAST

Home	Register Log In

Shippers - BY TK_LAST

jeff
4/3/2012
7:04:44 PM

Finally got around to adding a BY SHIP FROM TRACK option to the Data Window to better facilitate analyzing of shippers.

The new option actually appears in the Data Window as "BY TK_LAST."

Note: I had wanted to have the option appear in the drop down as "BY TRACKLAST" - which would have matched up perfectly with the field name (tracklast) in the starterhistory table.

However, that would have caused a conflict with the existing "BY TRACK" option. "BY TRACK" and "BY TRACKLAST" are too close to each other and parsing them out correctly insode of the Data Window would have required extra programming in too many different places.

I ended up making the new option be: "BY TK_LAST" without the quotes...

Even though it doesn't match up with the tracklast field name in the starterhistory table, this approach has the advantage of burning fewer programming hours while still accomplishing the main objective... facilitating better analysis of shipper data.

The new option works in exactly the same manner as the existing BY RIDER, BY TRAINER, BY SIRE, or BY TRACK options...

When "BY TK_LAST" is selected from the factors drop down and you run a Data Window query: Your query results are broken out by the ship from track.

The new Data Window option will be part of the next published JCapper program update. It will be available in both JCapper Silver and JCapper Platinum and it will be available in both playlist file mode and sql mode. I expect to publish sometime this week.

Below is an example query for starters from MNR over the past 45 days broken out BY TK_LAST:


query start:         4/3/2012 3:50:20 PM
query end:           4/3/2012 3:50:24 PM
elapsed time:        4 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor  Odds Cap: None
Betting Instructions: Testing Purposes Only
`
UDM: 0_1TrackDateExpression
`
SQL:  SELECT * FROM STARTERHISTORY
      WHERE DATEDIFF('D',[DATE],NOW()) <= 45 
      AND TRACK='MNR' 
      AND INTSURFACE <= 3
`
`
Data Summary         Win     Place      Show
Mutuel Totals    2550.80   2732.60   2810.00
Bet             -3470.00  -3470.00  -3470.00
Gain             -919.20   -737.40   -660.00
`
Wins                 231       452       640
Plays               1735      1735      1735
PCT                .1331     .2605     .3689
`
ROI               0.7351    0.7875    0.8098
Avg Mut            11.04      6.05      4.39
`
`
****************************************************************************************
BY TRACKLAST sorted by Win ROI                          Run Date: 4/3/2012 3:50:24 PM
****************************************************************************************
                                       WIN  WIN          WIN               PLACE   PLACE
TRACKLAST        PLAYS    WINS         PCT  IMPACT       ROI  PLACES         PCT     ROI
****************************************************************************************
ELP                 2       1       0.5     3.7554    23        1         0.5     5.8     
MPM                 8       2       0.25    1.8777    5.05      2         0.25    2.1125  
SAR                 2       1       0.5     3.7554    2.8       1         0.5     1.45    
FGX                 7       2       0.2857  2.1458    2.6571    3         0.4286  1.6     
LAD                 5       1       0.2     1.5022    1.5       2         0.4     2.2     
TPX                 171     32      0.1871  1.4053    0.7947    64        0.3743  0.8848  
GPX                 6       2       0.3333  2.5034    0.7833    2         0.3333  0.45    
MNR                 1000    125     0.125   0.9389    0.7798    246       0.246   0.8424  
PEN                 47      8       0.1702  1.2783    0.7787    16        0.3404  0.7362  
AQU                 15      4       0.2667  2.0031    0.7733    9         0.6     1.0867  
LRL                 8       2       0.25    1.8777    0.7625    3         0.375   0.5375  
CRC                 5       1       0.2     1.5022    0.62      1         0.2     0.42    
CTX                 152     22      0.1447  1.0868    0.5816    38        0.25    0.6461  
TDN                 20      2       0.1     0.7511    0.535     5         0.25    0.85    
KEE                 6       2       0.3333  2.5034    0.5333    3         0.5     1.5333  
RDX                 5       1       0.2     1.5022    0.42      1         0.2     0.46    
HAW                 17      3       0.1765  1.3257    0.4059    6         0.3529  0.6824  
GGX                 3       1       0.3333  2.5034    0.4       1         0.3333  0.3667  
PID                 17      3       0.1765  1.3257    0.3824    3         0.1765  0.2471  
TAM                 48      6       0.125   0.9389    0.3729    12        0.25    0.4563  
BEU                 118     7       0.0593  0.4454    0.3017    19        0.161   0.5483  
PHA                 11      1       0.0909  0.6827    0.2273    2         0.1818  0.3273  
OPX                 14      1       0.0714  0.5363    0.2143    3         0.2143  0.3     
WOX                 9       1       0.1111  0.8345    0.1667    2         0.2222  0.3667  
DED                 3       0       0       0         0         1         0.3333  0.7     
FEX                 4       0       0       0         0         1         0.25    0.5     
SUF                 1       0       0       0         0         0         0       0       
BEL                 6       0       0       0         0         2         0.3333  0.7     
FLX                 8       0       0       0         0         1         0.125   0.6     
CLS                 1       0       0       0         0         0         0       0       
CDX                 3       0       0       0         0         0         0       0       
MTH                 6       0       0       0         0         1         0.1667  0.4667  
HOO                 4       0       0       0         0         0         0       0       
TUP                 1       0       0       0         0         0         0       0       
IND                 1       0       0       0         0         0         0       0       
HOU                 1       0       0       0         0         1         1       1.8     
****************************************************************************************
36 TrackLast Codes from file: StarterHistory Table
****************************************************************************************

I'll make an educated guess that most shipper patterns that can be uncovered using this new option will prove to be short term in nature. (Results are probably every bit as much a function of who is shipping as the ship from track itself.)

A perfect example might be horses shipping to MNR from both BEU and CTX... These have really underperformed expectations lately.

-jp

.

bill2010
4/3/2012
7:22:57 PM

HI JEFF THAT IS SO COOL. THANKS

STUBALL
4/16/2012
7:45:51 PM

Did this feature get put in yet? I don't see it...Jeff are you in Kentucky?
Stuball

Charli125
4/18/2012
10:10:37 PM

I haven't logged in for a while and I love this. I remember asking if this was possible a few months ago, so it's awesome to see it available now.

Thanks Jeff for always keeping jcapper ahead of the curve.

jeff
4/25/2012
7:35:05 PM

BY TK_LAST option now published as part of the 4/25/2012 new program update.

-jp

.

JCapper Message Board

General Discussion -- Shippers - BY TK_LAST

General Discussion
-- Shippers - BY TK_LAST