Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- JockeyAbility

Home Register
Log In
By JockeyAbility
tfranks
7/9/2008
7:50:06 PM
i am trying to use the factor (JockeyAbility) in my Udm, but i can't find it, can anyone help

thanks
tom

Reply
jeff
7/9/2008
8:39:42 PM
Jockey Ability and Jockey Win Percent are one and the same thing. It's "grabbable" in UDMs using the Dynamic Filter Tool.

-jp

.

~Edited by: jeff  on:  7/9/2008  at:  8:39:42 PM~

Reply
tfranks
7/9/2008
11:01:49 PM

By: JockeyAbility


1 17 .0588 0.2169 ( A Goto rider)
in my udm i am trying to eliminate a goto rider from my udm. under dynamic filter tools all that i can find that looks anythang like jockey win % is (rider win %) and it dosen't have any filters to eliminate (a goto rider)

thanks
tom

~Edited by: tfranks  on:  7/9/2008  at:  11:01:49 PM~

Reply
Maltzaroo
7/10/2008
2:07:32 AM
Jockey Ability can't be, or shouldn't be, the same thing as Jockey Win Percent. Jockey Ability, listed in the "select a filter" drop-down, breaks data down into 5 categories: + Dirt Sprint, + Dirt Route, t turf sprint, T turf route, and A go to rider. We can't find a filter to select any of these 5 numbers or combinations of them to filter out the type of races jockeys are strongest in. Can't find such a category under static or dynamic filters. Do such filters exist?

Reply
jeff
7/10/2008
7:12:45 PM

quote:
in my udm i am trying to eliminate a goto rider from my udm. under dynamic filter tools all that i can find that looks anythang like jockey win % is (rider win %) and it dosen't have any filters to eliminate (a goto rider)



My bad guys. I see what you are getting at now.

A little history first about the rider rating symbols. I started using them in a very early version of JCapper around 1998. I discovered that certain riders excelled at gunning horses to the front from the gate and then getting them to relax while racing on the lead. Other riders (most in fact) were horrible at it. Knowing which riders were capable of that made a very nice fit with CPace ranks 1, 2, and 3. Most of my early UDMs were based on just three factors: 1. A speed favoring surface. 2. CPace rank 123. 3. A rider who knew what to do. It was (and still is) a very potent combination. In 1999 Victor Espinoza was a rider on my "list" and he rode Spain (top 3 in Cpace that day) to victory in the Breeder's Cup Distaff (on a speed favoring surface) at odds of more than 50-1.

Up until late 2003 (when I developed the JRating) I used to manually recompile the rider rating symbols at the end of each quarter. When I began developing JCapper in earnest and created the Profile Table Interface, UDM Wizard, and Profile Marker - I ended up with the ability to write UDMs that defined riders (trainers, and owners too) by name - which IMHO is a better way of doing things than using symbols.

The symbols themselves are a leftover from the way I used to do things. I originally wanted to remove them from JCapper when I started selling copies of it. A handful of my first customers asked me to leave the symbols intact on the HTML Report. So I did. But keep in mind that they haven't been updated in over 4 years. During the past 4 years the abilities of almost all of the riders have changed - significantly.

Many of the original riders on my "list" (Pat Day, Laffit Pincay, Rafael Meza, Robbie Davis) are no longer riding. Many others can no longer be considered "go to" guys for significant trainers.

I posted before on the old message board that I really had no current plans to update the symbols.

You guys should know that I am working on something that will be known as a Data Window Connections Export... which will allow you to run a Data Window export to generate reports for human connections covering many relevant categories in much the same way that you currently run a Track Profile Export and Reports. Right now I'm realistically looking at an 8-1-2008 release date for this. Without too much fanfare or hype I'll just say that most of you are really going to love this once you see it. It's all about knowing who is good and bad at what.

Ok. Back to using rider names in a UDM...

There are two fields in the Profile Table Interface:

RIDERNAMETEST

RIDERNAME

It's probably easiest to create the template for the UDM using the Wizard and then modify the UDM using the Connections View of the Profile Table Interface.

1. Bring up the UDM to be modified in the Connections View of the Profile Table Interface

2. Activate a rider name test by changing the value of the RIDERNAMETEST field from 0 to -1

3. Key a name match for each rider on your "list" into the RIDERNAME FIELD. Hint: Read about rider name matching on the Supported Factors Page of the JCapper site if you need a basic understanding of what I'm talking about. Avoid illegal characters such as the apostrophe character. If you view individual plays in the Data Window using the ALL button you can see exactly how the rider names are stored in your database. When you create a name match you want to match the name displayed in the Data Window to the name you use in your UDMs.

Example: You have two riders on your list:

NAPRAVNIK ANNA R

and

DOMINGUEZ R A

You can combine them into a rider list by separating their names with minus or dash characters like this:

