UK Horse Racing

CSV Documentation for Developers

9th March 2010

Version 23. Added two columns for the Underscore Regression Rankings.

RGoing Rank - Column 139. If this is the top rated Regression Going then 1, second best Regression Going then 2 and so on.

RDistance Rank - Column 140. Ranking for the RDistance field.

8th March 2010

Version 22. Added one column for the country abbreviation.

Country - Column 138. The country abbreviation of the course's location..

22nd May 2009

Version 21. Added twelve columns for the Trainer Calendar and the Trainer Five Year statistics.

Trainer Calendar Runs - Column 126. Trainer's runs in this 15 day window over the last five years.

Trainer Calendar Wins - Column 127. Trainer's wins in the same period.

Trainer Calendar Return - Column 128. Returns for the trainer in this period (one point per runner).

Trainer Calendar P/L - Column 129. Profit/Loss for the trainer in this time frame.

Trainer Calendar SR% - Column 130. The strike rate for the above data.

Trainer Calendar ROI% - Column 131. The return on investment on the trainer during the window.

Trainer 5 year Runs - Column 132. The number of runners the trainer has had in the last five years.

Trainer 5 Year Wins - Column 133. The number of winners the trainer has had in the last five years.

Trainer 5 Year Return - Column 134. Total returns for the trainer in this period (one point per runner).

Trainer 5 Year P/L - Column 135. Total Profit/Loss for each of the trainer's runners in the last five years.

Trainer 5 Year SR% - Column 136. The trainer's five year strike rate.

Trainer 5 Year ROI% - Column 137. The trainer's five year return on investment.

14th May 2009

Version 20. Added twelve columns for the Underscore Rankings.

Raw Rank - Column 114. If this is the top rated Raw then 1, second best Raw then 2 and so on.

RAdj Rank - Column 115. Ranking for the RAdj field.

Jockey Rank - Column 116. Ranking for the Jockey field.

Trainer Rank - Column 117. Ranking for the Trainer field.

TrForm Rank - Column 118. Ranking for the TrForm field.

Conn Rank - Column 119. Ranking for the Conn field.

Frm Rank - Column 120. Ranking for the Frm field.

Lst Rank - Column 121. Ranking for the Lst field.

Cls Rank - Column 122. Ranking for the Cls field.

WinF Rank - Column 123. Ranking for the WinF field.

Spd Rank - Column 124. Ranking for the Spd field.

HCP Rank - Column 125. Ranking for the HCP field.

17th February 2009

Version 19. Added one column.

Hunter Chase - Column 113. Populated with 'Hunter Chase' if a hunter chase race.

13th February 2009

Version 18. Added seven columns.

WRITE FAVOURITE RANKING - Column n-5. The ranking, from 1 for favourite, in SP price order. Note that this column will ALWAYS be the sixth from the end.

Selling - Column 107. Populated with 'Selling' if a selling race.

Claiming - Column 108. Populated with 'Claiming' if a claiming race.

Auction - Column 109. Populated with 'Auction' if an auction race.

Novice - Column 110. Populated with 'Novice' if a novice race.

Maiden - Column 111. Populated with 'Maiden' if a maiden race.

Beginner - Column 112. Populated with 'Beginner' if a beginner race.

early February 2009

Version 17. Added one column.

Form - Column 106. Lists the horse's most recent form.

28th January 2009

Version 16. Added twenty-two columns.

Add Betfair Placed Here - Column n-5. 0 = not placed on Betfair, 1 = 0 placed on Betfair. Note that this column will ALWAYS be the sixth from the end.

TJ Wins - Column 85. Trainer and Jockey combination (TJ) number of wins.

TJ Runs - Column 86. TJ runs.

TJ PL - Column 87. TJ profit/loss.

TJ Runs - Column 88. TJ Strike Rate.

TJ ROI - Column 89. TJ ROI%.

TRF_20RunsWins - Column 90. Trainer Recent Form (TRF), number of wins over the last 20 runs

TRF_20RunsRuns - Column 91. TRF, number of runs over the last 20 runs (max 20, of course)

TRF_20RunsPL - Column 92. TRF PL, 20 last runs

TRF_20RunsSR - Column 93. TRF Strike rate, 20 last runs

TRF_20RunsROI - Column 94. TRF ROI, 20 last runs

TRF_20RunsDays - Column 95. TRF days taken for these last 20 runs.

TRF_2WeeksWins - Column 96. TRF, wins over the last 2 weeks.

TRF_2WeeksRuns - Column 97. TRF runs, 2 weeks.

TRF_2WeeksPL - Column 98. TRF PL, 2 weeks.

TRF_2WeeksSR - Column 99. TRF SR, 2 weeks.

