JCapper Message Board

JCapper 101
-- ?

Home	Register Log In

bill2010
6/15/2011
4:34:33 PM

would like to know---how can i get form-last 3 races into excel..to see improving r declining...thanks bill---only form...

ryesteve
6/16/2011
9:31:34 AM

What exactly do you mean by "form last 3 races"? The form ratings in JCapper are composite ratings that don't relate to any single race in particular.

bill2010
6/16/2011
3:16:59 PM

thanks...

jeff
6/16/2011
6:05:00 PM

Let's say for the sake of argument a horse has exactly 3 lifetime starts. Let's further say that the horse's form ratings as displayed on the html report on race day for each of the horse's last 3 starts were as follows:


Most recent start: 89
2nd start back:    78
3rd start back:    74

That info can sometimes have value. If you look closely at the above, you might spot a trend: improving form.

As Steve pointed out - Form in JCapper isn't form relative to a fixed benchmark. Form in JCapper is based on how the horses stack up against each other within a single race.

That said, if you study form closely you will spot another trend: horses with true improving form tend have their improving form captured by JCapper's form ratings (Form, AFR, FormConsensus, etc.) for today's race.

Just as an FYI, I once took the approach of writing algorithms that used a lookup table as a source for pertinent info so that a horse's prior races could be rehandicapped en route to generating numbers for today's race.

I was able to learn a few things from the experience and work them into JCapper. (Consensus numbers for early, late, form, class, and figs come to mind. Sql mode and the starterhistory table also comes to mind.)

That said, if by "form-last 3 races" you simply mean the form ratings from the horse's 3 most recent running lines as I described it above...

If that's what you want, the starterhistory table contains the numbers. So it's certainly doable.

Hint: If I were doing it in Excel I might use VBA code to query the starterhistory table using track, date, race, horse, and slot number for form rating (or whatever factor I wanted to get) for each running line that I wanted to work with.

Again, it's certainly doable... outside of JCapper.

-jp

.

~Edited by: jeff on: 6/16/2011 at: 6:05:00 PM~

JCapper Message Board

JCapper 101 -- ?

JCapper 101
-- ?