NAPRAVNIK ANNA R-DOMINGUEZ R A


Some riders are so bad talent wise I have in the past called them "human anchors" in my posts. If you want to create a UDM to avoid a given rider I suggest you use the rider name test and ridername in a negative expectation UDM. And then just avoid playing horses marked by it.

Hope I explained the above in a way that makes sense.

-jp

.










~Edited by: jeff  on:  7/10/2008  at:  7:12:45 PM~

Reply
tfranks
7/11/2008
12:32:23 AM
sounds good to me
thanks
tom

Reply
TomV
1/17/2009
8:02:01 AM
Hi Jeff,

Can't seem to figure out how to update the rider symbols in the program.

Went through the Jcapper and Jcapper2 databases and didn't see a table for that. Is that somethig that can still be updated ? If so, how would one go about updating that ?


Thanks,
Tom

Reply
jeff
1/17/2009
12:32:34 PM
Tom,

Those symbols are a leftover from the earliest versions of the program and I haven't updated them in a really long time - and don't plan to.

I'm actually looking at removing them from the program.

IMHO, they've been replaced with something a lot more powerful:

Data Window Exports

Last summer I released the CXN Exports Module and its companion Report Generator.

A CXN Report gives you guys the ability to see who is good and bad at what - Riders, Trainers, Owners - in far more categories than those represented by the symbols.

Armed with a CXN Report you can generate your own rider lists for any category you want: rides the front end well, closes well, sprints, routes, turf, hot hand/recent trends, etc.

The new Data Window allows you to run an ALL button query BY TRAINER - and see the performance of each trainer in the database. From that pick a trainer that catches your eye - create a UDM for that one trainer - and then run it through the Data Window broken out BY RIDER.

That shows you who the "goto" riders are for that trainer.

The idea behind this - aside from it being a kick a$$ research tool - is that now YOU have the ability to quickly do your own R&D - instead of having to rely on me - and create UDMs based on your own ideas and R&D.

Instead of symbols - think: UDMs.

It's the approach I've been using for a while now. And IMHO it kicks a$$ over the original symbols.


-jp

.




~Edited by: jeff  on:  1/17/2009  at:  12:32:34 PM~

Reply
TomV
1/18/2009
11:11:43 AM
The CNX reports are indeeed a superb research tool.

However, I was thinking from an upkeep / maintenance point of view that updating the access DB would be easier than updating a number of UDM's , simply because of the text character limit imposed on the Rider/Trainer fields.



Reply
jeff
1/18/2009
5:26:59 PM
Except that the symbols aren't being read from a database. At present they're manually hard coded/written into the program.

To provide what you're suggesting - and understand I think it's a good suggestion - users creating their own rider/trainer/owner symbols - would require me to burn some programming hours.

I'd need to create a Symbols Table in the JCapper2.mdb file. Something like this:


CXNTYPE NAME SYMBOL
1 rider Butler Dean +-
2 trainer Chambers Mike A
3 owner Maggie Moss A


Where the user keys in his/her own names and symbols - and where the symbols keyed in each have meaning unique to each user.

And then add a function to the program that compares CXN names in the .drf or .pcs files against the names sitting in the table - and when a name match is found spit the symbols out onto the HTML and Text reports.

It's a good idea Tom.

Maybe if I get free time at some point... can't promise that right now though.


-jp

.






~Edited by: jeff  on:  1/18/2009  at:  5:26:59 PM~

Reply
jeff
1/18/2009
5:26:21 PM
Tom,

You posted:

"text character limit imposed on the Rider/Trainer fields"

The JCapper.mdb file in the downloads package of the current program version was altered some time ago so that the rider/trainer/owner name fields in the profile table are memo data type instead of plain text. That means in theory they should be able to handle an unlimited number of characters.

To use the newer file it's simply a matter of swapping out your old JCapper.mdb file with the newer (clean) version which can be found sitting on the c:\JCapperBuild folder after installing the latest program version. Make a backup of the old file just in case. Then import UDMs and transfer IVTable enties for UserFactors and UPR. UDM Import can be done in the UDM Wizard. Easiest best way to handle IVTable entries would be a cut and paste after opening the file in Access. Not everyone has a copy of Access installed so I'm willing to help with that part of things. Afterwards, just copy the new file onto the c:\2004 folder and you're set.

-jp

.





Reply
TomV
1/18/2009
11:56:08 PM
Good answer on the memo field !!!!! I should be able to move the old jcapper DB into the new one.

I wasn't thrilled with the thought of managing a great number of connection UDM's because of the text limit and didn't realize the Rider symbols were hard coded. No need to burn programing hours on that as with the unlimited text field the UDM'S will do the trick. .

Have I told U how much I like the By Track option in the data window ? It ROCKS !!!!



~Edited by: TomV  on:  1/18/2009  at:  11:56:08 PM~

Reply
Reply

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