‘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?)
Buy Now

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 WindowsExcel 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:



New 'filter by sport' control on 'Total by Sport' tab (Results Summary Spreadsheet v3.3.4)

There's a major update to the 'Total by Sport' tab which includes:

  • 'Filter by Sport' control which controls all three tables
    • Select one or several sports
    • Exclude one or several sports
    • All sports
  • New third table showing market type information by sport
  • New 'expand' button and 'Toggle sort column' button to sort the table either by profitability or alphabetically by market type
  • This tab is now similar to the 'My Sport' tab but can be switched to a different sport with a single click.  The 'My Sport' tab is intended for your favourite other sport that you want setup more permanently for review. 
  • The chart previously on this tab has been moved to the 'Graphs' tab
'Football' selected on the new 'Filter by Sport' control

The latest version released today (v3.3.5) added a daily market count on the central table of the 'Summary' tab and this is also shown graphically on the 'Graphs' tab.  Check out the updated screenshot here.

Previous purchasers of v3 of the spreadsheet have already been emailed with their free update details.

If you are a prior purchaser of v2 of the spreadsheet then you can upgrade for 50% off the full priceClick here to find out how.

To find out more about the whole spreadsheet click here.

p.s. Happy 4.3.21 !


Benefits of analysing your P&L easily with Results Summary Spreadsheet

'Horse Racing' tab in the Results Summary Spreadsheet (v3)


Many thanks to all the current purchasers of the Results Summary spreadsheet!  It would be great to hear more from traders and gamblers who've used it to improve their profits.

For me, I was haemorrhaging money on flat races (in-play trading) which I wasn't aware of - a classic gambler's case of remembering the big wins and forgetting all the losers! Because I was only looking at the overall P&L things looked good.  I also had a major "leak" on maiden hurdles at certain courses (in-play trading). Both these problems were very easy to see once I developed this functionality in the spreadsheet - at the press of a button your horse racing P&L is split between flat and jumps, you can then see splits by racecourse, distance, race type, date and you can also filter all of these.  For example, you could see all the maiden hurdle races split by racecourse, or distance, sorted by profitability.  The flexibility is really great and enables you to see what's really going on.

Results Summary Spreadsheet v3 is here!

Easily track and analyse your Betfair and Betdaq exchange trading and betting

View your P&L performance over the lifetime of your accounts, find trends, find your best - and worst - market types and shape your future decisions.

Your lifetime results presented in an easy to understand format just one click away.

'Summary' tab (v.3.3.5 showing daily markets count)

See the video here.

'Summary' tab

The heart of the spreadsheet.  

See and understand your Betfair and Betdaq profit & loss data like never before:

  • At a glance your all-time P&L with charts throughout the spreadsheet revealing trends
  • See your all-time P&L by month, week, date, day of week, time of day
  • Drill-down on any date to see more details by:
    • Sport
    • Racecourse / track / team (depending on the sport)
    • Market type
  • New modern design.  New 'hide' button which removes all controls from view to give even more screen space for your results analysis

New in v3 (upgraders from v2 see this post)

  • FootballSee your results by:
    • Match / Team
    • Market type, e.g. Match odds, over/under, tournament betting
    • Click on match or market type to see market information
'Football' tab

  • Horse Racing:
    • Race type
    • Distance (in furlongs)
    • New third table showing results by racecourse which can be sorted by P&L or racecourse.
    • Click on race type or distance or racecourse to see market level information
    • Horse racing split by jumps, flat, place market.  Can be toggled to show total for all horse racing
    • Foreign racetracks now include the country code with the course name
'Horse Racing' tab

  • 'My Sport' user definable tab:
    • This is a new concept in the spreadsheet for a dedicated user-definable sports tab
    • Are you a big Tennis, Darts, Cricket or MMA fan? Done!  
    • You can even analyse Special Bets such as the X-Factor!
'My Sport' tab (Snooker selected)

  • Greyhound racing.  See your results by:
    • Race grade (e.g. A1, A2, S1, OR etc)
    • Distance (in metres)
    • Track
    • Click on race grade or distance or track to see market level information
    • Foreign tracks include the country code with the track name
'Greyhound' tab


Further analysis for ALL sports

  • 'Total by Sport' tab. See your results by:
    • Sub-total by every sport you have results for in a chart and accompanying table
    • Horse racing split by jumps, flat, place market.  Can be toggled to show total for all horse racing
    • Monthly total broken down by each sport
'Total by sport' tab

  • 'Running totals' tab:
    • Your P&L running total split out by sport
    • Timescale can be easily filtered to current year, current quarter, last quarter etc.
    • Sports can be easily filtered to only your results you are interested in, or all
    • Horse racing split by jumps, flat, place market.  Can be toggled to show total for all horse racing
