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