System Builder 
This is the Flatstats Horse Racing System Builder. You can use this to analyse horse racing results in order to create your own betting systems for all weather horse racing.
For quick help with the system builder page please click the help icon. To view articles on how to use the system builder, and tutorials on how to create your own racing systems please visit the System Builder Support page.
How to use the Flatstats Horse Racing System Builder
Basics
This page is used for creating and researching horse racing systems. You create a system by adding filters. Once you have added the desired filters the results database is scanned a a report generated for you. If you like the results of the system you can create an alert so that any future qualifiers for the system are alerted to you.
System Builder Form
The form is used to add, edit or delete filters (system rules). You add a filter by clicking on a category button and then entering details about that filter. e.g. You could choose the Course filter button and then state that database should filter for all races at Ascot, or you could choose the SP button and then state that the database should filter for all 1st favourites.
Once you have created a filter it will appear on the form. The information displayed will be Item (the type of filter), Operator (whether the filter should match, be less than, not match etc.), Value (the value you wish to filter for). Each row of the form can be edited by clicking on the edit link, or can be deleted by clicking on the X for each row. If you want to totally clear the form and start again you can click on the Reset Form button.
Adding an SP Filter
To create a filter based on SP click the SP category button. A small box appears which allows you to choose an SP filter option, the operator, and the value.
Change the Item: to SP
Change the Operator: to >=
Change the Value: to 10
Click the Add Filter Button
The Join: option is used to join filters together. Leave this at the default AND for now.
If you set that up as shown above you will have created a filter which will only include horses priced in double figures.
You can now add more filters as you desire. Try adding another one for a trainer.
Adding a Name Filter
In this example we want to see the record for trainer Barney Curley.
Click the Name category button and then choose Trainer.
In the value box enter just a few characters of the trainers last name (it is always best to search on last name rather than Barney as the Flatstats database records him as B J Curley).
Once you have entered a few characters you will notice that a list appears with trainers with cur in their names. Choose B J Curley and press the Add Name Filter button.
You have now created a system for Trainer Barney Curley when his runners are priced at 10/1 or more. If you press one of the report buttons you will see the results for this system.
Summary Report
This is used to view quick results for your system. It shows a summary report of information such as number of wins, runs, strike rate and profit. You can also view more advanced stats such as the A/E figures, profit / loss from the Tote and from using the Betfair SP.
Full Report
The full report opens up in a new box and shows not only the summary results, but also all of the data split into various categories such as year on year, type of race, distance, going etc. This allows you to fully analyse the system to see where and when it is best at.
Full BSP Report
This the same as the Full Report but the data will all be based on the Betfair SP rather than the bookie SP. This is really useful for seeing if either the exchanges or the bookies get the price wrong, e.g. the bookies may underbet a favourite, or the exchange layers may offer over the odds on a bigger priced horse.
In all reports the results from using the Betfair SP will often contain less data than the SP results as the Betfair SP has only been in operation since 2008. Note to that the information is all based on a fixed commission rate of 5%.
Operators
An operator is used to select how the data should be filtered. The following list shows the various types of operators you can select:
- = equal to (Sire = Pivotal)
- > greater than (Age > 5)
- < less than (SP < 2)
- Between (Runners Between 10 and 15)
- Not = (Allowance Not = 7)
- Contains text contains (Race Name Contains Derby)
Join
Each of the filters are joined together in a string. The default is to AND each filter e.g. Trainer = B J Curley AND SP > 10 AND ...
In some cases you may want use the OR join e.g. Age = 2 OR AGE > 8
When using OR you should correctly 'bracket' the join else the database may get confused. Here are a few examples:
Trainer = B J Curley AND SP < 5 OR AGE = 2
In this example the database will find records for B J Curley runners who are priced < 5, OR any horse which is aged 2. This is clearly not correct and if the intention is to find B J Curley horses who are priced < 5, or any B J Curley 2yo then the form should be set to:
Trainer = B J Curley AND (SP < 5 OR AGE = 2)
For more help on how to use the system builder, and to view sample systems visit the System Builder Support page.
Choose a name item such as Horse or Trainer.
Enter a few characters in the Value box and choose a valid name. You can add one or more names.
The Join field (And, Or) is for combining with other rules.
Choose an item such as Course, Grade or Direction
An operator such as = or a Between range
Value such as an individual course, list of courses or Left.
Choose an item such as
An operator such as = or a Between range
Value such as
Choose a Ratings filter such as Rating, Ratings Pos
An operator such as = or a Between range
Enter a number in the Value box.
If you add more filters choose a join such as And, Or.
Choose a Date filter such as Start or End Date
An operator such as = or a Between range
Enter dates as dd-mm-yyyy e.g. 20-05-2000 for 20th May 2000.
Choose an SP filter such as SP value, or Position
An operator such as = or a Between range
Enter a number in the Value box.
If you add more filters choose a join such as And, Or.
Choose an item such as LTO Position
An operator such as = or a Between range
Value such as 1
Choose an item such as Penalty
An operator such as = or a Between range
Value such as 5
Choose an item such as Last Ran
An operator such as >
Value such as 7
Choose an item such as Distance Change
An operator such as =
Up
Choose an item such as First Time at the Distance
An operator such as =
Value such as Yes
Choose an item such as Jockey Mounts
An operator such as >
Value such as 1
Choose an item such as Gender
An operator such as = or a Between range
Value such as Colt
Choose an item such as Country
An operator such as =
Value such as USA
Choose an item such as Course: Wins
An operator such as >
Value such as 20
Choose an item such as Distance: ROI
An operator such as >
Value such as 30
Use this panel to save your reports in order to call them up at a later date.
Name: The name of the System
Notes: Enter notes such as 'system best with XYZ, or a description of the system'
Category: Put your systems into categories or 'tags' so that you can easily sort / find them. You can add as many words as you wish e.g. If a system is based on a trainer and Group races enter Trainer, Group.
Table Results: Show the System Builder table results (your list of snapshots table / grid) using the SP or Betfair SP
Alert: Check this box if you wish to be alerted as to when there are runners for the system.
Use Betfair Market for SP Filters: If you include rules based on prices you have the option of ignoring the price rules, or using the live Betfair market. e.g. You have a system based on SP Favourites. As the favourite is not known until after the race is run (SP) you can set the alert to find the current Betfair 1st Favourite instead.
Viewable: Keep the system private so that only you can view it, allow it to be viewed by all Flatstats subcribers, or viewable by guests.
Dates: Set the start date and end date for when you wish the alert to be active.
Sorry! Only Flatstats Subscribers can save Snapshots
Snapshots are saved reports which you can call up at any time. You can even set the snapshot to alert you as to when there are any contenders matching the system rules.
If you would like to use this facility please Join Flatstats Today.
Drag and drop report headings into the required order.
Report headings below the Do Not Include line will not be shown on the report.
Revert to Default settings
- Year
- Season
- Ratings
- Course
- Course Grade
- Course Direction
- Course Surface
- Course Speed
- Couse Location
- Race Type (Horse)
- Race Type (Conds)
- Race Type (Rider)
- Race Type (Handicap/Stakes)
- Ages
- Distance
- Distance Range
- Going
- SP Pos
- SP Bands
- SP Range
- Betfair SP Pos
- Betfair SP Range
- Betfair Place SP Range
- Class Range
- Class (Old)
- Class (New)
- Age
- Gender
- Weight
- Last Ran
- Runners
- Allowance
- Good Runs from Last 3 Runs
- LTO Position
- Penalty
- Days Since Win
- Winnings Rank
- Do Not Include In Report all Below:
- Month
- Day
- Class Change
- Race Genders
- Trainer Course Win%
- Jockey Course Win%
- Trainer Form Index (TFI)
- Draw Range
- Drawn
- Draw Advantage, Draw Index
- D Wins
- C Wins
- CD Wins
- Jockey Gender
- Trainer Pareto
- Jockey Pareto
- Sire Pareto
- Trainer
- Jockey
- Sire
- Owner
- Horse
- Dam Sire
- LTO Type (Rider)
- LTO Type (Horse)
- LTO Type (Conditions)
- LTO Course
- Head Gear
- Jockey Change
- Distance Change
- Career Runs
- BSP * Strike Rate
- LTO SP / Runners Ranking
- Horse, Sire Country
- Ranks (Ratings, Trainer Earnings)
- A/E All Races (Sire,Trainer,Jockey)
- Comments (Top Rated, Fav)
- Ratings Forecast Odds
Are you sure you want to delete this filter?
Are you sure you want to reset the form and start a new system?
Sorry! This is not yet available. Please try again in a few days.
Sorry! This facility is only available to Flatstats Subscribers.
This page shows all runners for the system you created. You can see the date, type of race, name of horse, trainer and jockey as well as weights, draw and starting prices.
If you would like to use this facility please Join Flatstats Today.
Sorry! This facility is only available to Flatstats Subscribers.
This page will print out the generated report in a printer friendly format.
If you would like to use this facility please Join Flatstats Today.
System Name: New System
| Item | Operator | Value | Join | Edit | Del | |
|---|---|---|---|---|---|---|
| Type (Rider) | = | Ordinary (Exclude Amatr, App, Lady Races) | AND | race|2|0|Ordinary|0|~tRIDER_TYPE|-t|eq |
Notes for First Time Visitors
To test a system click on the Add Filter buttons in the right hand panel. If you need help with this feature please see the main System Builder Support page.
You are viewing this page as a Guest
If you are a Flatstats subscriber please login to access the full Laying System Builder information.
Non subscribers can Join Flatstats Now and view the full create full reports for laying systems, or just view free sample reports
Options
System Functions
Add Filters
Reports