Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- MLOR4

Home Register
Log In
By MLOR4
bettheoverlay
2/13/2010
9:04:48 AM		The glossary definition states the ratio between post time odds and JPRMLProb. If you are using your UPR as your MLProb will this factor compare UPRMLProb to post time odds or is it always JPRMLProb?

Reply
jeff
2/14/2010
1:13:22 PM		Here are the MLOR's...

MLOR or MLOR1
MLOR1 is a ratio equal to Actual Odds divided by Morning Line Odds.



MLOR2
First, an odds line is calculated using the following formula:

OL = (1 / AProb) - 1

MLOR2 is a ratio equal to Morning Line Odds divided by the above OL.




MLOR3
First, an odds line is calculated using the following formula:

OL = (1 / JPRMLProb) - 1

MLOR3 is a ratio equal to Morning Line Odds divided by the above OL.



OR3
First, an odds line is calculated using the following formula:

OL = (1 / JPRToteProb) - 1

OR3 is a ratio equal to Actual Odds divided by the above OL.



MLOR4
First, an odds line is calculated using the following formula:

OL = (1 / JPRMLProb) - 1

MLOR4 is a ratio equal to Actual Odds divided by the above OL.

When User OL is the persisted setting on the User Sys Defs Screen, JCapper will use UPR instead of JPR during Calc Races routines. In the Live Play Module, the E~, OR3, OL, and Prob numbers in the JTote Columns will be based on UPR and not JPR.

When Default OL is the persisted setting on the User Sys Defs Screen, JCapper will use JPR instead of UPR during Calc Races routines. In the Live Play Module, the E~, OR3, OL, and Prob numbers in the JTote Columns will be based on JPR and not UPR.

Both sets of numbers... JPR with MLOR3 and MLOR4... as well as UPR with MLOR4 and MLOR5... are sent to the playlist file during build database routines to be made visible during Data Window queries... Meaning that a Data Window query broken out by MLOR4 will always show numbers that are JPR based (and not UPR based) no matter what OL is persisted on the User Sys Defs Screen.



MLOR5
First, an odds line is calculated using the following formula:

OL = (1 / UPRMLProb) - 1

MLOR5 is a ratio equal to Morning Line Odds divided by the above OL.

Here's are the parts where most get confused:
MLOR5 is Data Window only. You can not use it in UDMs. If you want to use MLOR5 for decision making during live play, I recommend using the BettingInstructions field for those UDMs where you want to use MLOR5. Example: you have a UDM where your R&D in the Data Window indicates you want a minval for MLOR5 of 1.60... keying something like MLOR5 1.60 would probably do the trick.

When User OL is the persisted setting on the User Sys Defs Screen, JCapper will use UPR instead of JPR during Calc Races routines. The Prob and resulting OL that you see on your HTML Report will be based on UPR and not JPR. In playlist file mode, Overlay Highlighting will be based on MLOR5 = (ML/UPRMLProb) and not MLOR3 = (ML/JPRMLProb)

In the Live Play Module When User OL is the persisted setting on the User Sys Defs Screen, the values shown in the MLOR3 column will be will be based on MLOR5 = (ML/UPRMLProb) and not MLOR3 = (ML/JPRMLProb)

When Default OL is the persisted setting on the User Sys Defs Screen, the numbers on the HTML Report and in the Live Play Module are based on MLOR3 = (ML/JPRMLProb) and not MLOR5 = (ML/UPRMLProb)



Whew... hope I managed to explain that in a way that makes sense.


-jp

.


~Edited by: jeff  on:  2/14/2010  at:  1:13:22 PM~

Reply
jeff
7/5/2010
11:51:26 AM
--quote:
"Jeff,

Is there a way in JCapper I can create a UDM which will point out my UPR odds overlays as they relate to the morning line?

I know I can do this with MLOR2 or MLOR3 if I was using AProb oddsline or JPR oddsline but I would like to do this with my UPR (User defined) oddsline.

Hope my question is clear. Thanks."
--end quote



The factor you want is called MLOR5 (see the above post.)

This factor has been data window only (and playlist file mode only at that.)

In the next published program version it will be added to the sql mode enabled Data Window.

After giving it a little thought, there actually IS a way to write a sql expression to enable "grabbing" MLOR5 in a sql UDM.

Here's an example:

query start:         7/5/2010 8:42:43 AM
query end:           7/5/2010 8:42:47 AM
elapsed time:        4 seconds
`
Data Window Settings:
999 Divisor  Odds Cap: None
`
SQL:  SELECT * FROM STARTERHISTORY
      WHERE UPRMLPROB > 0 
      AND MLINE / ((1/ UPRMLPROB) -1) >= 2.2
`
`
Data Summary         Win     Place      Show
Mutuel Totals    5913.80   5246.60   5105.40
Bet             -5966.00  -5966.00  -5966.00
Gain              -52.20   -719.40   -860.60
`
Wins                 385       719      1066
Plays               2983      2983      2983
PCT                .1291     .2410     .3574
`
ROI               0.9913    0.8794    0.8557
Avg Mut            15.36      7.30      4.79
`
`
By: MLOR5 (data window only)
`
  >=Min      < Max      Gain       Bet       Roi   Wins  Plays     Pct   Impact
-999.00       0.50      0.00      0.00    0.0000      0      0   .0000   0.0000
   0.50       0.60      0.00      0.00    0.0000      0      0   .0000   0.0000
   0.60       0.70      0.00      0.00    0.0000      0      0   .0000   0.0000
   0.70       0.80      0.00      0.00    0.0000      0      0   .0000   0.0000
   0.80       0.90      0.00      0.00    0.0000      0      0   .0000   0.0000
   0.90       1.00      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.00       1.10      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.10       1.20      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.20       1.30      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.30       1.40      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.40       1.50      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.50       1.60      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.60       1.70      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.70       1.80      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.80       1.90      0.00      0.00    0.0000      0      0   .0000   0.0000
   1.90       2.00      0.00      0.00    0.0000      0      0   .0000   0.0000
   2.00       2.10      0.00      0.00    0.0000      0      0   .0000   0.0000
   2.10       2.20      0.00      0.00    0.0000      0      0   .0000   0.0000
   2.20       2.30    338.10    628.00    1.5384     41    314   .1306   1.0117
   2.30  999999.00   -390.30   5338.00    0.9269    344   2669   .1289   0.9986


There are two keys to making it work:

1. Trap for a division by zero error. This part of the expresison takes care of that:
UPRMLPROB > 0

2. Perform the mathematical equivalent of the MLOR5 computation withn the expression itself. This part of the expression accomplishes that:
((1/ UPRMLPROB) -1)


-jp

.


Reply
STUBALL
7/6/2010
8:05:44 AM		Thanks Jeff for the info on MLOR. I have been thinking about this for a while now.
This makes it much easier to understand.
I will print this up and stick it to my comp desk till it gets stuck in my head..
(takes awhile) I have been doing so good
but the last 2 (BAD)days have prompted me to set up my record keeping, so I can chart my results and find the error of my ways or is this just the dreaded 4th of July blip.

Stuball

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