JCapper Message Board

JCapper 101
-- How to Limit with a Data Window Expression

Home	Register Log In

How to Limit with a Data Window Expression

endearus
6/19/2013
7:34:10 PM

How can I limit my investigation in the data window to all OTHER horses in races where my rank 1 horse has won.

eg. (where rankf32 = 1 and winpayoff >= 2) [win % = 100%]

I tried: <> (RANKF32 = 1
AND WINPAYOFF >= 2)

but i got 249 winners. I want zero winners and want to concentrate on place and show horses.

Thanks

Eric

jeff
6/19/2013
10:06:44 PM

--quote:

"How can I limit my investigation in the data window to all OTHER horses in races where my rank 1 horse has won."

--end quote

If I understand you correctly you are asking:

"Q. How do I create a sql expression to flag non UPR rank=1 starters in races where my UPR rank=1 horse WON the race?"

A. These are the fields in the Table Schema that deal with finish position and payoffs:


Field Name		Data Type	Description
---------------------   -------------   ----------------------------------------------
officialfinishposition	number integer	official finish position today’s race
finPosFav1		number integer	finish position favorite today’s race
finPosFav2		number integer	finish position 2nd favorite today’s race
finPosFav3		number integer	finish position 3rd favorite today’s race
finPosFav4		number integer	finish position 4th favorite today’s race
finPosFav5		number integer	finish position 5th favorite today’s race
finPosFav6		number integer	finish position 6th favorite today’s race
finPosFav7		number integer	finish position 7th favorite today’s race
finPosFav8		number integer	finish position 8th favorite today’s race
finPosUPR1		number integer	finish position UPR rank = 1 horse today’s race
finPosUPR2		number integer	finish position UPR rank = 2 horse today’s race
finPosUPR3		number integer	finish position UPR rank = 3 horse today’s race
finPosUPR4		number integer	finish position UPR rank = 4 horse today’s race
finPosUPR5		number integer	finish position UPR rank = 5 horse today’s race
finPosUPR6		number integer	finish position UPR rank = 6 horse today’s race
finPosUPR7		number integer	finish position UPR rank = 7 horse today’s race
finPosUPR8		number integer	finish position UPR rank = 8 horse today’s race
winpayoff		number single	win mutuel $2.00 base
placepayoff		number single	place mutuel $2.00 base
winpayoff		number single	show mutuel $2.00 base
exoticWagerType		text 3		description of exotic wager type (“EXA”)
exoticWagerPayoff	number single	exotic wager payoff $2.00 base

The following sql expression (provided I understand you correctly) should get the job done:

SELECT * FROM STARTERHISTORY WHERE NOT RANKUPR = 1
AND finPosUPR1 = 1

Note that in any large sample the above expression will return a small handlful of winners. (The occasional race where there's a dead heat for win and/or races where the non UPR rank=1 horse is part of an entry and the UPR rank=1 horse is the other half of the entry and managed to win.)

IMPORTANT: The above sql expression - and sql expressions like it that make use of results based data such as odds, finish position, mutuel payoffs, and odds based factors - are ok to use when you are doing Data Window R&D...

BUT...

I want to make sure everyone is aware that you can't use those kinds of sql expressions in UDMs (because results aren't known by the program on race day when you click the Calc Races button.)

-jp

.

JCapper Message Board

JCapper 101 -- How to Limit with a Data Window Expression

JCapper 101
-- How to Limit with a Data Window Expression