Note: This post is about an optional add-on spreadsheet for the Results Summary Spreadsheet.
Note: This post is only relevant to purchasers of Results Summary Spreadsheet with betfair accounts more than 3 months old and who want access to all of their historic betting data (maybe years or decades worth).
There’s a problem…..and a solution!
Problem
Whilst Betfair offer up to 3 months of betting Profit and Loss data download from "My Account" area on their website as a file called 'BettingPandL', if you require any more than that then you need to contact their helpdesk. They will provide a report of the entire betting results on your account since opening, if you ask nicely! However, their report format is different to 'BettingPandL' and has also recently changed.
I’ve had a number of purchasers of the Results Summary Spreadsheet recently contact me with news that Betfair will no longer provide their customers with the lifetime P&L report in the original format. Betfair support have stated to a number of customers that it is not possible for them to provide the old format report anymore, after many years of doing so.
The new format report that Betfair provide, titled “Betfair Customer Report” (or "Statement") looks like this:
Betfair Customer Statement (identifying information has been removed) |
1. Each row is an individual bet result, before commission is deducted. The original report had the total P&L net of commission on each row for every market (e.g. horse race, football match odds).
2. The sport name isn’t stated. This is a big omission that is needed for the Results Summary Spreadsheet to help you understand your P&L by sport. Adding in the sport name manually is problematic as most customers using this will have several thousand bets on their account!
Solution
Convert Betfair Customer Report - showing unfiltered results with 98% of sports auto-identified and the remainder highlighted |
I’ve created a new spreadsheet called, “Convert Betfair Customer Report” {snappy, heh?!}. This largely solves the problems created by Betfair’s new report format:
- The new conversion spreadsheet sums up the exchange bets and deducts the commission to provide the net of commission P&L for each market, as per the original format report.
- The new conversion spreadsheet analyses the bet data and can automatically identify and enter the sport for the vast majority of bets so you will save potentially hours or days of time.
- This varies by sport – for horse racing and greyhound racing it will add in the sport for virtually all records. It will also identify football bets for all non-international games involving English teams and most European teams. Other identifiers are used, e.g. goals, frame, and leg for football, snooker and darts.
- The remainder needs to be manually entered by you but this should only take 5-20 minutes depending on your data and variety of bets. The spreadsheet is set-up to make this data-entry easier. It also identifies bets of team vs team or player vs player which helps narrow it down for you.
Results cannot be guaranteed, however what we’ve experienced so far has been as high as 98% of all markets auto-identified with the lowest score still being a whopping 92%! Results will depend on how many different sports you’ve bet on and how obscure they are. Even so, if you’ve only bet on the horses and volleyball then any bets not identified are likely to be volleyball and after a quick check you can copy them down in one go. Simples!
The results can then be exported with a click and imported into the Results Summary Spreadsheet in one go (Results Summary Spreadsheet is available separately here).
Only £4.97
(How many hours / days will this save you?)
1. Settled Date2. Details - Event name; betting market,
e.g. "Leicester 15th Nov; 15:30 2m4f Hcap Hrd"or "Man Utd v Man City; Over/Under 3.5 Goals"3. Either:
- Deposit (winning bet payout, number) AND Credit (losing bet amount, number)
or
- Amount (single column showing winning bets as a positive number, losing bets as a negative number)
Requires Excel 2010 or newer for Windows Please check the detailed software requirements below for use of this spreadsheet before buying. |
Software requirements (not included!):
WILL NOT work on any operating system other than Windows.
Here's the 'How to' video for using the conversion spreadsheet: