Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- xToss

Home Register
Log In
By xToss
Caveat
1/2/2013
6:18:15 PM

Hi..

Does this factor work?

I get nothing when running it against several pl files

Mike

Reply
jeff
1/3/2013
11:42:46 AM
Hey Mike,

Give the info in the following older threads a try.

Replicating Jack B's "Tossout" in playlist file mode:
http://www.jcapper.com/messageboard/TopicReader.asp?topic=354&forum=JCapper%20101


Replicating Jack B's "Tossout" in sql mode:
http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=756&forum=Private


-jp

.

~Edited by: jeff  on:  1/3/2013  at:  11:42:46 AM~

Reply
Caveat
1/6/2013
8:01:28 AM

No Go Jeff...




code:
  UDM Definition:   TOSS_THESE
Divisor: # UDM Def Divisor: 999
Surface Req: *ANY Surface*
Distance Req: *ANY Distance*

Running Style: ALL


query start: 1/6/2013 8:59:42 AM
query end: 1/6/2013 8:59:44 AM
elapsed time: 2 seconds

Data Window Settings:
Divisor = 999 Odds Cap: None
Filters Applied: TOSSOUT-

Surface: (ALL*) Distance: (All*) (From Index File: C:\2013_JAN\pL_profile.txt)


Data Summary Win Place Show
Mutuel Totals 0.00 0.00 0.00
Bet 0.00 0.00 0.00
Gain 0.00 0.00 0.00

Wins 0 0 0
Plays 0 0 0
PCT .0000 .0000 .0000

ROI 0.0000 0.0000 0.0000
Avg Mut 0.00 0.00 0.00



Reply
jeff
1/6/2013
12:26:09 PM
I don't think you're following what I was trying to say.

Long story short: Because you are not JRating enabled the TOSSOUT filter code won't work for you because it uses JRating as one its factor inputs.

Instead of using the filter code itself - try using factor constraints - just as if you were using them in a standard UDM.




In the thread at the following link: Replicating Jack B's "Tossout" in playlist file mode, in the 6th post down from the top of the page, I posted the following:

--Quote:
"

Ever watch a Simpsons episode and crack up when Homer Simpson does something really stupid and then says "DOH!"

One of the factor constraints in the TOSSOUT definition is that rank for JRating must be >= 5

If you aren't JRating enabled then your copy of the program isn't able to make the JRating rank evaluation for Jack B's TOSSOUT - and the result is zero plays found.

DOH!


"

--End Quote.






Also, in that same post (the 6th one down from the top) I posted a suggested set of factor constraints for non JRating enabled JCapper users that will produce results almost identical to those produced by the "TOSSOUT" preset filter code.

--Quote:
"

JPR min rank = 5
Late Pace (best 3) min rank = 4
Prime Power min rank = 6
Bris Speed Figure (best 10) min rank = 5
Lifetime Starts min val = 1
Preset Filter: FORX avoid Foreign Horse


"

--End Quote.






Then, in the very next post, I posted Data Window results driven by a UDM that I created using a similar set of factor constraints:

--Quote:
"

Was playing around this morning with negative factor combinations. Came up with something fairly simple and straightforward. It uses factors from JCapper 2007 and later and finds a lot more weak horses than the original Tossout preset filter.


UDM Definition: MiToss
Divisor: # UDM Def Divisor: 999
Surface Req: *ANY Surface*
Distance Req: *ANY Distance*
~
Bris Fig (best10) MinRank= 5 MaxRank= 999
MinVal= -999 MaxVal= 999
MinGap= -999 MaxGap= 999
JPR: MinRank= 5 MaxRank= 999
MinVal= -999 MaxVal= 54.99
MinGap= -999 MaxGap= 999
Late Pace (last3) MinRank= 4 MaxRank= 999
MinVal= -999 MaxVal= 999
MinGap= -999 MaxGap= 999
Lifetime Starts: MinVal= 1 MaxVal= 999
PRating: MinRank= 4 MaxRank= 999
MinVal= -999 MaxVal= 999
MinGap= -999 MaxGap= 999
Running Style: ALL
~
~
query start: 3/24/2009 10:00:14 AM
query end: 3/24/2009 10:01:34 AM
elapsed time: 80 seconds
~
Data Window Settings:
Divisor = 999 Odds Cap: None
Filters Applied: FORX-
~
Surface: (ALL*) Distance: (All*)
From Index File: C:\2009\Q1_2009\pL_profile.txt

