Horse racing strategies   Excel Trading Spreadsheets     

                             

Analyse past results using an Excel spreadsheet.
Invent your own betting system, or look to improve existing results.

Analyse past results as often as you like, very quickly, and very easily.
Develop a betting system, or look to improve an existing method, by analysing past results.
  • Input up to 1,000 lines of your data.
  • Analyse each separate part of your data.
  • Detailed information is provided at every stage, including % winning strike rate, Profit or Loss to a £1 level stake, etc.
  • Graphical displays show profit and loss throughout each stage.
  • The spreadsheet pulls together everything that you have analysed and
    provides a list of rules, created from each separate part of your analysis.

Analyse your own stuff to create a new betting method or system, OR
analyse some other data that you come across, such as the results of some tips, ratings, etc.
You might like to analyse those bits of information and look to improve things a little.
If you are already following a system, why not update the spreadsheet as your bets progress and look to improve on the results, by analysing your recent bets ?

Once your data is in the spreadsheet, you can manipulate it as much as you like, very quickly, and easily.

Follow this link down the web page to
a video demonstration of this Excel spreadsheet file.

3 separate files are now provided with this package.
1.  Analyse 4 number inputs and 4 text inputs of data
2.  Analyse 6 number inputs and 2 text inputs of data.
3.  Analyse 8 number inputs of data . . . . . put together specifically for analysing greyhound race data.

Feedback :-
"Hi Howard, I bought your analyse data spreadsheet recently.
Great product for the price.
I don’t bet on horses but love creating systems and ratings.
This spreadsheet has speeded things up for me.
Your spreadsheet is a  good product"
. . . . .   from S.C.
 
In the screenshots below, the results shown are only for demonstration purposes, so are not based on any past races.
The screenshot below shows horse racing information from some Place market results in the Data Input spreadsheet, but data can be input for football, cricket, tennis,  . . . . . anything.
Input the name of your selections in column A, the Odds, the Results (One for hitting a winner and Zero for a loser).
With those bits of basic information, you are already able to start your analysis, BUT there are 4 columns available for data that requires a number, and 4 columns for anything that involves text.
If you are analysing horse races, there are 2 more columns for inputting weight carried.
Label your columns at the top in the coloured highlighted cells, leaving blank any that are not required.

The screenshot below shows a section of the Analysis spreadsheet for analysing Odds.
The Analysis spreadsheet is connected to the data Input spreadsheet.
Input some Upper and Lower limits in the Analysis spreadsheet and the file pulls out all races between those limits.
Anything that falls between those upper and lower limits is analysed, and the results presented as shown below.

Below, I have set the spreadsheet to look at odds between 1.1 and 4.0 so that it includes all 100 results that I have input for this demonstration.
The graph shows the progress of the profit highlighted in green if we had bet on all 100 runners with a £1 level stake.
Bet all 100 runners for a profit of £16.12 after 5% commission deductions.
The lowest point of that profit & loss was £0.70.
The percentage Winning Strike Rate was 63%, with a longest losing run of 3 losers.
The graph shows the progress of those £1 stakes.

In the screenshot below, I have set the spreadsheet to look at all races with odds between 1.4 and 4.0.
We have eliminated 18 very short priced runners at odds of 1.4 or lower
That improves the Profit, and %Strike Rate, and reduces the LLR, Longest Losing Run.
If we need to investigate, our first Longest Winning Run of 6 winners happened at row 42 in our data.
There were 2 winning runs of 6 winners.

If we had bet in races with odds above 1.4 but below 4.0, we would have had a Longest Losing Run of 2, three times, with the first of those at row 25 in our data.
Armed with that information, we may look at our data and our bets and perhaps improve our results with some fine tuning of our selection process.

Analyse several parts of our data, and the spreadsheet pulls all of our separate adjustments together to provide us with a similar display to those shown above for each, plus a set of rules that we have created.
The screenshot below shows an example of a set of rules from some different fictitious data that I input and analysed.
The rules from my analysis are :-

  • Bet at Odds above 2.0 but below 8.0.
    Horses aged 4 or 5 (above 3, but below 6).
    Races of 9 to 16 runners (above 8 but below 17).
    Races of 7F to 1 1/4 miles (above 6F but below 13F).
    In the first 6 in the betting Forecast (above 0.5 but below 7).
    Handicaps or stakes races only (hc or st).
    Ran at Ascot or Sandown last time out (AS or San).
    The horse wears Blinkers in today's race (Bl).
    I have not included the Going or Weight Carried, in this analysis.

 

We can go back to any section of the analysis and change the upper and lower limits of numbers, or add or delete any items of text, for a bit of "Fine Tuning".
To eliminate anything, simply delete the number limits or text items in the Analysis spreadsheet.
I deleted text and limits for both The Going and Weight, and the spreadsheet ignored everything associated with those.
We can leave everything in the Data Input spreadsheet to retain our data for use for another analysis.
I didn't need to delete any data for The Going and Weight, so I could include those in a completely different analysis later if I like.

Problems.
This is a very big Excel file.

Every time we enter a single piece of information, lots of calculations update, which slows down our typing.
To get around that, a spare spreadsheet is included in the file.
It may be quicker to type all data into this spare spreadsheet, and then copy and paste everything all in one go to update the Data Input spreadsheet.
If you are not familiar with "Copy and Paste", a link to a demonstration video is supplied.

In the videos below, the data used is fictitious - - not taken from any genuine horse racing results or tips, etc.
For a bigger view of the videos, click on the small icon to the bottom right that looks like 4 corners.

  • Introduction and description of the spreadsheet.
  • Some detail of how the spreadsheets work together, plus an investigation into the LLR in races with over 15 runners

 

Purchase  3 separate "Analyse Data" spreadsheets for £20

You may need Excel 2007 or a later version to view these 3 spreadsheets.

 Note that these 3 spreadsheets will not work using Open Office software.

Use these 3 spreadsheet files to analyse past results or other data.

  • Input your past results or other data into the spreadsheet

  • Analyse individual parts of your data.

  • The spreadsheet shows the results of your analysis,

  • and pulls all parts of your analysis together to show all results combined.

  • The spreadsheet shows all the qualifying races from the Filters you have set, for "a set of rules" from your analysis.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.

Analyse Data spreadsheet price = £20.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

Contact me
Privacy :-  No personal information is collected on this web site.
E-mail addresses or any other information that is forwarded will not be passed to 3rd parties.

Copyright © H. Hutchinson 2019 All rights reserved
Copying text or any other kind of content from a web site is a criminal offence.

How copyright protects your creative work

 

Intellectual property

This site is a member of WebRing.
To browse visit Here.