soccer betting odds archive files
SOCCER BETTING ODDS
ODDS ARCHIVE FILES ~ Types, Layout and Formats 

Four types of betting odds files are summarised below.
 ( bracketted letters identify files on secure order form )
  WEEKEND & MIDWEEK COUPON FILES  ( A,B,C,D,E,F ) 
  LEAGUE MATCH FILES   ( H, I ,J, K and L )
  HALF-TIME / FULL-TIME FILES   ( N, O, P, Q and R )
  CORRECT SCORE FILES   ( T, U, V, W and X )
The column layout and headings of each file type are as described below.
The files are available in the formats listed and are suitable for analyses
in spreadsheet and database applications.
Extracts from individual files plus links to prices and ordering opposite. 
WEEKEND COUPONS ONLY 1997-98 and 1998-99
ALL SEASON'S COUPONS from 1999-00 to 2002-03
Home, Draw and Away long-list and correct score odds.
Five UK bookmaker's odds in traditional & decimal format.
Files give match date and coupon line number.
Also coupon date, which is a Saturday ( weekend coupons )
or a Wednesday ( for midweek coupons ).
For seasons 1997-98 and 1998-99 only weekend coupons
are included. For all subsequent seasons all of that season's 
football coupons are covered. 
Weekend and Midweek coupons appear on separate files. 
Matches are shown as league, cup or internationals.
Includes every match which appears on football coupons.
The full-time score is given. The 1997-98 file includes Tote.
Replaced by SuperSoccer in all later files.
The other bookies are Coral, Hill, Ladbrokes and Stanley.
Up to 19,000 records in a full season's coupon files.
View a file here.... COUPON FILE EXTRACT
  
Coupon file names are .....
A ~ WE9798   B ~ WE9899   C ~ WE9900 and MW9900
D ~ WE0001 and MW0001   E ~ WE0102 and MW0102
F ~ WE0203 and MW0203
.... with the appropriate file extension ( .csv, .wdb, .xls, etc)
   
Coupon odds files are in these formats .....
CSV = Comma Separated for spreadsheets
WDB = MS Works 2.0 Database and later
WKS = MS Works 2.0 Spreadsheet and later
XLS = MS Excel vers 3.0 and later
MDB = MS Access vers 7.0 and later
  
  
   return to top of page 
____________________________________________		 Layout of Coupon files .....
idx = record index number 
bk = five major UK bookmakers : Coral, Hill, Ladbrokes,
  Stanley and Tote or SuperSoccer ( C, H, L, S & T or U )  
c-date = date of bookies' football coupons ( dd/mm/yy )
   ( Saturday or Wednesday )
c-no = number of the match as on the bookie's coupons
played = date of match ( yyyymmdd )
h-odds = home win odds traditional format ( eg 9/4 )
h-dec = home odds in decimal format ( eg 3.250 )
h-div = home team division
   ( enP=England Premier, sc1=Scotland One, etc )
h-team = home team name
d-odds = draw odds traditional format
d-dec = draw odds in decimal format
a-div = away team division
a-team = away team name
a-odds = away win odds traditional format
a-dec = away odds in decimal format
res = result as H=home, D=draw, A=away, P=postponed
h-gls = home team goals scored
a-gls = away team goals scored
s-odd = correct score odds in traditional format
s-dec = correct score odds in decimal format
lc  = league, play-off, cup or international match
  
____________________________________________
   
LEAGUE MATCH FILES for 1998-99 to 2002-03
All English and Scottish LEAGUE matches for each season.
( coupon line numbers & non-league games not included ).
The League files cover three betting options for the season.
Long-List, Half-time/Full-time and Correct Score odds.
Five bookmakers with odds in traditional & decimal format.
Odds for Coral, Hill, Ladbrokes, Stanley and SuperSoccer.
Every league match in the season is listed in date order.
Home, Draw and Away odds with bookie's over-round.
HTFT and Correct Score odds are for the actual results.
Files show match date and list full-time and half-time score.
  
The LEAGUE MATCH FILE is a general purpose file with    
a full range of bookmaker's long-list, correct score and
half-time/full-time prices with scores and dates.
Analyse 14,000 indexed records in each League file. 
Ideal file if you do not require cup and international data.
  
League file names are .....
H ~ LG9899   I ~ LG9900  
J ~ LG0001    K ~ LG0102    L ~ LG0203
 .... with the appropriate file extension ( .csv or .xls )
Files are identified with the letters I and J when ordering.
  
League Match odds files are in these formats .....
CSV = Comma Separated for spreadsheets
XLS = MS Excel vers 3.0 and later
  
  
  return to top of page 
_____________________________________________		 Layout of League Match files .....
 index = record index number ( over 13,000 in total )
bk = five UK bookmakers : Coral, Hill, Ladbrokes,
    Stanley, SuperSoccer ( C, H, L, S and U )
played = date of match ( yyyymmdd )
div = English or Scottish League division
    ( e0=England Premier, s1=Scotland One, etc )
