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


      37 comments:

      1. there does not seem to be an option to enter the discount code?

        ReplyDelete
      2. Hi Gerald, Please see this post for previous purchasers upgrading from v2: click here

        ReplyDelete
      3. Hi, i take it this still doesn't work for macs?

        ReplyDelete
        Replies
        1. Hi, I'm checking for you. I need to upgrade my (old) mac first. Will get back to you as soon as I can. Are you using Office/Excel 365?

          Delete
        2. It looks like it might now be possible to make it work, prior to Excel 2016 it wasn't possible. It will be a fair bit of work but great if I can get it running. Check the comments for an update, I'll let you know either way probably next week. WHICH VERSION of Excel are you using?

          Delete
        3. Hi, im using 365. Thanks that would be great i'll keep an eye out in comments

          Delete
        4. Thanks for you reply. Will get back to you.....

          Delete
        5. Hi, It's not possible for me to do this at the moment, sorry.

          Delete
        6. Update: There are a few other possibilities but you will incur extra costs in addition to Excel for Windows:
          * Run a virtual PC on your Mac (e.g. Parallels), I haven't done this myself but you can get a free trial to check it out.
          * Rent a VPS (virtual private server). Some traders already have a VPS for their automated betting strategies so there'd be no extra cost other than Excel for Windows. I've done this myself so I know it can work.
          * Microsoft are trialling a browser-based Windows PC which you should be able to run from any device with a browser. I've not used this so I can't be sure it'll work but there's a free trial https://www.microsoft.com/en-gb/windows-365

          Delete
      4. Proper record keeping has been a thorn in my side ever since I started football trading and this has solved it at a very reasonable cost. Many thanks

        ReplyDelete
      5. Hi, that's great to hear! Thanks.

        ReplyDelete
      6. Hi mind games , can the spread sheet be opened with libro office ?

        ReplyDelete
      7. Hi, Unfortunately I really doubt it, I'd say no. Excel macros are not compatible with Open Office or even Excel for Mac which is a shame Microsoft don't do this! Thanks for asking.

        ReplyDelete
      8. Hi is this compatible with Mac excell ?

        ReplyDelete
        Replies
        1. Hi, Unfortunately Microsoft don't make the macro's in Excel 100% compatible in the Excel for Mac version, so, no, the spreadsheet isn't compatible.
          There are a few other possibilities but you will incur extra costs in addition to Excel for Windows:
          * Run a virtual PC on your Mac (e.g. Parallels), I haven't done this myself but you can get a free trial to check it out.
          * Rent a VPS (virtual private server). Some traders already have a VPS for their automated betting strategies so there'd be no extra cost other than Excel for Windows. I've done this myself so I know it can work.
          * Microsoft are trialling a browser-based Windows PC which you should be able to run from any device with a browser. I've not used this so I can't be sure it'll work but there's a free trial https://www.microsoft.com/en-gb/windows-365

          Delete
      9. For a guy who went to school in short trousers with a Satchel and Abacus this form is a game changer.
        My reasonable skills with Excel have been taken to a new world. So simple to use I can filter events to days, race, market, type of race and that’s just for Horse racing.
        I’ve been able to review my football markets to focus on which day and what market is best, a real game changer.
        Not since man U resigned Ronnie has my trading taken a more positive direction.
        Support to get up and running was great as well and the best few quid I have spent in ages.
        I would /have recommended this to anyone trading will save you hours
        Thanks

        ReplyDelete
      10. Ha ha nice school story! Thanks very much for your comments on the spreadsheet, that's great to hear you're getting the full benefits.

        ReplyDelete
      11. Is there a way to enter rades manually? I am using Smarkets and would like to consolidate my data.

        ReplyDelete
        Replies
        1. Hi, you'd have to create a .csv file in identical format to betfair. Best off using Notepad rather than excel. Open an existing bettingpandl file to see what's needed.
          I may be able to add Smarkets capability to the spreadsheet. Can you send me their P&L file? Change your P&L figures by all means but dont alter the formatting at all.
          Cheers MG

          Delete
      12. £9.97 for this is an absolute steal and should be raised! If you're reading this and the spreadsheet is £30 your still getting value! That £30 wouldn't even begin to cover the customer service excellence received from MG. Quick, considerate, caring and doing far more than the cost of the spreadsheet warrants. Trader or not this is the perfect spreadsheet for getting your Betfair account in order.

        ReplyDelete
      13. Thank you so much Jon, your praise is so high it nearly made me blush! I really appreciate it, makes the hard work worthwhile.

        ReplyDelete
      14. Brilliant spreadsheet. It's been invaluable in helping me analyse my results and tailor stategies accordingly.

        ReplyDelete
      15. I've been football trading for 4 years, do i need the above offer orthe newer version or both?

        ReplyDelete
        Replies
        1. Hi, Results Summary Spreadsheet is the main product. This enables you to easily and quickly review your P&L over time and to identify trends in your trading/gambling to help improve your results going forwards. Betfair only allow you to download your P&L for the past 3 months, this download file is called ‘BettingPandL’. So you can do this today and purchase the Results Summary Spreadsheet to analyse this data.
          As you have 4 years worth of betting data it would be preferable to have all of this data in the spreadsheet. You can contact betfair helpdesk to request your personal report, which they call ‘Betfair Customer Statement’ or ‘Report’ for your entire account history, however this is unfortunately in a totally different format to ‘BettingPandL’. This is where the ‘Betfair Customer Report Conversion Spreadsheet’ is useful – to help you convert your ‘Betfair Customer Report’ into the same format as ‘BettingPandL’ and then you can import your data into Results Summary Spreadsheet in one go. This spreadsheet is available as a separate purchase to the Results Summary Spreadsheet. Please read this post for more info and a video showing the required process (or click on the 'Betfair Report Conversion' tab at the top of the post): https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html

          Delete
      16. Hello Friend! I had purchased the v3 spreadsheet a while ago, how do I access updates? I have version v3.3.5.
        Big hug!

        ReplyDelete
        Replies
        1. Hi Wilker, All purchasers of v3 were emailed in December with the update details. Please check and whitelist/save my email address. Email me if you need further help. Thanks. MG

          Delete
      17. Como faço pra comprar a V3 Atualizada?!

        ReplyDelete
        Replies
        1. Oi. Você receberá automaticamente a versão mais atualizada da planilha ao comprá-la. Por favor, clique no botão 'Comprar agora'. Verifique primeiro os "Requisitos de software".

          Delete
      18. Without this spreadsheet, I don't think you can make any money betting. Amazing product! Thanks again for your hard work! G

        ReplyDelete
        Replies
        1. Thank you for your comment, it's great to hear!

          Delete
      19. Please note the current version is now v3.6.1. This has improved support for more languages and other minor tweaks.
        v3.6.1 update is free for all previous purchasers of v3.
        Previous purchasers of v2 can upgrade at 50% discount, please see https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html

        ReplyDelete
      20. If you are unable to write your own spreadsheet then this is the one for you. It really does open your eyes to where you are going wrong or right. It has saved me a fair few quid over the last couple of years.

        ReplyDelete
        Replies
        1. Thanks Grant, I love hearing how the spreadsheet has helped people and saved them money. Much appreciated!

          Delete
      21. Hi, I want to buy your product but i need to know if that works with office 365 on Web?

        ReplyDelete
      22. Hi, thanks for your interest in the spreadsheet. No, the web version of 365 doesn’t run macros so it won’t work. Only Excel on Windows will work. Please note you can use older versions of Excel which may be cheaper to buy. All purchasers should check the “System requirements” above before buying the spreadsheet.

        ReplyDelete
      23. sorry its taken me so long to get my comment up. Absolutely love this spreadsheet. Worth its weight in gold! Cant recommend enough to everyone.

        ReplyDelete
        Replies
        1. Hi N, Thanks for your comment. I always like to hear when it's helping people. Happy New Year!

          Delete