‘Betfair Customer Report’ conversion spreadsheet available for download

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)

This has two fundamental problems compared to the old lifetime P&L report report:

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:

1. 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.
2. 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).

_______________________________________

Click on the 'BUY NOW' button for an instant download of the spreadsheet

(DOES NOT include the Results Summary Spreadsheet!)

Only £4.97
(How many hours / days will this save you?)

View cart

IMPORTANT! Ask betfair for your Customer Report before purchasing the spreadsheet.  

Make sure it looks like the one shown above,

 it must include the following three / four columns:

1. Settled Date

2. 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)

The columns can be in any order and the heading names don't matter, it's the contents that matter.  

Any doubts then please email me, no refunds are available once you've downloaded the product.

See below for software requirements (different to Results Summary Spreadsheet)

No PayPal account necessary for purchase

Your card statement will show 'BTMG' as the merchant.

PayPal do not disclose your street address for this download-only purchase.

Price includes free access to future updates e.g. v1.0 to v1.1, v1.2 etc

(upgrades apply to new versions e.g. v2 to v3)

Price includes bundle with the original 'Lifetime' conversion spreadsheet.

 

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!):

Excel 2010 or newer for Windows. Excel 365 recommended (Windows version only).

Excel 2010 - Excel 2016 users will need to apply a FREE add-on from Microsoft which can be downloaded HERE.

WILL NOT work on Excel 2007 and older, Open Office or any version of Excel for Macintosh.

WILL NOT work on any operating system other than Windows.

_______________________________________

Here's the 'How to' video for using the conversion spreadsheet: