ANLY482 AY2016-17 T1 Group2: Project Findings

From Analytics Practicum
Revision as of 03:32, 4 September 2016 by Hpchang.2013 (talk | contribs) (Created page with "<!-- Start Logo --> <br /> <!-- End Logo --> <!-- Start Navigation Bar --> {|style="background-color:#2196F3; font-family:sans-serif; font-size:140%;" width="100%" cellspacin...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Home

Team

Project Overview

Project Findings

Project Management

Documentation


Datasets

The dataset provided by Singapore Pools are

  1. Profit & Loss (P&L) by Book
  2. Timetables of the matches
  3. Leagues & Tournaments

They are presented in the form of excel sheet and contains 52 unique tournaments over the time span of 7 years (2010 to May 2016). The parameters of the dataset are as followed:

Profit & Loss (P&L) by Book

Parameters Description
Book Date (settlement time) The official time and date (after the end of the match) for the payout of the bet placed. For example, 9/1/2010 4:01:00 PM
League Name The name of the league. For example, A LEAGUE and ASIAN CHAMP
Book Title The title of the match. For example, 4501 Wellington v Brisbane Roar and 4502 Central Coast v Queensland Fury
Bet Type The type of the bet. For example, 1/2 GOAL and HALF/FULL TIME DOUBLE
Winning Selection The winning bet type. For example, Wellington(-1.5) and Queensland Fury(1.5)
Total Stake The amount of payment collected.
Winning Payout The total amount of payout for the winning selection of the match.
Winning Liab The total winning liability (Total Stake - Winning Payout) of the match.
Total Bet Cnt The total count of the winning bet type.

Timetables of the matches

Parameters Description
League League name. For example, A league and ASEAN 8
Match No Unique identifier for the match on that day. For example, 4506 means A league on 1st december 2010
Match KickOff (Singapore date/time) Match kickoff time in Singapore (Singapore time). For example, 1/12/2010 4:00:00 PM (Singapore time) and 1/12/2010 7:00:00 PM (Local time)
Match KickOff (Local date/time) Match kickoff time at the host country (Local time). For example, 1/12/2010 4:00:00 PM (Singapore time) and 1/12/2010 7:00:00 PM (Local time)
Home Team Home team name.
Away Team Away team name.
Remarks Remarks for the timetable (if applicable).
Start of sales Start time of sales - normally 2 days before the actual match. For example, 1/12/2010 8:00:00 AM
Close of sales End time of sales. For example, 3/12/2010 1:55:00 AM

Leagues & Tournaments

Parameters Description
No. Unique identifier for the leagues. For example, 01 means S.League and 02 means Singapore Cup
League Name The name of the league. For example, S.League and Singapore Cup
Mnemonic Short form of the league. For example, SL means S.League and SC means Singapore Cup
Season # Season number.
Tournament Tournament country.
Other League Name Other name of the league. For example, English Premier is the same as E Premier
Remarks Remarks for the leagues and tournaments (if applicable).