Betfair Historical Data Analysis DB

Import Weekly Horse Racing Spreadsheets from Betfair

[login to view URL]

Be able to easily import additional spreadsheets as they are released to Normailsed DB.

Form Needed to;

Click to import Spreadsheet

Select Countries

Select Course

Select Odds Range

Select Date Range

Select InPlay State

Query 1 - Score;

Be able to run a query that will show if a selected odds range will produce a positive or negative score.

e.g. 1:

Selected Countries = GB

Selected Course = Exeter

Selected Odds Range= 1.1 to 2.1 (Use only the last time stamp in Latest Taken Date/Time)

Selected Date Range= 01/11/2011 to 01/12/2011

Selected InPlay State = Pre Event

e.g. 2:

Selected Countries = All

Selected Courses = All

Selected Odds Range= 9.0 to 15.4 (Use only the last time stamp in Latest Taken Date/Time)

Selected Date Range= All

Selected InPlay State = Pre Event/No In PLay

Query 1A;

Score 1 = A minus B (see point calculation)

Query 1B;

Score 2 = C minus D (see point calculation)

Score 3 = E minus F (see point calculation)

Point Calculation;

A) Selection ID using Newest Time Stamp of "Latest Taken Odds" field where "Win Flag (0)" = Point Value of 1.

B) Selection ID using Newest Time Stamp of "Latest Taken Odds" field where "Win Flag (1)" = Point Value of (Newest Time Stamp of "Latest taken Odds" for that selection)-1

e.g. 4.2-1=3.1

C) If a Selection ID does not have odds within the range at the Newest time stamp, check if the odds had been within the specified range at any time and use the Oldest time stamp when they were in range.

Selection ID using Oldest Time Stamp when odds were within specified range in "Latest Taken Odds" field where "Win Flag (0)" = Point Value of 1.

D) If a Selection ID does not have odds within the range at the Newest time stamp, check if the odds had been within the specified range at any time and use the Oldest time stamp when they were in range.

Selection ID using Oldest Time Stamp when odds were within specified range in "Latest Taken Odds" field where "Win Flag (1)" = Point Value of (Oldest Time Stamp of "Latest taken Odds" field for that selection)-1 e.g. 4.2-1=3.1

E) If a Selection ID does not have odds within the range at the Newest time stamp, check if the odds had been within the specified range at any time in the Event and use the Newest time stamp when they were in range.

Selection ID using Newest Time Stamp when odds were within specified range in "Latest Taken Odds" field where "Win Flag (0)" = Point Value of 1.

F) If a Selection ID does not have odds within the range at the Newest time stamp, check if the odds had been within the specified range at any time in the Event and use the Newest time stamp when they were in range.

Selection ID using Newest Time Stamp when odds were within specified range in "Latest Taken Odds" field where "Win Flag (1)" = Point Value of (Newest Time Stamp when odds were in range in "Latest taken Odds: field for that selection)-1 e.g. 4.2-1=3.1

Microsoft Access SQL

Project ID: #4307219

About the project