JCapper Message Board

JCapper 101
-- Jockey Change

Home	Register Log In

Jockey Change

busseb
4/3/2011
4:38:03 PM

Was listening to a SoCal radio show this morning and they were
talking about a hot angle at SAX.

Seems like a rider switch to first time PVal was paying big.

Tried to come up with a way to flag this in SQL mode, but
can't figure out how to get 'er done.

ElPaso

jeff
4/4/2011
3:09:33 AM

Not exactly the red hot angle it's said to be...


query start:         4/4/2011 12:05:28 AM
query end:           4/4/2011 12:05:29 AM
elapsed time:        1 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor  Odds Cap: None
`
SQL:  SELECT * FROM STARTERHISTORY
      WHERE TRACK='SAX' 
      AND RIDER = 'VALENZUELA PATRICK A'
      AND XTHSTARTRIDER = 1
      AND STARTSLIFETIME > 1
`
`
Data Summary         Win     Place      Show
Mutuel Totals     199.00    181.60    225.00
Bet              -220.00   -220.00   -220.00
Gain              -21.00    -38.40      5.00
`
Wins                  20        34        54
Plays                110       110       110
PCT                .1818     .3091     .4909
`
ROI               0.9045    0.8255    1.0227
Avg Mut             9.95      5.34      4.17

-jp

.

~Edited by: jeff on: 4/4/2011 at: 3:09:33 AM~

miked
4/4/2011
12:47:08 PM

Break it down by class descriptor, paints a slightly different picture.

SQL: SELECT * FROM STARTERHISTORY
WHERE TRACK='SAX'
AND RIDER = 'VALENZUELA PATRICK A'
AND XTHSTARTRIDER = 1
AND STARTSLIFETIME > 1

Data Summary Win Place Show
Mutuel Totals 222.00 201.40 237.20
Bet -224.00 -224.00 -224.00
Gain -2.00 -22.60 13.20

Wins 21 37 57
Plays 112 112 112
PCT .1875 .3304 .5089

ROI 0.9911 0.8991 1.0589
Avg Mut 10.57 5.44 4.16

By: Class Descriptor

Class Descriptor Gain Bet Roi Wins Plays Pct Impact
0 0.00 0.00 0.0000 0 0 .0000 0.0000
1 24.00 96.00 1.2500 12 48 .2500 1.3333 C (claiming)
2 -2.00 2.00 0.0000 0 1 .0000 0.0000 CO (Claiming Optional)
3 -22.00 22.00 0.0000 0 11 .0000 0.0000 AO (Allowance Optional Claiming)
4 13.40 34.00 1.3941 5 17 .2941 1.5686 M (Maiden Claiming)
5 16.00 30.00 1.5333 3 15 .2000 1.0667 S (Maiden Special Weight)
6 -8.00 8.00 0.0000 0 4 .0000 0.0000 A (Allowance)
7 -16.00 16.00 0.0000 0 8 .0000 0.0000 G (Graded Stakes)
8 -8.00 8.00 0.0000 0 4 .0000 0.0000 N (Non Graded Stakes)
9 -6.00 6.00 0.0000 0 3 .0000 0.0000 R (Starter Allowance)
10 6.60 2.00 4.3000 1 1 1.0000 5.3333 T (Overnight Handicap)
11 0.00 0.00 0.0000 0 0 .0000 0.0000 * (Other)

miked
4/4/2011
12:56:29 PM

Sorry for the bad formatting in the earlier post, but if you use only Claiming, Maiden Claiming & MSW races it paints a different picture ( keep out optional claiming races - he is 0 for 11 ).
Even better, filter out trainers with a winning percentage under 7%.

JCapper Message Board

JCapper 101 -- Jockey Change

JCapper 101
-- Jockey Change