Focus Ratings is a Uk and Irish Horse Racing ratings service designed to aid you and help you narrow the field so that you can concentrate on the real contenders. Our completely computerised analysis system selects the top three rated horses from each race and sends out the ratings every day at 10:00 a.m.  Wonderful results and an excellent strike rate.  Use Focus Ratings to win more money and make more profits from British and Irish Horse Racing.  The only horse racing system you'll ever need.

The Mystery of the Missing Races

sherlock-holmesEvery now and again...

The ratings miss off a few races.

In fact, there are two races missing today.

I've spent a lot of time trying to work out why and have been faffing around with timings and trying to slow down the code but to no avail.

However, I've just taken a look at the 1:25 at Warwick (one of the missing races) and the answer is obvious.

Betfair show the race title as... EBF MARES' 'NATIONAL HUNT' NOVICES' HURDLE

My code uses quote marks to separate fields in creating the data file to be uploaded into the database table.

Thus, if a race's title has quote marks in it, it will not be loaded as the data will be confused.

I've just done a quick check on some other recent missing races and they all have quote marks in the title of the race.

The solution is easy; I just need to add another line of code to strip out the quote marks and all will be fine.

The silly thing is that the problem was so simple that it was staring me in the face all the time.

As Sherlock Holmes said in The Hound of the Baskervilles... "The world is full of obvious things which nobody by any chance ever observes."

So, another mystery resolved; I apologise for taking so long to identify the problem. I shall resolve it today and all should be well from tomorrow.

As always...

My kindest regards


Leave a Reply