Horse Racing Excel Data File Glossary - Updated 2022

Q: Does the SFR Rating factor in the state of the track, barriers, distance switches or breaks between starts?

CONDITION OF TRACK Only what was available 48 hours prior. E.g. if it is Thursday night, and the weather for Saturday suggests it will be dry then the variables are adjusted to use dry weather variables. BARRIERS: Yes. For more info, please visit the following link: Barrier Advantage Calculation FAQ DISTANCES: Yes. Our algorithms contain variables which factor in distances switches. BREAKS/SPELLS: Yes. Our algorithms consider the days between runs and spells.

This article outlines all the variables and data structure’s within our horse racing excel data files.

Statfreaks Horse Racing Ratings Excel data files provide further insight into each runner and allow you to further filter, analyze, and zone in on potential value.

You can save the horse racing excel data files to your local computer, update with results, prices and your staking amounts and import into a local database for record keeping purposes.

SAMPLE FILES

* Searching for more FREE data files?. Register for free at www.statfreaks.com.au/register to download more!

View Cart

Enquire / Details

Statfreaks Racing Analytics Database – Expert Form Edition
Horse Racing
View Cart

Buy Now / Details

Full Access Racing Subscription + VIP & Back Data (AUS) – Recurring
All Products, Greyhound Racing, Horse Racing, Ratings
$99.00 inc. GST / month

The Horse Racing Excel data files are available for

Each upcoming horse race meeting as part of the Horse Racing Subscription Package.

GLOSSARY

HORSE RACING EXCEL FILE DATA DEFINITIONS

