Huguenot
30th September 2009, 04:28.49 PM
I just noticed this when running a query involving Monmouth Park. It is related to the "Learn More" screen and the FC range. Basically there are some races missing.
I don't mind giving the details of the spot play because it didn't work very well. :)
Here are the factors:
Running from May 9-Sept. 26
Mth
6f-6.5f Fast Dirt
Allow/STK and Claimers 3 yr/3 yr old and up
no 2 year-olds
PL 5
Vi 15-32
Field size 5-14
ML of 8-1 to 12-1
K 85-115
Age 3-7
Running style all but "R"
Purses BELOW and ABOVE 10K
everything else as is.
result is
Play All 00112 00006 05% 18% 29% 0.67 0.88 0.87 $25.2 $64 0.47
But under the FC Range the results only show 5 wins in 104 races. There are eight races, including one win, missing from the results. I don't know if it will line up but here it is
FC 90+ 00007 00000 00% 00% 14% 0.00 0.00 0.33 $0 0.00
FC 88-89 00001 00000 00% 100 100 0.00 2.80 1.90 $0 0.00
FC 86-87 00003 00000 00% 00% 00% 0.00 0.00 0.00 $0 0.00
FC 84-85 00012 00001 08% 25% 42% 1.03 1.26 1.37 $24.6 $25 0.75
FC 82-83 00012 00000 00% 00% 17% 0.00 0.00 0.31 $0 0.00
FC 80-81 00027 00003 11% 22% 26% 0.62 0.87 0.81 $11.2 $13 0.97
FC 76-79 00016 00000 00% 19% 38% 0.00 0.67 0.90 $0 0.00
FC <= 75 00026 00001 04% 19% 35% 0.55 1.26 1.15 $28.8 $29 0.33
I noticed this because I then ran the same query with FC 80+ and got the correct result with four wins in 62 races. I got confused because the original query above showed a. 0.67 ROI and when I limited it to FC 80+, the ROI actually went down to 0.47 even though the chart shows FC to 79 was only 1-42 for $28.80, a huge loss (0.34). Why did my ROI go down so much when I took away a huge loss like that? Then I noticed the missing races.
Any idea of what's going on here?
Addendum
I ran the Last 100 races for both categories and Voila! I isolated the missing race -- July 4, the 1st race, the winner, the 3 horse was not given an FC number for the race. No apparent reason. Not a foreign horse. It's the a blank under "FC." He paid $64 BTW
Why was this horse not given an FC figure? And why are eight races still missing?
I don't mind giving the details of the spot play because it didn't work very well. :)
Here are the factors:
Running from May 9-Sept. 26
Mth
6f-6.5f Fast Dirt
Allow/STK and Claimers 3 yr/3 yr old and up
no 2 year-olds
PL 5
Vi 15-32
Field size 5-14
ML of 8-1 to 12-1
K 85-115
Age 3-7
Running style all but "R"
Purses BELOW and ABOVE 10K
everything else as is.
result is
Play All 00112 00006 05% 18% 29% 0.67 0.88 0.87 $25.2 $64 0.47
But under the FC Range the results only show 5 wins in 104 races. There are eight races, including one win, missing from the results. I don't know if it will line up but here it is
FC 90+ 00007 00000 00% 00% 14% 0.00 0.00 0.33 $0 0.00
FC 88-89 00001 00000 00% 100 100 0.00 2.80 1.90 $0 0.00
FC 86-87 00003 00000 00% 00% 00% 0.00 0.00 0.00 $0 0.00
FC 84-85 00012 00001 08% 25% 42% 1.03 1.26 1.37 $24.6 $25 0.75
FC 82-83 00012 00000 00% 00% 17% 0.00 0.00 0.31 $0 0.00
FC 80-81 00027 00003 11% 22% 26% 0.62 0.87 0.81 $11.2 $13 0.97
FC 76-79 00016 00000 00% 19% 38% 0.00 0.67 0.90 $0 0.00
FC <= 75 00026 00001 04% 19% 35% 0.55 1.26 1.15 $28.8 $29 0.33
I noticed this because I then ran the same query with FC 80+ and got the correct result with four wins in 62 races. I got confused because the original query above showed a. 0.67 ROI and when I limited it to FC 80+, the ROI actually went down to 0.47 even though the chart shows FC to 79 was only 1-42 for $28.80, a huge loss (0.34). Why did my ROI go down so much when I took away a huge loss like that? Then I noticed the missing races.
Any idea of what's going on here?
Addendum
I ran the Last 100 races for both categories and Voila! I isolated the missing race -- July 4, the 1st race, the winner, the 3 horse was not given an FC number for the race. No apparent reason. Not a foreign horse. It's the a blank under "FC." He paid $64 BTW
Why was this horse not given an FC figure? And why are eight races still missing?