In the 6 months data I have run there are 7,000 occasions where this field is blank and every one is a loser. This looks very odd.
This is as I would expect. Taking a random six months we get around 65,000 horses running, so we're around 11% of the horses don't have this rating, considering it's only for horses on Slow ground that's not outside expectations.
There's not a guarantee that any of those horses must have previously won a race on slow ground, but even if some of them have, this doesn't mean we'll be able to make a speed figure for the race. To make a speed figure we have to have a standard time, to have standard times, we need to have enough races over the course, distance, race type and going to be able to make an accurate figure. As an example, when we break down these conditions, some have only had 1, 2, 3 or 4 races in our entire database (around 2 million runners). We wouldn't make a standard time for these because it would be so inaccurate as to be pointless, which means we wouldn't be able to make speed figures for the race, and these fields would be blank.
Still curious why MC has no winners among the runners that are unrated.
@andrewp sorry not following this?
There doesn't appear to be a single complete race in the sample Michael. Some other filter must have been applied. I can't believe there are 1,800 odd races and not a single one with all runners unrated.
Okay I've dug into this a bit further, it's because this going description is almost never used.
2007 - 14 times
2008 - 0 times
2009 - 7 times
2010 - 56 times
2011 - 0 times
2012 - 15 times
2013 - 1 time
2014 - 1 time
2015 - 0 times
2016 - 0 times
2017 - 0 times
2018 - 1 time
2019 - 1 time
As for why they're all, or mainly, pulled up for some reason is probably just chance or perhaps you have stumbled on a very good laying system, but with average odds of 111 I wouldn't want to use it personally 🙂
Any update on this ?
I think this may have been a memory limit issue as well. Our developers believe it has been corrected by adjusting the scripts to not cause a memory error on the server.
Querying the database for 2019 there are 349609 horses with NULL that finished the race, and 35939 that didn't.
In 2018 29433 didn't finish from 165994 that did.
I have re-run the data for the 6 months as per my initial analysis and the data is the same, nothing seems to have changed. 4,313 horses, every one didn't finish the race according to the data.
Is this for the period 1.11.17 to 30.4.18 ?