ID	VARIABLE	DESCRIPTION	EXAMPLE	FORMAT
1	DATE	The Date of the meeting	11/1/2018	dd/mm/yyyy
2	TRACK	Horse Race Track	Flemington	TEXT
3	RACE	Horse Race Number	6	NUMBER
4	NO	Horse Number	2	NUMBER
5	NAME	Horse Name	Humidor	TEXT
6	SFR	Statfreaks rating represented in lengths from the race average	4.1 Lengths above the race average	NUMBER
7	SLB	Statfreaks lengths behind above rated runners	-1.2 Lengths below the rated runner above	NUMBER
8	RK	Statfreaks rating rank of horse in race	Ranked 2 means ranked 2nd In the race	NUMBER
9	RKT	Statfreaks rating rank of horse over the entire meetings	Ranked 3, means ranked 3rd best of the entire meetings	NUMBER
10	BR	Barrier rating rank	1 = Best Ranked Barrier for this race	NUMBER
11	JR	Jockey Rating rank	1 = Best Ranked Jockey for this race against other jockeys	NUMBER
12	TR	Trainer rating rank	1 = Best ranked rated trainer for this race against other trainers	NUMBER
13	SET	Predicted settling position	1 = Horse is predicted to lead.	NUMBER
14	PR4	Predicted position horse will be in at the 400-meter point	4 = Horse is predicted to be positioned 4th at the 400-meter mark	NUMBER
15	PR2	Predicted position horse will be in at the 200-meter point	2 = Horse is predicted to be positioned 2nd at the 200-meter point	NUMBER
16	TOF	Turn of foot rank	1 = Horse has best turn of foot in race, 2 = horse has 2nd best turn of foot in race	NUMBER
17	FQ	Field Quality of horses in race, measured by the SFR rating benchmark	1.1 = The field quality is 1.1 lengths above the SFR benchmark quality for this race at this track and distance. The higher the quality, the more predictable the race may be.	NUMBER
18	DQ	Quality of data that makes up the race	Quality of data that makes up the race, 100 = High Data quality, all runners covered with historical sectional data	NUMBER
19	TEMP	Predicted race tempo	The Predicted Speed of the race, average, slow, fast and moderate	TEXT
20	COM1	Predicted commentary which described raw predicted variables	Predicted to lead	TEXT
21	COM2	Predicted commentary which described raw predicted variables	Ability to accelerate quickly	TEXT
22	COM3	Predicted commentary which described raw predicted variables	Nice run last start	TEXT
23	STAR_RATING	PURPLE: Best rated horse at meeting, RED: Top rated runner in race and in Top 8 at meeting, YELLOW: Rated in top 4 of race.	“PURPLE”	TEXT
24	RIR	“Runners in Race”: The number of runners in the race within the data file.	6	NUMBER
25	DIS	Race Distance	1	NUMBER
26	DISGRP	"DISTANCE GROUP": SPRINT: up to 1250 meters, MIDDLE: 1251 meters to 1700 meters,STAYING: 1700 meters and above	“SPRINT”	TEXT
27	STATE	The state the race is held in, within the country.	“VIC”	TEXT
28	RTIME	The start time of the race, displayed in local state time	“VIC”	TEXT
29	FAVSRCY	The current years win strike rate for that race’s track and distance group.	21.88	NUMBER
30	FAVSRPY	The previous years win strike rate for that race’s track and distance group.	32.88	NUMBER
31	LSRK	The last Predicted SFR Rank the horse produced in its last run within our statfreaks database.	3	NUMBER
32	LSRKT	The last Predicted SFR Meeting Rank the horse produced in its last run within our statfreaks database.	21	NUMBER
33	LSRW	Within our system, did the horse win in its last run? “w” = Win.	“w”	TEXT
34	LSRP	Within our system, did the horse place in its last run? “p” = Place.	“p”	TEXT
35	YEAR	Year the race is taking place.	2020	NUMBER
36	MONTH	Month the race is taking place.	“Sep”	TEXT
37	MAPDR	The direction the speed map is displayed on the PDF. “LEFT” or “RIGHT”. This also represents the direction the race is run.	“LEFT”	NUMBER
38	DMT	Statfreaks “Model Tracking” indicator. Based of our internal monitoring system, the selected runner with its variables combination historical has a win strike rate of 30% and over and an RKT of 4 or less on the day. This variable is only available on the day of the event occurring.	“x”	TEXT
39	JAT_SET	Jockey Analysis Variable. Where the runner is predicted to settle in the race. This variable is used to calculate the jockeys Win Strike rate column (JAT_WSR)	“LEAD PACK”	TEXT
40	JAT_DIS	Jockey Analysis Variable, Race Distance Group. This variable is used to calculate the jockeys Win Strike rate column (JAT_WSR).	“SPRINT”	TEXT
41	JAT_RIDES	Jockey Analysis Variable. The number of rides our system has used to calculate the Win Strike rate column (JAT_WSR) for the rider.	43	NUMBER
42	JAT_WINSR	Jockey Analysis Variable. The historical Win Strike rate for the jockey, when they have ridden historical in the same race distance group, and settled in the predicted position.	0.3	NUMBER
43	JAT_PLCSR	Jockey Analysis Variable. The historical Place Strike rate for the jockey, when they have ridden historical in the same race distance group, and settled in the predicted position.	32.88	NUMBER
44	JAT_HMKTEG	Jockey Analysis Variable. Market Edge Historical for the jockey, when they have ridden in the same distance group and settled in the same position. A positive value, represents that average win price has been greater than the strike rate prices converted to a dollar value.	4.2	NUMBER
45	STAR_RATING	Star Rating of runner from PDF report. Purple = Best Rated runner at meeting, Yellow = Top 4, Red = Top 8	"Purple"	TEXT
46	SFR_WPER	SFR Historical Win Strike rate calculated from our statfreaks back end algorithm	32%	NUMBER
47	SFR_W108PRC	SFR_WPER converted to a dollar value using 108%/SFR_WINPER	$3.30	NUMBER
48	SFR_PPER	SFR Historical Place Strike rate calculated from our statfreaks back end algorithm	57%	NUMBER
49	SFR_P108PRC	SFR_PPER converted to a dollar value using 108%/SFR_PPER	$1.80	NUMBER
50	JC_RKTPER100	Historical RKT Win Strike rate for the current RKT value with current jockey, last 100 historical records, and minimum 100 records otherwise empty	28%	NUMBER
51	JC_RKTPRC100_108	JC_RKTPRC50 converted to a dollar value using 108%/JC_RKTPRC100, empty if JC_RKTPRC100 is empty	$3.80	NUMBER
52	TN_RKTPER100	Historical RKT Win Strike rate for the current RKT value with current trainer, last 100 historical records, and minimum 100 records otherwise empty	36%	NUMBER
53	TN_RKTPRC100_108	JC_RKTPRC50 converted to a dollar value using 108%/TN_RKTPER100, , empty if JC_RKTPER100 is empty	$3.00	NUMBER
54	RT_RKTPER50	Historical RKT Win Strike rate for the current RKT value with current rider/trainer combo, last 50 historical records, and minimum 50 records otherwise empty	43%	NUMBER
55	TN_RKTPRC50_108	JC_RKTPRC50 converted to a dollar value using 108%/RT_RKTPER50, , empty if RT_RKTPER50 is empty	$2.50	NUMBER
ID	VARIABLE	DESCRIPTION	EXAMPLE	FORMAT

