A. Exported Files - Daily Racing Form | DRF

Exported Files

A. Exported Files

Introduction In this appendix

You can export DRF race cards to comma delimited files using the Export DRF Race Card dialog box. The formats of the comma delimited files are described in this appendix.

This chapter contains the following topics.

Topic Export File Definitions Special Products File Layout Workout File Layout Race File Layout Comprehensive Trainer Statistics File Layout Running Line File Layout Horse File Layout Betting Information File Layout Code Tables

See Page 84 85 86 87 89 90 94 98 99

Formulator User's Guide

83

Exported Files

Export File Definitions

Introduction

When you choose to export a race card, six different types of comma delimited files are generated.

Special Products File This file contains Beyer Speed Figures and Mudders and Turfers ratings for the entire race cards.The Special Products File has a file extension of .CS.

Workout File

This file contains workout level information for all horses in the race card. The Workout File has a file extension of .CW.

Race File

This file contains race level information for all races in the Race Card. The Race File has a file extension of .CR.

Comprehensive

This file contains comprehensive trainer statistics for all horses in the race

Trainer Statistics File card.The Comprehensive Trainer Statistics File has a file extension of .CT.

Running Line File

This file contains running line level information for all horses in the race card. The Running Line File has a file extension of .CHR.

Horse File

This file contains entry level information for all horses in the race card, as well as a "scratch indicator" for all scratched horses in the race card. The Horse File has a file extension of .CH.

Betting Information File

This file contains any late changes to information for the horses in the race card, such as the official betting numbers, scratches, jockey changes, and the morning line. The Betting Information File has a file extension of .PGH. Note that this file does not include scratched horses, but a scratch indicator is set in the horse file record for all scratched horses.

84

Formulator

Exported Files

Special Products File Layout

Introduction

The following table describes the layout of the Special Products File

Field Description

1

Race Card Track

2

Race Card Date

3

Race Card Race

4

Horse

5

Foreign or Domestic

6

Best Fast Dirt

7

Best Turf

8

Best Wet

9

Best Distance

10 Best Lifetime

11 Best Current Year

12 Best Prior Year

13 Best Track Surface

14 Mudder & Turfers Mud Rating

15 Mudder & Turfers Turf Rating

16 Mudder & Turfers Distance Rating

Type Text Date Numeric Text Text

Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Character Character Character

Format 4 mm/dd/yyyy 2 22 2

4 4 4 4 4 4 4 4 4 4 4

Comments

D=Domestic F=Foreign G=Foreign

Formulator User's Guide

85

Exported Files

Workout File Layout

Introduction

The following table describes the layout of the Workout File

Field Description

1

Race Card Track

2

Race Card Date

3

Race Card Race

4

Horse

5

Foreign or Domestic

6

Track

7

Date

8

Surface

9

Distance

10 Track Condition

11 Workout Type

12 Workout Time

13 Bullet

14 Comment

15 Rank

16 Rank In

Type Text Date Numeric Text Text

Text Date Text

Numeric Text Text Numeric Text Text Numeric Numeric

Format 4 mm/dd/yyyy 2 22 2

4 mm/dd/yyyy 2

6.2 4 2 6.2 2 16 4 4

Comments

D=Domestic F=Foreign G=Foreign

See Workout Surface Code Table on page 104

Y=Yes

86

Formulator

Exported Files

Race File Layout

Introduction

The following table describes the layout of the Race File

Field Description

1

Race Card Track

2

Race Card Date

3

Race Card Race

4

Starters

5

Track Name

6

Race State

7

Division

8

Race Breed

9

State Bred

10 Sex of Race

11 Age of Race

12 Class 13 Purse 14 High Claim Price 15 Low Claim Price 16 Distance 17 Inner

18 Surface

Type Text Date Numeric Numeric Text Text Text Text

Text

Text

Text

Text Numeric Numeric Numeric Numeric Text

Text

Format 4 mm/dd/yyyy 2 2 40 2 2 2

2

2

2

4 10.3 10.3 10.3 6.3 2

2

Comments

See Breed Type Code Table on page 100. Blank=Open S=State Bred R=Restricted See Sex Code Table on page 102 See Age Code Table on page 99

In Thousands In Thousands In Thousands

See Inner Code Table on page 100 See Surface Code Table on page 103

Formulator User's Guide

87

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download