~
Data Summary Win Place Show
Mutuel Totals 10342.50 11508.40 11605.20
Bet -21078.00 -21078.00 -21078.00
Gain -10735.50 -9569.60 -9472.80
~
Wins 329 853 1533
Plays 10539 10539 10539
PCT .0312 .0809 .1455
~
ROI 0.4907 0.5460 0.5506
Avg Mut 31.44 13.49 7.57



"

--End Quote.






Don't use the filter code. Try using factor constraints instead.


-jp

.







~Edited by: jeff  on:  1/6/2013  at:  12:26:09 PM~

Reply
Caveat
1/6/2013
12:54:06 PM


got it

Reply
jeff
1/6/2013
1:19:37 PM
The above posted results are based on older Brisnet data.

I spent a few minutes this morning and created a UDM designed to toss horses from contention using HDW data.

The UDM definition is pretty simple:

JPR min rank: 5
PRating min rank: 4
FigConsensus min rank: 5
ClassConsensus min rank: 5
Lifetime Starts min val: 1
Foreign Horse: No


Running the UDM through the Data Window in sql mode, here is what I get for all starters at all N American tracks for calendar years 2011 and 2012:


query start: 1/6/2013 11:11:09 AM
query end: 1/6/2013 11:12:33 AM
elapsed time: 84 seconds

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

SQL: SELECT * FROM STARTERHISTORY
WHERE RANKJPR >= 5
AND RANKPRATING >= 4
AND RANKF13 >= 5
AND RANKF27 >= 5
AND STARTSLIFETIME >= 1
AND FOREIGN = 0


Data Summary Win Place Show
Mutuel Totals 256797.50 263502.00 258895.50
Bet -432784.00 -432784.00 -432784.00
Gain -175986.50 -169282.00 -173888.50

Wins 8230 20904 38449
Plays 216392 216392 216392
PCT .0380 .0966 .1777

ROI 0.5934 0.6089 0.5982
Avg Mut 31.20 12.61 6.73


By: Calendar Year

Rank Gain Bet Roi Wins Plays Pct Impact
2000 0.00 0.00 0.0000 0 0 .0000 0.0000
2001 0.00 0.00 0.0000 0 0 .0000 0.0000
2002 0.00 0.00 0.0000 0 0 .0000 0.0000
2003 0.00 0.00 0.0000 0 0 .0000 0.0000
2004 0.00 0.00 0.0000 0 0 .0000 0.0000
2005 0.00 0.00 0.0000 0 0 .0000 0.0000
2006 0.00 0.00 0.0000 0 0 .0000 0.0000
2007 0.00 0.00 0.0000 0 0 .0000 0.0000
2008 0.00 0.00 0.0000 0 0 .0000 0.0000
2009 0.00 0.00 0.0000 0 0 .0000 0.0000
2010 0.00 0.00 0.0000 0 0 .0000 0.0000
2011 -93574.30 222764.00 0.5799 4180 111382 .0375 0.9867
2012 -82412.20 210020.00 0.6076 4050 105010 .0386 1.0141
2013 0.00 0.00 0.0000 0 0 .0000 0.0000
2014 0.00 0.00 0.0000 0 0 .0000 0.0000
2015 0.00 0.00 0.0000 0 0 .0000 0.0000
2016 0.00 0.00 0.0000 0 0 .0000 0.0000
2017 0.00 0.00 0.0000 0 0 .0000 0.0000
2018 0.00 0.00 0.0000 0 0 .0000 0.0000



-jp

.

Reply
Reply

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