h-odds = home win odds traditional format ( eg 9/4 )
h-dec = home odds in decimal format ( eg 3.250 )
h-team = home team name
d-odds = draw odds traditional format
d-dec = draw odds in decimal format
a-team = away team name
a-odds = away win odds traditional format
a-dec = away odds in decimal format
o-rnd% = bookie's over-round for long-list ( eg 111.94%)  
ft-res = full-time result as H=home, D=draw, A=away
h-ft-gls = full-time home team goals scored
a-ft-gls = full-time away team goals scored
fts-odds = traditional correct score odds for ft score
fts-dec = correct score odds in decimal format for ft score
ht-res = half-time result as H=home, D=draw, A=away 
h-ht-gls = half-time home team goals scored
a-ht-gls = half-time away team goals scored
htft-res = half-time/full-time result as HH, HA, DD, etc
htft-dec = half-time/full-time decimal odds for htft result
  
_______________________________________________
 
HALF-TIME FULL-TIME FILES 1998-99 to 2002-03
 HTFT ( double results ) odds for the nine possible results.
These are all LEAGUE matches in England and Scotland.
Decimal odds are for every league match in the season.
Odds for HH, DH, AH, HD, DD, AD, HA, DA and AA
( where H=home, D=draw, A=away ..... at half and full time ).   
The actual half-time and full-time scores are listed.
Every league match in the season is included in date order.
Bookies are Coral, Hill, Ladbrokes, Stanley, SuperSoccer.
Around 14,000 records in each HTFT file. View an extract
from a file here.... HTFT FILE EXTRACT
  
Half-Time Full-Time file names .....
N ~ HTFT9899    O ~ HTFT9900   
P ~ HTFT0001   Q ~ HTFT0102   R ~ HTFT0203
 .... with the appropriate file extension ( .csv or .xls )
  
Half-Time Full-Time files are in these formats .....
CSV = Comma Separated for spreadsheets
XLS = MS Excel vers 3.0 and later
  
  
  return to top of page 
 ______________________________________________		 Layout of Half-Time Full Time files .....
b = five major UK bookmakers : Coral, Hill, Ladbrokes,
    Stanley and SuperSoccer ( C, H, L, S and U ) 
played = date of match  ( yyyymmdd )
div = English and Scottish League divisions
    ( s0=Scotland Premier, e1=England One, etc )
home-team = home team name
away-team = away team name
ht-hg = half-time home team goals scored
ht-ag = half-time away team goals scored
ht-res = half-time result as H=home, D=draw, A=away 
ft-hg = full-time home team goals scored
ft-ag = full-time away team goals scored
ft-res = full-time result as H=home, D=draw, A=away 
htft = half-time/full-time result which is shown as
     HH, DH, AH, HD, DD, AD, HA, DA or AA
htft-odds = half-time/full-time decimal odds for htft result
further nine columns giving decimal odds for...
     HH, DH, AH, HD, DD, AD, HA, DA and AA
o-rnd% = bookie's over-round for the nine prices
  
__________________________________________       
 
CORRECT SCORE FILES for 1998-99 to 2002-03
The CS file provides odds for 24 possible scores per match.   
These are all LEAGUE matches in England and Scotland.
Final score odds in both traditional and decimal format.
Lists the full-time score and date of play of each match.
Bookies are Coral, Hill, Ladbrokes, Stanley, SuperSoccer.
Around 14,000 records in each of the CS files.
CORRECT SCORE FILE EXTRACT
  
Correct Score Odds file names .....
T ~ CS9899    U ~ CS9900   
V ~ CS0001   W ~ CS0102   X ~ CS0203
 .... with the appropriate file extension ( .csv or .xls )
  
Correct Score files are in these formats .....
CSV = Comma Separated for spreadsheets
XLS = MS Excel vers 3.0 and later
  
  
  return to top of page 
 _________________________________________________		 Layout of Correct Score files .....
b = five major UK bookmakers : Coral, Hill, Ladbrokes,
    Stanley and SuperSoccer ( C, H, L, S and U ) 
played = date of match  ( yyyymmdd )
div = English and Scottish League divisions
    ( s0=Scotland Premier, e2=England Two, etc )
home-team = home team name
away-team = away team name
ft-res = full-time result as H=home, D=draw, A=away
ft-hg = full-time home team goals scored
ft-ag = full-time away team goals scored
cs-odds = correct score odds traditional format ( eg 7-1 ) 
cs-dec = correct score odds in decimal format ( eg 8.00 )
further twentyfour columns
with decimal odds for.....
Homes : 1-0, 2-0, 2-1, 3-0, 3-1, 3-2, 4-0, 4-1, 4-2, 5-0
Draws :  0-0, 1-1, 2-2, 3-3
Aways : 0-1, 0-2, 1-2, 0-3, 1-3, 2-3, 0-4, 1-4, 2-4, 0-5
  
_________________________________________________

www.mabels-tables.com