Betfair Historical Data Analysis DB

已完成 已发布的 Mar 6, 2013 货到付款
已完成 货到付款

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

微软Access SQL

项目ID: #4307219

关于项目

8个方案 远程项目 活跃的Mar 7, 2013

授予:

hegemon88

Please engage me for this and you will get it delivered in no time.

$95 USD 在3天内
(7条评论)
3.4

有8名威客正在参与此工作的竞标,均价$266/小时

MarlinSoftware

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.

$250 USD 在7天内
(23条评论)
5.5
kulhanekd

I have 15 years exp in access design and development. I have built hundreds of datatbases; many linking to spreadsheets. Thanks Donna

$250 USD 在5天内
(35条评论)
5.8
tawakalgeek

can provide you reliable database plus front-end application for scrapping and having centralized data-repository

$325 USD 在15天内
(6条评论)
3.8
srdas2012

Hi Please check PMB

$300 USD 在7天内
(3条评论)
2.7
zoltannagy

Hi, PhD in engineering here, let's talk!

$500 USD 在14天内
(0条评论)
0.0
fahmidaward

I can start right now. Please read the private email.

$90 USD 在3天内
(0条评论)
0.0