Betfair Historical Data Analysis DB
$30-250 USD
货到付款
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
项目ID: #4307219
关于项目
授予:
有8名威客正在参与此工作的竞标,均价$266/小时
Hi, I have 12 years experience developing MS Access applications and could do this project for you, to your satisfaction. Please view my portfolio for some examples of my work.
I have 15 years exp in access design and development. I have built hundreds of datatbases; many linking to spreadsheets. Thanks Donna
can provide you reliable database plus front-end application for scrapping and having centralized data-repository