Betfair lifetime results - how to make sense of them

I was contacted by the author of the excellent Mets Trading Diary blog asking about importing his lifetime Betfair P&L into his copy of Results Summary spreadsheet. 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....AND I'm giving it away for free with the Results Summary spreadsheet! 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.

I'll soon be making this conversion spreadsheet available to previous purchasers of Results Summary spreadsheet (for free), please bear with me.

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



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 (the above spreadsheet is included free in the bundle).

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