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