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.
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.