DATA MODEL TRACKING

The “Data Model Tracking” (DMT) column was introduced to track historical variable combinations with a strike rate of 30% or greater and ranked within the Top four runners for that meeting. Within each upcoming PDF and CSV file we provide a few indicators to identify when our system has identified these selections.

CSV FILE: Within the CSV file, the DMT Column will have a “x” displayed when that runner matches the historical 30% or greater variable profile, and is ranked within the top 4 runners for that meeting (RKT = 4 or less)

PDF REPORT: Within the PDF report, we have introduced a new comment under the “Commentary 3” area. When a runner’s variable combination lines up with 30% or greater historical win strike rate profile and ranked within the top four runners for that meeting, the comment “Strong in our data models” will appear.

The DMT variable will only be available on the day of the event, therefore its best to obtain the latest CSV file, and PDF the same day the meeting is ran on, to have visibility of the DMT indicator.

The PDF report does not always show “Strong in our data models” as it is mixed with other commentary, therefore it is always best to check the CSV to obtain all data model tracking indicators on the day.

The DMT was introduced on September the 8th, 2020 and will be tracked going forward.

COMMENTRY

Using our data variables, the statfreaks system generates commentary, which is displayed on the PDF reports, and inside the excel CSV horse racing ratings data files. These comments can be used to quickly identify runners which have strong historical variables, and/or possess strong predicted upcoming variables.

COMMENTRY 1

Best rated jockey in race
Best rated runner of day
Excellent last start
Not enough historical data
Predicted to lead
Strong chance today

COMMENTRY 2

Ability to accelerate quickly
Great late closing speed
Has barrier advantage
HWS: %, MWP: %
- HWS: Historical Strike Rate – Located in commentry 2, Historical Strike Rate for combined RK/RKT value, 25% and over displayed for a selected runner
- MWP: Minimum Win Price – Located in commentry 2, The minimum market price to take for selected runner, based on 130% market
Ran well last start
Strong turn of foot

COMMENTRY 3

Best rated trainer in field
Can flash home late
Nice run last start
Suits the distance
Strong in our data models

FREQUENTLY ASKED QUESTIONS

Why do the SFR ratings change from the original document to the race morning document, even in races when there are no scratchings?2019-01-27T13:56:18+11:00

Why do the SFR ratings change from the original document to the race morning document, even in races when there are no scratchings?

- We receive new data every few hours. Therefore, the algorithms re-run every night.
  - We occasionally receive some late sectional data which may shift a single horse up or down. Therefore all the other horses SFR will get adjusted as the SFR is an in race rating.
  - If we release a report early, the 10-11am version can be different from earlier versions due to
    - We have received some data from the previous days rides from a jockey, which alters the jockey ratings. E.g. D Oliver might have had six rides the day before, that will get adjusted and re-calculated.
    - There is a late rider change.
    - A tactic change, the horse will be ridden more forward.

