Betting Account Performance Breakdown

Excel Analytics Data Cleaning Data Analysis Dashboard Reporting
2023

Results (mock data)

+60% ROI above 12-month average
+47% Picks volume above 12-month average
+110% Total P/L from odds bucket 1.5–1.99 in December
~2/3 Of all picks were handicap bets

Objective

Track and analyse betting account performance for a Value Betting Syndicate, producing weekly reporting across key metrics: ROI, hit rate, picks volume, P/L, average stake, and average odds. Each metric compared against the 12-month average to surface meaningful trends rather than absolute numbers.

The published version of this project uses a mock dataset, not real account data.

Approach

Raw betting data required significant processing before any analysis was possible. 11 steps from raw to clean: separating datetime into date and time, refining column labels, standardising odds format, cleaning the selection column, standardising bet type and result values, extracting market information, calculating P/L, flagging live bets, calculating any omitted data, creating odds buckets, and classifying market categories.

Analysis was built on pivot tables, with an interactive dashboard featuring filters for Market Category, Bet Type, Odds Group, and Calendar Month. Monthly growth visualisation included.

Key findings

  • ROI was 60% above the 12-month average for the period analysed
  • Picks volume was 47% above average, indicating a higher-volume period
  • Handicap bets were responsible for most P/L and approximately two-thirds of all picks
  • Odds bucket 1.5–1.99 in December returned 110% of total P/L for the period
  • Hit rate, average stake, and average odds were all around the 12-month average
Raw betting data before processing, showing the unstructured source format
Raw data before processing
Betting data after all 11 cleaning and processing steps, ready for analysis
Cleaned and processed data
Pivot table showing betting account performance metrics including ROI, hit rate, picks volume, P/L, average stake, and average odds
Pivot table analysis
Performance metrics chart comparing key indicators against the 12-month average
Performance metrics
Interactive Excel dashboard overview showing overall betting account performance
Dashboard overview
Dashboard view filtered by market category, showing P/L and volume breakdown across bet types
Dashboard — market category breakdown
Dashboard view showing performance analysis broken down by odds bucket, highlighting the 1.5–1.99 range
Dashboard — odds bucket analysis
Walkthrough of the cleaned dataset