Exporter

Info:

In the exporter feature we have added the ability to export the sectional times and metrics and pars.

 

Checking and UnChecking Fields

Because there is a huges amount of fields to choose from we have added a Check and UnCheck facility to the top of the exporter.

You can enter any characters into the edit box above the sectionals exporter and then use the Check and UnCheck buttons to tick and until items in the sectionals exporter field list.

 

Choosing the Timeframe for the Data Export

You can use the Last x Days box to decide on how many days backwards you wish to export the sectional data or you can set this to 0 and use the start and end dates in the calendar boxes to determine the timeframe of the export.

 

Tick Saving

One set of field ticks are saved for the sectional export.  The software will remember the last set of field ticks you have setup.

 

Exporting Data

The sectionals exporter is independant to the main data exporter, which is on the left.

Becuase of this we have added the main fields you would need to link data to other exporters in what ever external tools you are using, namely, DateTime, Course, Horse Name, Horse Country of Breeding and Finishing Position.

When you export data using the Export Sectional Data button it WILL export races with or without sectional data. 
This is so you could in theory select todays date, set Last x Days to zero and tick some LTO sectional fields, thus allowing you to export todays runners and see their LTO sectionals. 
Also by allowing the exporter to export races with or without sectionals, will mean it is easier to marry up exports from normally exporter.

 

Auto Export

You can setup auto exporting of this data by ticking the auto export ON/OFF tickbox under the Export Sectional Data button and setting the time in the edit box next to it.

Leave Proform and the exporter screen open if you are auto exporting.

 

 

We have created an excel document explaining all the data fields you can see in Proform, plus how far back the historical sectional data goes and the data tolerances we used to block obvious data errors coming into our database, you can download this on the following link:-

DOWNLOAD the SECTIONAL DATA GLOSSARY

New LTO Fields in Ratings Speed & User Tab

Info:

At the bottom of this screen we have added thirteen new fields for querying LTO user rating ranks, values and clearbys and also LTO speed figure.

Primarily we added these for those of you using sectional times data from Timeform. This is imported into user rating 4 (the finishing speed %) and user rating 3 (upgrade figure).

Now that you can query the last time out values stored from the sectionals more analysis can be performed.

  • i.e. you could look at last time out AW races at class 4 level which has a class par speed figure of 66 and then enter >66 in the LTO Speed Rating and then experiment with the upgrade and finishing speed figures, say something like >0 for LTO User Rating 3 value field (upgrade figure) and >100 for LTO User Rating 4 value field (fin speed %).

This would show you the bottom line figures for horse who last time out ran in a AW class 4 race and recorded a speed figure above par and also a upgrade better than 0 and a finishing speed better than 100%, so in essence we have found horses who ran in a truly run class 4 AW race producing a better than par figure and a upgrade above 0.

You could do this for all the different classes and race types and find some very neat profitable angles.

All the class pars can be found here 

Proform Speed Ratings Class Pars

Info:

Class Pars are the median figures for winners for each class of race in each of the five race types.

The data used is for UK horse racing since 2006. Here are the tables of class pars for flat and jumps.

How to Use Class Pars

One way is to only look at horses in a race that have clocked a speed figure that is higher than the median for that race type and class.

Lets look at an example using Last Time Speed Ratings.

From above we can see that the median speed rating for Class 1 AW races is 76.

If we use the system builder to analyse Class 1 AW races from 2006 onwards and then add in a parameter of <76 against the Last Time Out Ratings field on the Speed Ratings by Value tab

and run the system, we are returned :-

This shows how horses who last time out did not achieve a speed rating equal to or higher than the median for the class of race ran. 

If we then change the speed ratings value parameter to >=76, the results are

We can see straight away that this is twice the strike rate of the query above.

This tells us that horses who achieved a speed rating of at least 76 last time out hold a much better chance of winning in class 1 AW races.

The rating of 76 we used is equal to the class par for class 1 AW races.

