JCapper Message Board

JCapper 101
-- UDM help please.. Beaten Lengths-Dynamic Filters

Home	Register Log In

UDM help please.. Beaten Lengths-Dynamic Filters

JustRalph
1/5/2009
12:20:21 AM

I am trying to create a UDM that flags horses that Won last out, (easy part, finish position) but I want to flag only horses that won by 1 length or more.
Preferably by no more than 9 lengths also......no photos or less than length victories...... believe it or not, I found a great use for this tied into another UDM.

I think that using the dynamic filters in Jcapper is harder than Chinese Arithmetic and I just can't figure out this "neg" versus "pos" stuff.......... When I try to put anything in, I either flag every damn horse that ever won, or none at all......yes I did ride the short bus for a while.......

Jeff, can you help me out? Anybody?

jeff
1/5/2009
1:17:46 AM

Ralph,

1. Using the UDM Wizard, set min amd max val for Finish Position to 1 and Save. That'll get you Finish Position.

2. Next select Filters as your factor.

From there copy the following two filter codes...

!ALL!MXN1-!ALL!NEG9

onto the Windows ClipBoard and paste into an open instance of Notepad... which will remove any hidden line feed or carriage return characters put there by your browser when it renders the msg board page. Then lift directly from Notepad and paste into the filter codes text box in the UDM Wizard.

Then hit the Save Button.

That should get you last race winners that won by more than a length but not by more than 9.

When you run your UDM through the Data Window you should see something like this:


     UDM Definition:   WonByOneOrMore
     Divisor:          # UDM Def  Divisor: 999
     Surface Req:      *ANY Surface*
     Distance Req:     *ANY Distance*
     ~
     Finish Position:  MinVal= 1  MaxVal= 1
     Running Style:    ALL
     ~
     ~
     query start:         1/4/2009 9:41:49 PM
     query end:           1/4/2009 9:42:13 PM
     elapsed time:        24 seconds
     ~
     Data Window Settings:
     Divisor = 999      Odds Cap: None
     Filters Applied: !ALL!MXN1-!ALL!NEG9-
     ~
     Surface: (ALL*)  Distance: (All*) (From Index File: C:\2008\Q4_2008\pl_PTC.txt)

     ~
     Data Summary         Win     Place      Show
     Mutuel Totals    2230.30   2515.30   2368.00
     Bet             -3146.00  -3146.00  -3146.00
     Gain             -915.70   -630.70   -778.00
     ~
     Wins                 238       466       626
     Plays               1573      1573      1573
     PCT                .1513     .2962     .3980
     ~
     ROI               0.7089    0.7995    0.7527
     Avg Mut             9.37      5.40      3.78
     ~
     ~
     By: Beaten Lengths (Last Race)
     ~
     >=Min      < Max      Gain       Bet       Roi   Wins  Plays     Pct   Impact
   -999.00     -10.00      0.00      0.00    0.0000      0      0   .0000   0.0000
    -10.00      -9.00      0.00      0.00    0.0000      0      0   .0000   0.0000
     -9.00      -8.00    -34.00     76.00    0.5526      6     38   .1579   1.0436
     -8.00      -7.00     -9.40     80.00    0.8825      7     40   .1750   1.1566
     -7.00      -6.00    -85.50    146.00    0.4144     12     73   .1644   1.0865
     -6.00      -5.00      9.00    222.00    1.0405     20    111   .1802   1.1909
     -5.00      -4.00    -63.80    286.00    0.7769     28    143   .1958   1.2941
     -4.00      -3.00    -67.10    434.00    0.8454     34    217   .1567   1.0355
     -3.00      -2.00   -261.00    634.00    0.5883     40    317   .1262   0.8340
     -2.00      -1.00   -374.50    958.00    0.6091     70    479   .1461   0.9659
     -1.00       0.00    -29.40    310.00    0.9052     21    155   .1355   0.8954
      0.00       1.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      1.00       2.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      2.00       3.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      3.00       4.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      4.00       5.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      5.00       6.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      6.00       7.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      7.00       8.00      0.00      0.00    0.0000      0      0   .0000   0.0000
      8.00  999999.00      0.00      0.00    0.0000      0      0   .0000   0.0000

Keep in mind that for horses that won their last race the winning margin is converted to a negative number. The reason for that is to show winning margin beaten lengths separately from beaten lengths of horses that didn't win their last whenever you run a Data Window query broken out by Beaten Lengths.

-jp

.

~Edited by: jeff on: 1/5/2009 at: 1:17:46 AM~

JustRalph
1/5/2009
3:32:55 AM

good stuff Jeff..........

I think I was putting it in backwards........before I gave up.

Very good stuff, exactly what I needed.

Thanks very much!!

JCapper Message Board

JCapper 101 -- UDM help please.. Beaten Lengths-Dynamic Filters

JCapper 101
-- UDM help please.. Beaten Lengths-Dynamic Filters