JCapper Message Board

JCapper 101
-- Data Window - Exacta Matrix

Home	Register Log In

Data Window - Exacta Matrix

SILVER01HDW
5/23/2013
10:49:31 AM

Hi,

I'm a little confused of the results for the factors 'Exacta Matrix by Odds Rank/UPR Rank'. If I run a SQL expression in the Data Window for HOL and RANKF14=1, what exactly are the results for UPR1/UPRn or FAV1/FAVn?

Is it the F14 ranking or the UPR/FAV rankinsg? It's not clear to me how the F14 ranking correlates to the UPR or FAV ranking.

Thanks.

Bob in Az

jeff
2/21/2014
11:20:41 AM

F14 in the Silver program default SQL Factor Setup is HDW's Distance Pedigree Rating.

If I understand correctly, you are running a sql expression like the following through the Data Window with the results broken out by Exacta Matrix by Odds Rank:

SELECT * FROM STARTERHISTORY WHERE RANKF14 = 1

Running that for the month of May 2013 here's what I have:


query start:         5/24/2013 11:57:43 AM
query end:           5/24/2013 11:57:48 AM
elapsed time:        5 seconds
`
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor  Odds Cap: None
`
SQL:  SELECT * FROM STARTERHISTORY
      WHERE RANKF14 = 1 
`
      AND [DATE] >= #05-01-2013# 
      AND [DATE] <= #05-31-2013#
`
`
`
Data Summary          Win         Place          Show
-----------------------------------------------------
Mutuel Totals     5390.20       5707.60       5405.20
Bet              -6646.00      -6646.00      -6646.00
-----------------------------------------------------
P/L              -1255.80       -938.40      -1240.80
`
Wins                  591          1175          1583
Plays                3323          3323          3323
PCT                 .1779         .3536         .4764
`
ROI                0.8110        0.8588        0.8133
Avg Mut              9.12          4.86          3.41

Note that the above results set is restricted to rank=1 for factor F14 (or the top ranked HDW Dist Pedigree horse only.)

Next, let's look at the breakout data.... In this case, we have opted to break the above results set out in the form of Exacta matrices.

The first exacta matrix looks like this:



Exacta Matrix Odds Rank = 1
`
Description       Hits    Plays     Pct     Mutuel         Bet        Gain     Roi
----------------------------------------------------------------------------------
FAV1/FAV2       000094   000662  0.1420  001160.60  -001324.00  -000163.40  0.8766
FAV1/FAV3       000051   000661  0.0772  000958.60  -001322.00  -000363.40  0.7251
FAV1/FAV4       000037   000657  0.0563  000856.20  -001314.00  -000457.80  0.6516
FAV1/FAV5       000023   000634  0.0363  000749.50  -001268.00  -000518.50  0.5911
FAV1/FAV6       000017   000581  0.0293  000751.20  -001162.00  -000410.80  0.6465
FAV1/FAV7       000011   000428  0.0257  000758.10  -000856.00  -000097.90  0.8856
FAV1/FAV8       000004   000280  0.0143  000263.20  -000560.00  -000296.80  0.4700
----------------------------------------------------------------------------------
FAV1/X          000237   003903  0.0607  005497.40  -007806.00  -002308.60  0.7043

Looking at the label for that matrix we have: "Exacta Matrix Odds Rank = 1"

Q. What does that mean?

A. It means the results set found in this matrix is designed to report the following starters when played in straight exactas:

1. Starters restricted to the factor constraints spelled out in the original query (in this case RANKF14=1.)

2. Starters that are also RANK=1 in the odds (in this case post time favorites.)

The first row of the matrix is labeled as "FAV1/FAV2."

The data in the first row of the matrix shows the results set for starters that are both RANKF14=1 and RANKODDS=1 singled in the exacta pool on top of starters that are RANKODDS=2 only.

The 2nd row of the matrix is labeled as "FAV1/FAV3."

The data in this row of the matrix shows the results set for starters that are both RANKF14=1 and RANKODDS=1 singled in the exacta pool on top of starters that are RANKODDS=3 only.

The 3rd row of the matrix is labeled as "FAV1/FAV4."

The data in this row of the matrix shows the results set for starters that are both RANKF14=1 and RANKODDS=1 singled in the exacta pool on top of starters that are RANKODDS=4 only.

Each successive row in the matrix follows the same info model.

I'm hoping I managed to type most of that out in a way that makes sense.

Let me know if that is not the case.

-jp

.

~Edited by: jeff� on: �5/24/2013� at: �2:25:07 PM~

~Edited by: jeff on: 2/21/2014 at: 11:20:41 AM~

SILVER01HDW
5/25/2013
8:09:36 AM

Hi Jeff,

Very good explanation, it makes perfect sense now.

Thanks

Bob

Charli125
5/26/2013
1:16:59 PM

I've never looked at this before. Very helpful. I'm in a contest in a few months where I need to play exotics and I don't normally play them, so this will be a huge help.

JCapper Message Board

JCapper 101 -- Data Window - Exacta Matrix

JCapper 101
-- Data Window - Exacta Matrix