Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- 2nd Place Finishers

Home Register
Log In
By 2nd Place Finishers
TPW
11/30/2013
8:10:59 AM
Jeff,

I'm trying to identify Key Factors for horses that finish second. When I use a simple SQL expression such as;

SELECT * FROM STARTERHISTORY WHERE DIST = 1320
AND INTSURFACE <= 2
and posfincall = 2

When I review the report I see a number of wins, which I wouldn't expect to see.

Suggestions on how I can accomplish this feat.

Terry

Reply
chuckv
12/1/2013
3:31:32 PM
Here is a good reference to factors in starterhistory table:

http://www.jcapper.com/helpdocs/starterhistorytableschema.html

posfincall is position at finish call last start

officialfinishposition is what you want, I believe.


Chuck

Reply
STUBALL
12/2/2013
8:05:45 AM
I have thought of this before and I believe it is not possible as
the data window only looks for winners...as to the winners those
are horses that finished second and were put up to the winners
spot due to DQ..it is hard coded into the program and would
require some or maybe much work to add option for it..

Stuball


Reply
jeff
12/2/2013
3:53:38 PM
You might try breaking the data out BY FINISH POSITION as shown in this screenshot:
http://www.jcapper.com/messageboard/avatars/byfinishposition1.jpg

In the above screenshot, I'm running a UDM through the Data Window - and by breaking the data out BY FINISH POSITION - I am presented with all starters flagged by the UDM assembled in a table showing one row per official finish position.

FYI, this part of the program uses OFFICIAL finish position... so yes, the numbers presented in the table differ slightly from what they would look like if the stewards never got involved.

That said, breaking the data out this way should provide you with a very clear idea (for the starters flagged by the expression you are running through the Data Window) as to win rates for the various possible finish positions.


-jp

.

Reply
Caveat
12/3/2013
7:24:41 AM

duped..:(

~Edited by: Caveat  on:  12/3/2013  at:  7:24:41 AM~

Reply
Caveat
12/3/2013
7:23:35 AM

The opening post wanted to see a "Key Factor Report" for horses that finished 2nd...

Jeff , would this be what hes looking for?
this is from 12-1 races
Take factor AFR...were there 4 horses that ranked #1 for AFR and they finished 2nd?


code:
query start:         12/3/2013 8:18:26 AM
query end: 12/3/2013 8:18:26 AM
elapsed time: 0 seconds

Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None

SQL: SELECT * FROM STARTERHISTORY
WHERE DIST = 1320
AND INTSURFACE <= 2
AND OFFICIALFINISHPOSITION = 2
AND [DATE] = #12-01-2013#


Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 0.00 170.30 122.20
Bet -64.00 -64.00 -64.00
-----------------------------------------------------
P/L -64.00 106.30 58.20

Wins 0 32 32
Plays 32 32 32
PCT .0000 1.0000 1.0000

ROI 0.0000 2.6609 1.9094
Avg Mut 0.00 5.32 3.82


****************************************************************************************
Key Factors Rank = 1 sorted by Factor Name Run Date: 12/3/2013 8:18:26 AM
****************************************************************************************
WIN WIN WIN PLACE PLACE
FACTOR PLAYS WINS PCT IMPACT ROI PLACES PCT ROI
****************************************************************************************
AFR F01 4 0 0 0 0 4 1 2.225
AVGBRISFIG F05 4 0 0 0 0 4 1 1.525
AVGE1 F34 4 0 0 0 0 4 1 3
BASICFITNESS F02 2 0 0 0 0 2 1 2.55
BESTE2 F16 5 0 0 0 0 5 1 1.91
BETTORSTOTEPROB 12 0 0 0 0 12 1 1.6292
CFA F07 7 0 0 0 0 7 1 2.0571
CLASSCONSENSUS F27 12 0 0 0 0 12 1 1.7708
COMPOUNDAP F17 6 0 0 0 0 6 1 1.6833
COMPOUNDLATE F23 4 0 0 0 0 4 1 1.9625
COMPOUNDSP F24 7 0 0 0 0 7 1 2.1929
CONSISTENCY F33 10 0 0 0 0 10 1 1.805
CPACE F19 10 0 0 0 0 10 1 1.865
CXN F32 6 0 0 0 0 6 1 1.775
EARLYCONSENSUS F18 8 0 0 0 0 8 1 1.7937
FIGCONSENSUS F12 8 0 0 0 0 8 1 1.8062
FORM F03 3 0 0 0 0 3 1 2.1333
FORMCONSENSUS F06 4 0 0 0 0 4 1 2.125
JPR 8 0 0 0 0 8 1 1.8688
JPRCLASS F28 10 0 0 0 0 10 1 2.185
JPRMLPROB 8 0 0 0 0 8 1 1.8625
LASTRACEBRISFI F08 7 0 0 0 0 7 1 2.3357
LATECONSENSUS F22 7 0 0 0 0 7 1 3.15
LATEPACE3 F25 4 0 0 0 0 4 1 2.525
MORNINGLINE 8 0 0 0 0 8 1 1.6437
OPTIMIZATION F29 9 0 0 0 0 9 1 2.4611
PACEFIG F09 5 0 0 0 0 5 1 2.22
PACEFIT F21 5 0 0 0 0 5 1 2.52
PAL F26 5 0 0 0 0 5 1 2.86
PCLASS F13 10 0 0 0 0 10 1 2.25
PEDIGREE F14 7 0 0 0 0 7 1 2.0643
PMI F20 8 0 0 0 0 8 1 2.075
POST TIME FAVS 11 0 0 0 0 11 1 1.6136
POWERCONSENSUS F31 11 0 0 0 0 11 1 1.8955
PRIME F30 10 0 0 0 0 10 1 2.035
RACESTRENGTH F15 6 0 0 0 0 6 1 1.625
TPACE F10 6 0 0 0 0 6 1 2.25
UPR 10 0 0 0 0 10 1 2.025
UPRMLPROB 9 0 0 0 0 9 1 1.8611
USERFACTOR1 F35 32 0 0 0 0 32 1 2.6609
WEIGHTEDFIG F11 6 0 0 0 0 6 1 1.8167
WOBRILL F04 3 0 0 0 0 3 1 2.0667
****************************************************************************************
42 Factors from file: StarterHistory Table
****************************************************************************************



Reply
pdavid6
12/3/2013
10:25:12 AM
You can simple follow my selections. They seem to always finish 2nd, LOL. Problem is that I am not a place better.....

Reply
Caveat
12/3/2013
5:55:33 PM
join the club :(

and how many times had that nice horse at decent odds won the race...you'd be up for the day

~Edited by: Caveat  on:  12/3/2013  at:  5:55:33 PM~

Reply
TPW
12/6/2013
5:59:03 PM
Caveat,

Thanks. This is what I was looking for when I ran the report.

Terry

Reply
Reply

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