'Running totals' tab

  • 'Graphs' tab:
    • P&L running total for all sports (as per the 'Summary' tab graph, just larger)
    • Average profit by market vs average loss by market each day. See this post for more about how this is useful.
    • Daily strike rate across markets
    • Timescale can be easily filtered to current year, current quarter, any range of dates
'Graphs' tab

  • 'Month comparison' tab
    • P&L running total comparison by month
    • Timescale can be easily filtered to current year, last year, etc.
'Month comparison' tab (showing past three months only)

How to use your P&L analysis information

BUT! This spreadsheet isn’t just about keeping a record of your trading using tables and graphs. It’s been developed over several years to help with becoming a more profitable and consistent trader.  I wanted to find out how to have less risk, less stress, less wasted time and more profit.

Of course you need to adapt your trading according to what you find out and the spreadsheet does not give betting advice.  There’s a saying I really believe in which states, “If you keep doing what you've been doing you'll keep getting what you've been getting”.  Only about 5% of Betfair customers make a long-term profit and that’s mostly very small.  If you can take responsibility and own the fact that the results you see are because of the actions you’ve chosen to take, it means that you are in control.  Find what aspects of your trading are working and hammer them hard!  Reign back the stuff that’s increasing your losses.  Simple, eh?!, so how come most people aren’t doing it?  

How does it work?

Download your Betfair 'BettingPandL' file or Betdaq P&L file then simply click 'Import'.  Simples!

New conversion spreadsheet allows you to import the Betfair Customer Report / Statement with your entire lifetime Betfair exchange P&L results (i.e. more than 3 months worth of data).  This is to get around the 3-month limit Betfair has for the standard P&L download.  See this post for more info.

General
  • Keep your P&L results private NO uploading your results to someone else's website
  • Fully compatible with Betfair altered file format of 'BettingPandL' (changed in summer 2020)
  • OneDrive: Keep your data backed up in your OneDrive, now supported in v3
    Betdaq P&L
    • Horse racing markets automatically separated from other sports (where Betdaq state the racecourse in the P&L file)
    • Horse racing summaries by win, place and each-way market results
    • Racecourse totals (where available)
      YouTube Videos

      All the best with your trading!

      _______________________________________


      Click on the 'BUY NOW' button for an instant download of the spreadsheet
      See below for software requirements
      Only £9.97
      (How quickly will you make that back?)
      Buy Now

      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.

      New conversion spreadsheet (available separately) allows you to import the Betfair Customer Report with all your betting history (for those with more than 3 months of betting history).
      For more information on this check out this post.

      Price includes free access to future updates e.g. v3.3 to v3.4 etc
      (upgrades apply to new versions e.g. v2 to v3)
       
      v2 Purchasers should check out this post for a special upgrade discount!
      Requires Excel 2007 or newer for Windows  
      Please check the detailed software requirements below for use of this spreadsheet before buying.
      _______________________________________

      Software requirements (not included!):
      Excel 2007* or newer for Windows. Tested on XP, Vista, Windows 7, Windows 8 (see note below about Windows 7 and 8) and Windows 10.  

      Works on Excel 365 for Windows.

      WILL NOT work on Excel 2003 and older, Open Office or Excel for Macintosh.

      *Excel 2007 users - please email me AFTER your purchase for an additional file you will need.


      International users may have to alter their Regional settings due to Betfair spelling out the dates in English text format within the BettingPandL file even for non English-speaking countries. In Windows 10 click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In Windows 7 & 8 go to Windows start button > Control Panel > Regional and Language Options > Formats (tab) - Current format and set to "English - United Kingdom".  See this post Using your Language and Currency format

      Windows 7 & 8: There is a security scan in Windows 7 & 8 which can prevent 3rd party Excel files such as the Betfair P&L file from being opened.  When trying to open the Betfair P&L file in excel you will get the error message,"Run-time error '1004': Method 'Open' of object 'Workbooks' failed".  Please download a Betfair P&L file and make sure you can open it before purchasing the 'Results Summary' spreadsheet. If you are using Windows 7 / 8 you can open the Betfair P&L using Open Office (free software) - then by saving it without any changes it can be opened by Excel under Windows 7 /8.  Equally, if you have access to another PC with XP or Vista you can re-save the file before transferring it to your Windows 7 / 8 PC.  This is a known issue which Microsoft have no plans to rectify http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf

      Windows 10: The issue described above with Windows 7 & 8 does not occur with Windows 10.  You can download the BettingPandL file from Betfair and directly open it in Excel. Happy days!


      Once downloaded, no refunds will be given under any circumstances, please make sure you have the right Excel software and can open the BettingPandL file downloaded from Betfair.

      All rights are reserved by the author.

      All the best with your trading!
      Mind Games

      Check out the blog comments for Results Summary v2 here