Advice

Ratings Pro Spreadsheet

(Last Updated On: June 22, 2015)

Today you are getting access to a new spreadsheet that I have just made. A reader, The Wiz, requested this and you can download the spreadsheet here.

This rating system was not devised by myself, but I have made the spreadsheet based on The Wiz’s rules for anyone who wishes to use it.

With the introduction finished, let’s get to how we go about using the spreadsheet. When you open the file you will get a screen that looks like the image below.

Ratings Pro Spreadsheet 1

As you can see there are a number of headings. These are Date/Time, Course, Horse Name, LTO Finish Position, 2nd to LTO Finish Position, Market Position, Tipped, CD Winner, Top 3, DSLR, Jockey, Trainer and Rating.

The Date/Time, Course and Horse Name are pretty self-explanatory. Next is the LTO Finish Position. You only need to use this field when the horse has finished in the top 4 in its last race. If this is the case then put the finish position in this field otherwise leave it blank.

We then come to the 2nd to LTO Finish Position, which is the horse’s finish position in the second to last race. Again you only need to enter the finish position if the horse has finished in the top 4, otherwise you can leave it blank.

Market Position is where the runner is in the live betting markets. Once again you only need to fill in this field if the runner is in the top 4 in the market. Put a 1 if the horse is favourite, 2 if second favourite etc… you can leave it blank for any runner that is not in the top 4 in the betting.

Tipped is not what it first looks like. This field is where you put in whether the horse is Strongly Fancied or a Beaten Favourite. If the horse is a beaten favourite then put in BF and if it is strongly fancied put in SF otherwise leave the field blank. You can find this information out form the Racing Post. The horse will have a BF after its name if it is a beaten favourite, I would suggest using the Selections Box in the Racing Post and if more than 50% of the tipsters select the runner then that would qualify it as an SF. Of course you may find runners that are both and on these occasions you would put SFBF or BFSF into this field.

CD Winner I am sure you already know! This is where the course and distance winner information goes in. If the horse is a course winner then enter a C and if it is a distance winner then enter a D.

News Tipsters information can also be found on the Racing Post website. Once again look in the Selections Box and if the horse has been tipped by a newspaper tipster then enter a Y into this field, otherwise leave it blank.

Top 3 you will find on the Racing Post forecast. If the horse is in the top 3 forecast winners or the top 3 TS rated then enter a Y into this field, otherwise leave it blank.

DSLR should contain the number of days that it has been since the horse last raced.

Finally we have the Jockey and Trainer fields. In these two fields we enter a Y if they are a top course jockey or trainer, otherwise it is left blank. You can find this information on the Racing Post but I find it easier on the Sporting Life website where each race card contains a clear link to Top Jockeys and Top Trainers.

Once you have entered this information for all the runners then you will get a final rating for each runner in the race under Rating. The screenshot below shows what a completed race card will look like.

Ratings Pro Spreadsheet 2

As you can see Addwaitya and Beaubrav by are the highest rated. To download the spreadsheet please click here.

Michael Wilding

Michael started the Race Advisor in 2009 to help bettors become long-term profitable. After writing hundreds of articles I started to build software that contained my personal ratings. The Race Advisor has more factors for UK horse racing than any other site, and we pride ourselves on creating tools and strategies that are unique, and allow you to make a long-term profit without the need for tipsters. You can also check out my personal blog or my personal Instagram account.

12 Comments

  1. Thanks for the link Michael I will run 2 spreadsheets one for handicaps only, the other for non-handicap races excluding maidens and nhf races, I`ll let you know how it all go`s.

    Cheers

    Arthur

  2. Hi,
    Yesterday I bought (59,99 GBP) through Paypal the right to watch your Race Rating pro videos, but still have not received any info on how to watch them.
    In spite of a claim yesterday evening to Betfan, I am still without an answer.
    Can you please fix that problem ?
    Thank you,

  3. Hi Michael
    I downloaded the spreadsheet and started entering data. It looks really good, apart from one thing… in the “2nd to LTO Finish Position” column, if you enter 1 it adds zero points to the rating, whereas entering 2 increases rating by 20. I wouldn’t think this is correct (no points for 2nd LTO win) and I don’t have the ability/knowledge to be able to change the spreadsheet
    Can you help?
    Thanks
    Tony

  4. Still the same Michael
    I’m downloading it from where it says “click here” in the article, can’t get it from where it says “downloads area” just get 404 not found when I click thatl

  5. HINEW TO RACING AND YOUR SITE, HOW DO I DETERMINE TOP JOCKEY AND TOP TRAINER AS I CANT FIND ANY INFO, IS IT JUST 1 PER RACE OR IS IT MULTIPLE BASED ON PERCENTAGES ? ANY INFO GREATLY APPRECIATED THANKS

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top button
Close