Of course you don’t need to look at just the Last Time Out speed ratings, you could use any of the speed ratings.

Find out more about our

Dynamic Speed Ratings

Static Speed Ratings

Proform Ratings, what's available, how are they created and where can you find them

Sectional Tab - Finishing Speed % Difference- Form Book

Info:

The finishing speed % difference tab can be seen when you have a race open and you are viewing the sectionals tab in the Proform Form Book.

It looks like this.


(Click image for larger version)

FSP% Diff
This tab shows the difference in % of Finishing Speed % minus going adjusted Par Finishing Speed %. A positive value is better than par.  The final furlong (finish) is on the left.

Pars
The FS%'s in braces in the heading bar for each section are the ground adjusted par FS% for this race.

Colour Coding
We have colour coded this grid using the FS% vs Par FS%.  Any FS% that is better or worse than par (within a tolerance determined by race distance) will be shaded in degrees of green (better than par) or red (worse than par).  The deeper the colour the bigger the difference either way.

Race Replay
You can also view the race replay quickly from this tab by clicking the replay icon next to the hid chart button.

 

We have created an excel document explaining all the data fields you can see in Proform, plus how far back the historical sectional data goes and the data tolerances we used to block obvious data errors coming into our database, you can download this on the following link:-

DOWNLOAD the SECTIONAL DATA GLOSSARY

Sectional Tab - Finishing Speed % Efficiency- Form Book

Info:

The finishing speed % efficiency tab can be seen when you have a race open and you are viewing the sectionals tab in the Proform Form Book.

It looks like this.


(Click image for larger version)

FSP% Efficiency Rank
This tab shows the Efficiency rank of each section, i.e. how close to efficient each section was, lowest rank is closer to efficient.  The final furlong (finish) is on the left.

Pars
The FS%'s in braces in the heading bar for each section are the ground adjusted par FS% for this race.

Colour Coding
We have colour coded this grid using the FS% vs Par FS%.  Any FS% that is better or worse than par (within a tolerance determined by race distance) will be shaded in degrees of green (better than par) or red (worse than par).  The deeper the colour the bigger the difference either way.

Race Replay
You can also view the race replay quickly from this tab by clicking the replay icon next to the hid chart button.

 

We have created an excel document explaining all the data fields you can see in Proform, plus how far back the historical sectional data goes and the data tolerances we used to block obvious data errors coming into our database, you can download this on the following link:-

DOWNLOAD the SECTIONAL DATA GLOSSARY

Sectional Tab - Finishing Speed %'s - Form Book

Info:

The finishing speed % tab can be seen when you have a race open and you are viewing the sectionals tab in the Proform Form Book.

It looks like this.

Finishing Speed %'s
The finishing speed %'s grid shows the FS% for each section with the final furlong (finish) on the left.

Pars
The FS%'s in braces in the heading bar for each section are the ground adjusted par FS% for this race.

Colour Coding
Any FS% that is better or worse than par (within a tolerance determined by race distance) will be shaded in degrees of green (better than par) or red (worse than par).  The deeper the colour the bigger the difference either way.

Chart
The graph under the FS% grid shows you the par FS%'s with a thick black line and then each horse is a different color on the chart, which you can see in the legend on the right.

Splitter Bar
The green splitter line between the grid and the chart can be used to size the graph.

Toggle Horses on Chart
You can tick horses on and off the graph using the tickboxes next the horse names in the graph legend.

Filter Horses on Chart
You can filter the number of horses in the graph with the filter finishers drop down list.

Hide/Show Chart
You can hide the chart using the hide chart button above the grid tab headings

Race Replay
You can also view the race replay quickly from this tab by clicking the replay icon next to the hid chart button.

 

We have created an excel document explaining all the data fields you can see in Proform, plus how far back the historical sectional data goes and the data tolerances we used to block obvious data errors coming into our database, you can download this on the following link:-

DOWNLOAD the SECTIONAL DATA GLOSSARY