TRF_2WeeksROI - Column 100. TRF ROI, 2 weeks.

TRF_4WeeksWins - Column 101. TRF, wins over the last 4 weeks.

TRF_4WeeksRuns - Column 102. TRF runs, 4 weeks.

TRF_4WeeksPL - Column 103. TRF PL, 4 weeks.

TRF_4WeeksSR - Column 104. TRF SR, 4 weeks.

TRF_4WeeksROI - Column 105. TRF ROI, 4 weeks.

27th January 2009

Version 15. Added one column.

Add Betfair Place SP Here - Column n-4. The place SP from the Betfair exchange. Note that this column will ALWAYS be the fifth from the end.

22nd January, 2009

Version 14. Added one column.

Value Odds (BetFair format) - Column 84. The value of the runner in Betfair format.

12th January 2009

Version 13. Added one column.

Add Betfair SP Here - Column n-3. The SP from the Betfair exchange. Note that this column will ALWAYS be the fourth from the end.

21st May 2008

Version 12. Added ten columns.

TC Wins - Column 74. Trainer at this course (TC) number of wins.

TC Runs - Column 75. TC runs.

TC PL - Column 76. TC profit/loss.

TC Runs - Column 77. TC Strike Rate.

TC ROI - Column 78. TC ROI%.

JC Type Wins - Column 79. Jockey at this course (JC) number of wins .

JC Type Runs - Column 80. JC runs.

JC Type PL - Column 81. JC profit/loss.

JC Type Runs - Column 82. JC Strike Rate.

JC Type ROI - Column 83. JC ROI%.

All figures are from a five-year rolling period.

14th April 2008

Version 11. Added one column.

Runners - Column 73. The number of declared runners in the race.

March 2008

Version 10. Added one column.

BST/GMT - Column 72. Whether the time stamp is in BST or GMT. This is useful for the Betfair API.

12th February 2008

Version 9. Added ten columns.

TJC Wins - Column 62. Trainer Jockey Combination (TJC) at this course number of wins.

TJC Runs - Column 63. TJC runs.

TJC PL - Column 64. TJC profit/loss.

TJC Runs - Column 65. TJC Strike Rate.

TJC ROI - Column 66. TJC ROI%.

TJC Type Wins - Column 67. Trainer Jockey Combination (TJC) at this course number of wins of this race type (eg hurdles, chases) and handicap or stakes to match today's race.

TJC Type Runs - Column 68. TJC Race Type runs.

TJC Type PL - Column 69. TJC Race Type profit/loss.

TJC Type Runs - Column 70. TJC Race Type Strike Rate.

TJC Type ROI - Column 71. TJC Race Type ROI%.

All figures are from a five-year rolling period.

11th February 2008

Version 8. Added one columns.

Time 24 Hour - Column 61. The time of the race in 24 hour format.

9th February 2008

Version 7. Added one columns.

Systems - Column 60. The selection systems (back and lay) of the horse.

15th August 2006

Version 6. Added two columns.

Date - Column 58. The date of the race.

Elapsed Days - Column 59. Date as number of days since 1/1/1970.

Winter 2005

Version 5. Added one column.

Raw Adjusted - Column 57. The raw rating adjusted for weight and age.

19th August 2005

Version 4. Added three columns.

Value Place Odds - Column 54. Value of a place.

BetFair SP Forecast Win Price - Column 55. Forecast of price at off on Betfair to win (with 100% overround).

BetFair SP Forecast Place Price - Column 56. Forecast of price at off on Betfair to place (with 100% overround).

9th August 2005

Version 3. Added one column.

Handicap - Column 53. Either blank, 'Handicap' or 'Nursery'.

31st May 2005

Version 2. Added one column.

WRITE GOING HERE - Number of Columns - 2. Place to insert the actual going data.

31st May 2005

Version 1. Added one column.

CSV Version - Column 52. The version number of the CSV layout.

30th May 2005

Added one column.

Ratings Position - Column 51. The horse's ranking in the ratings.

29th May 2005

Added three columns.

Chase Jumping Ability - Column 50. The horse's chances of getting around today's course.

WRITE IN RESULT HERE - This will always be the pentultimate column of the CSV file. This column, by request has been inserted so that tools have a target in which to insert the horse's position.

WRITE IN S.P. HERE - This will always be the last column of the CSV file. This column, by request has been inserted so that tools have a target in which to insert the horse's starting price.

Note that the last two mentioned colums will always be the last two in the CSV file. This won't be any problem to any developer, once informed, if the Columns.Count and Columns.Count - 1 are used to determine these columns rather than absolute index numbers. It would be preferable if the names of the columns were used rather than index numbers in any case.

Please check the documentation for the language which you use. We recommend using ADO or using COM using Excel as a server.