njcurveball
17th October 2005, 11:53.12 PM
I am looking at the following query. I have about 2 1/2 months of data and I do not download most of the minor tracks.
*** PLEASE NOTE, all of my queries use a $2 ROI for break even. $2.10 = 5% profit, etc.
MY DATABASE
ML > 5 52,109 STARTERS, $1.41 roi
ML > 5 AND NKGAP > -2 (this gives me the close calls)
938 starters, $2.06 ROI!!! WOW!!!
take out the Unknowns
ML > 5 AND NKGAP > -2 AND NUNK = 0
870 starters, $2.10 ROI
ok now what?
After many queries, this worked, but can someone explain why???
RCLASS starts tot$ ROI
---------- ---------- ---------- ----------
0 53 111.4 2.10
1 230 363 1.57
2 180 338.3 1.87
3 161 275.5 1.71
4 99 321.8 3.25
5 63 155 2.46
6 33 120 3.63
7 25 109.4 4.37
8 14 39.2 2.8
9 12 0 0
So with the following query
ML > 5 AND NKGAP > -2 AND NUNK = 0 AND RCLASS > 3
246 starters, $3.03 ROI (over 50% profit!)
so again I ask, WHY does Brad Lidge even give Pujouls a pitch near the plate? OK since I cant explain that, WHY does a BAD class ranking lead to profits?
any ideas?
Jim
*** PLEASE NOTE, all of my queries use a $2 ROI for break even. $2.10 = 5% profit, etc.
MY DATABASE
ML > 5 52,109 STARTERS, $1.41 roi
ML > 5 AND NKGAP > -2 (this gives me the close calls)
938 starters, $2.06 ROI!!! WOW!!!
take out the Unknowns
ML > 5 AND NKGAP > -2 AND NUNK = 0
870 starters, $2.10 ROI
ok now what?
After many queries, this worked, but can someone explain why???
RCLASS starts tot$ ROI
---------- ---------- ---------- ----------
0 53 111.4 2.10
1 230 363 1.57
2 180 338.3 1.87
3 161 275.5 1.71
4 99 321.8 3.25
5 63 155 2.46
6 33 120 3.63
7 25 109.4 4.37
8 14 39.2 2.8
9 12 0 0
So with the following query
ML > 5 AND NKGAP > -2 AND NUNK = 0 AND RCLASS > 3
246 starters, $3.03 ROI (over 50% profit!)
so again I ask, WHY does Brad Lidge even give Pujouls a pitch near the plate? OK since I cant explain that, WHY does a BAD class ranking lead to profits?
any ideas?
Jim