Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Rider Change

Home Register
Log In
By Rider Change
busseb
4/23/2014
8:07:06 PM
Tried to set up a UDM for rider change and found that if
a rider has been on a horse 2-10 races back, this UDM won't flag it:

SELECT * FROM STARTERHISTORY
WHERE XTHSTARTRIDER = 1
AND STARTSLIFETIME > 1

Is there a field name like "riderlast" that compares only the
current race rider to only the rider in the last race and not all
previous races?

ElPaso



Reply
jeff
4/24/2014
9:50:03 AM
Playlist File Mode:

If you are operating the program in Playlist File Mode the following Preset Filter Codes enable flagging of jockey and/or trainer changes in your UDMs:

BarnSwitch:
BSWITCH=1 require barn switch today
BSWITCH=0 avoid barn switch today
BSWITCH=N avoid barn switch in record
BSWITCH=Y require barn switch in record

JockSwitch:
JSWITCH=1 require jock switch today
JSWITCH=0 avoid jock switch today
JSWITCH=N avoid jock switch in record
JSWITCH=Y require jock switch in record

Q. What's a barn switch?

A. In JCapper a barn switch is tied to a change in trainer name(s). A horse is said to be making a barn switch today if the trainer listed for today's start is different than the trainer listed for the horse's previous start.

Q. What's a jock switch?

A. In JCapper a jock switch is tied to a change in rider name(s). A horse is said to be making a jock switch today if the rider listed for today's start is different than the rider listed for the horse's previous start.

These new preset filters can provide some interesting results when combined with other factors - including the XthStart for both rider and trainer filters.

Hint: Some trainers are actually pretty good when a horse they've had in the past (and lost to someone else) ends up back in their barn again.




SQL Mode:

If you are operating the program inSQL Mode (unfortunately) the closest you can get is XthStartRider and/or XthStartTrainer - which as you mentioned - is not the same thing as a rider or trainer switch.


-jp

.


Reply
busseb
4/24/2014
3:09:37 PM
Same for trainer changes?



Reply
jeff
4/26/2014
10:59:20 AM
Yup. The same.


-jp

.

Reply
Reply

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