JCapper Message Board

JCapper 101
-- 2nd Place Finishers

Home	Register Log In

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

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

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

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

.

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

duped..:(

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

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
     ****************************************************************************************

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.....

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~

TPW
12/6/2013
5:59:03 PM

Caveat,

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

Terry

JCapper Message Board

JCapper 101 -- 2nd Place Finishers

JCapper 101
-- 2nd Place Finishers