Betfair lifetime results - how to make sense of them

2021 update: The post below from 10 years ago refers to the old 'Lifetime conversion' spreadsheet which worked with the previous report that betfair used to provide.  It appears that betfair will not be providing the 'Lifetime' report going forwards.

Betfair have recently been providing customers with the 'Betfair Customer Report' or 'Statement' for their betting history.  This has two major problems compared to the original report.  See this post for more info and the new solution - ‘Betfair Customer Report’ conversion spreadsheet.  The original 'lifetime' conversion spreadsheet is also included in the bundle - in case betfair revert to the original report format!

_________________________________________________________________

Whilst Betfair offer up to 3 months of Betting Profit and Loss data download from "My Account" area on their website, if you require any more than that, then you need to contact the helpdesk at info@betfair.com or by phone.  They will provide a report of the entire "lifetime" P&L of your account.  I received mine in about 4 hours - and my account has been active for 10 years!  It's probably a good idea to contact them in the morning though to get such a quick response.

However, I was surprised to learn that Betfair will not provide this "lifetime" P&L report in the same format as the one you can download from your account area.  Confusingly, they don't seem to have a standard format either, as Mets & I initially got reports in totally different formats and level of detail. The key is to be specific what you ask them for (more on this below).

The good news is that I have developed a spreadsheet to convert the lifetime report into an identical format as the standard P&L report. The standard format means that you can then import your lifetime P&L into the Results Summary spreadsheet (as well as any other compatible system you may have, if you want).  Of course, going forwards, all your results are stored safely in the Results Summary spreadsheet and you won't need to ask for them from Betfair again - so long as you download your P&L at least once every 3 months.  

As all your data is downloaded to your computer, you keep your P&L results private - there is NO uploading to an anonymous 3rd party website.

So - what format do you need to get your lifetime report in?  Here's what the headings looked like on mine (just one row of data is showing):

Report from Betfair showing results across the account lifetime

The key points are that:
  1. The report must be at event level (i.e. total profit for a market, not each individual bet you placed on the market).
  2. It must have the following columns: "Event settled date", "Sport", "Event menu hint", "Event name - long", "Net p&l". Any additional columns do not cause a problem, they are ignored.  The column order of the report doesn't matter.
When you contact Betfair you could just copy and paste the above criteria into your email, maybe even include the screenshot.

It's really simple to use the conversions spreadsheet, here's what it looks like:


You can buy the Results Summary spreadsheet here.

If, like me, you've had results in the past that you'd rather forget about (!), it needn't be all bad. This experience has actually been useful for me to also remember all the profitable periods I've achieved over the lifetime of my account.  I tended to only remember the bad ones!  I've actually found it quite positive to know for sure which areas I've won at over time and to have continuing confidence with those whilst reminding myself why I'm avoiding others.

I hope you find this useful too.  Cheers!

5 comments:

  1. as always, great tool!!!

    ReplyDelete
  2. Is possible, that they do not want to provide me this type of lifetime results?

    They always send me lifetime profit only for whole sports, not for individual events...

    Can you tell me where I have to send mail and what to tell them?

    Because Czech support really do not understand my requests...

    Thanks for reply!

    Tomas

    ReplyDelete
  3. Hi Tomas,

    I think you just need to keep asking! It seems to be a little random as to exactly which report they use, the impression I get it that they have so many different ones that maybe it's hard to find the right one!

    Are you emailing cesky@betfair.com or info@betfair.com ? Maybe try the English helpdesk if Czech support don't understand exactly what you want.

    Have you tried attaching the screenprint of the report from my blog post? That should help them. I recommend you contacting them early in the morning when they are not busy!

    Let me know how you get on. MG

    ReplyDelete
  4. yea keep trying, this was my 5th time when i sent this to them:

    Hello, my name is xxx (username: xxx ) and i would like to get my profit&loss from xxx to xxx in this format:


    http://3.bp.blogspot.com/-q7WL5tIzK2Y/TltqRN-_VOI/AAAAAAAAAE8/9iecKwGVAow/s1600/Username+lifetime+report.gif


    The key points are that:
    The report must be at event level (i.e. total profit for a market, not each individual bet you placed on the market).
    It must have the following columns: "Event settled date", "Sport", "Event menu hint", "Event name - long", "Net p&l". Any additional columns do not cause a problem, they are ignored. The column order of the report doesn't matter.



    And they still sent me the profit by day not race... but im gonna still try :D

    ReplyDelete
  5. Hi Anon, yeah I know it can take more than one request :( don't know why it's taking so long for you. Are you dealing with UK helpdesk? Tom had a problem getting the report from Czech helpdesk but UK did oblige. Best of luck! MG

    ReplyDelete