Does the SFR Rating factor in the state of the track, barriers, distance switches or breaks between starts?2019-01-27T13:58:28+11:00

Does the SFR Rating factor in the state of the track, barriers, distance switches or breaks between starts?

- CONDITION OF TRACK
  - Only what was available 48 hours prior. E.g. if it is Thursday night, and the weather for Saturday suggests it will be dry then the variables are adjusted to use dry weather variables.
- BARRIERS:
  - Yes. For more info, please visit the following link: Barrier Advantage Calculation FAQ
- DISTANCES: Yes. Our algorithms contain variables which factor in distances switches.
- BREAKS/SPELLS: Yes. Our algorithms consider the days between runs and spells.

How do you calculate “Has barrier advantage” in SFR Reports?2019-01-27T13:58:35+11:00

How do you calculate “Has barrier advantage” in SFR Reports?

Our SFR data calculates barrier advantage by reviewing accurate historical sectional timing data and converting the lengths lost for each horse that begins from each barrier. For example;

Barrier 1 at Caulfield has average 1.9 lengths losing margin from the winner, and barrier 2 at Caulfield an average of 1.4 lengths from the winner, we would then rate barrier 2 higher than barrier 1 as on average it has a smaller losing margin from the winner.
Our systems process this logic for all barriers at every track and distance, and then factor’s it into the SFR rating on the day.

Why do we do this? Our internal calculations over the years have shown us that this is a more accurate way to measure barrier advantage than strike rates. Further to this, it allows us to see which staring barriers have an advantage with assisting a horse hustling into position at the 800,600,400 and 200-meter points.

Where can i buy Stat-freaks rating products?2019-01-27T13:59:07+11:00

Where can i buy Stat-freaks rating products?

Please visit our products area by clicking here.

When purchasing any product as a non-existing member, you will automatically receive a free statfreaks membership.

Do you incorporate sectional times for horse racing ratings?2019-01-27T14:00:05+11:00

Do you incorporate sectional times for horse racing ratings?

Yes, we use the most accurate sectional timing data available on the market to ensure our algorithms and learnings are as precise as possible. All horse racing ratings and analysis is completed using data provided from Daily Sectionals. If you are interested in obtaining sectional data for your analysis, please visit

“Daily Sectionals” – www.dailysectionals.com.au

How are statfreaks ratings created?2019-04-19T15:10:00+10:00

How are statfreaks ratings created?

Dating back to 2012, we have continuously developed and evolved advanced algorithms and database systems for racing, sports, and trading markets. Our research, analysis, and products are entirely free from human bias; we let data and information show us the insights which we then incorporate into our products. We store our ratings and ideas inside our secure statfreaks vault. You can access the vault with our free statfreaks membership by visiting https://www.statfreaks.com.au/register or with the purchase of an Advanced Subscription.

SFR F1 Ratings Explained
Gallery
SFR F1 Ratings Explained

SFR F1 Ratings Explained

HOW TO READ AND UNDERSTAND OUR STATFREAKS F1 RATING REPORTS COVER PAGE 1) Pre-Qualifying and Pre-Race Reports Subscribed members will have access to three [...]

Ep: 77 – Data Analytics and Betting Optimization
Gallery
Ep: 77 – Data Analytics and Betting Optimization

Ep: 77 – Data Analytics and Betting Optimization

David Vitali speaks about his time as a Data Architect in the corporate world and his transition to sports and racing. We talk about data analytics, how to optimize [...]

5 Useful Data and Analytic Tool’s for Professional Analysts- 2019
Gallery
5 Useful Data and Analytic Tool’s for Professional Analysts- 2019

5 Useful Data and Analytic Tool’s for Professional Analysts- 2019

Working with data for over a decade now I have come across some exciting tools. Some of them ahead of there time, while others limited and basic in functionality. [...]

Previous 345 Next