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

Going Adjustments

We have always created going adjustments (GA) internally, which we use to create the Proform Speed Figures, however we have never released them, until now.

GA’s show you have much the ground on the day was speeding up or slowing down horses in seconds per mile.

A going adjustment of 0 would represent perfect Good ground in races on turf or perfect Standard ground on the a all-weather surface.  We then have positive or negative GA’s to varying degrees.

GA Lookup Table

GA’s are very useful particular when the ground is extremely slow.  You can see in the table we have the standard going descriptions ranging from Firm to Heavy and Fast to Slow but particularly in races on grass we four more going descriptions for when the ground is very bad.

There are some horses, sires, dams and damsires that only show their best when performing in demanding conditions and GA’s in Proform will allow you to find these horses on days when the ground is truly terrible.

So, what have we added to the Proform Software regarding GA’s?

System Builder
There is a new GA field in the system builder in the race tab.

You can present by GA in the presentation screen in the system builder

You can add GA to system builder drill downs in the system builder preferences tab, which means you use this for exporting GA’s.

Form Book
When viewing a result in the form book dataview the actual going and GA are show in the header

Horse Form
When viewing a horses form a column for GA was added.

NOTE: The new field will be at the very right-hand side of the fields, you may need to scroll sideways to find it.  You can then move it where you wish etc.

Prior Form
GA is added to prior form screen.

NOTE: The new field will be at the very right-hand side of the fields, you may need to scroll sideways to find it.  You can then move it where you wish etc.

Calendar
When viewing the calendar for a past days racing the GA is shown with lots more new fields.

Form Book Filters

GA has been added to the form book main filters screen on the race related filters tab.

This means you can create any number of filters to quickly filter form in the form book using GA’s.

To refresh yourself on how filters work visit this help link.

We have also changed the distance filters to yards on the same screen.  This is because the old method contains a bug when new distances were introduced which meant filters kept breaking.

By using yards instead this fixes that issue.

Highest Class

The HC field is a high class indicator field, it works like this :-
The software looks at the last x runs for the horse under the same code of racing as today and notes the highest speed rating achieved in these x runs. It then grabs the class of race that this speed rating was achieved in. This is what is displayed in the column.

x runs can be changed in the preferences under the speed rating tab and defaults to 3

It also works with any filters set. So for instance with no filters set, it is looking at the last x races from the same racing code in races prior to the race you are viewing, and finds the highest speed rating and displays the class of the race.

If you had filters set to ignore turf races and you were viewing a turf race then no HC class figures would be shown.

When viewing horse form or prior form tabs in the form book you can see some top line sectional metrics, like this

(Click image for larger version)

(NOTE: The fields will not be in the order shown.  You can customise the field order by right clicking on any heading and choosing show fields from the pop-up menu which appears)

The sectional metric fields display are :-

MaxU - Max upgrade from last 4f, which is how many pounds they could have improved by running the section more efficiently (pounds)

LbsAU - Pounds (LBS) behind winner after upgrade

LenAU - Lengths behind winner after upgrade

ChLen - This is difference between the actual lengths beaten and the lengths after applying the upgrade lengths

PosAU - This is the theoretical finishing position after applying the upgrade

ChPos -This is the difference between the actual finishing position and the theoretical finishing position

LTO_MaxU - Last Time Out - Max upgrade from last 4f, which is how many pounds they could have improved by running the section more efficiently (pounds)

LTO_LbsAU - Last Time Out - Pounds (LBS) behind winner after upgrade

LTO_LenAU - Last Time Out - Lengths behind winner after upgrade

LTO_ChLen - Last Time Out - This is difference between the actual lengths beaten and the lengths after applying the upgrade lengths

LTO_PosAU - Last Time Out - This is the theoretical finishing position after applying the upgrade

LTO_ChPos -Last Time Out - This is the difference between the actual finishing position and the theoretical finishing position

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

Typically TPD (where we get the raw data) process the sectional data withing a couple of days after the race.

We then process this and you should normally see the data arrive in Proform with three days after the race was run.

On a weekend (Friday-Sunday) the data data may not arrive until the following Monday to Wednesay.

Sometimes races will be delayed by TPD for checking and could take more than three days to arrive.

When you download data into Proform it automatically checks for any new sectional data and will seamlessly install it.

You can check to see if data is in by looking at the sectional field on the calendar screen which will show YES when the data is in and NO when not, like this:-

Within Proform, Irish results are in the database back to January 1^st 2009 

There are a few differences within Irish Racing when compared to UK Racing, as follows :-

Euro's

Firstly Irish race prize money is in Euro's, so on the racecard and results headers in dataview you will see the Euro symbol, see screen image below.

Class of Irish Races
Secondly, there is no equivalent class numbering system for Irish Races other than for class 1 races, so we have created the classes for all Irish races based on the type of race it is and the prize money of the race when compared to similar races in the UK.

The calculation is fairly straight-forward and takes account of the difference between Euro's and Pounds Sterling and also takes account of the Official Rating ranges in handicaps.

The calculated classes give us an equivalent class system to UK races and allow us to create speed ratings etc


Ratings for Irish Races
Although the Irish races start on January 1^st 2009 most of the ratings for Irish races do not start until much later, here are the dates for ratings within Irish Racing.

The following ratings all start from the Dundalk meeting on 28^th October 2010, 
Main, 
Stats, 
Main+Stats, 
Tissue, 
PFR, 
Stats Trn, 
Stats Jky, 
Stats Trn/Jky, 
Stats Horse, 
PRC Avg, 
PRC1, 
PRC2 and 
PRC3 Ratings.


The following ratings all start from the beginning of Irish Racing in the database on 1^st January 2009, 
Speed, 
Pace and 
Official Ratings.