Unlocking the secrets of your P&L data by customising Results Summary

An email from a purchaser of Results Summary spreadshee asked to be able to analyse their P&L by course in the "Horse racing - type & distance" tab in a similar way that it works for race type and distance. Rather than just adding another table to do this I thought it would be more powerful to show all purchasers how to customise and manipulate their spreadsheet in even more ways.

Note: Horse racing P&L shown by racecourse is now built-in to v3 of the spreadsheet, please see this post.  

The method shown below can still be used if you have other requirements for analysing your data.

This means you can set up your P&L results to display exactly how you want, and as before, you keep your P&L results private - there is NO uploading your results to someone else's website.

I hope that this is quite a revelation for those who want to look at their results from new angles and perhaps inspire new strategies.

Please make a backup of your spreadsheet before you try any of the techniques in the video! You've been warned! For instance, if the "Market type" field is moved up from the bottom of the hierachy you will get an error message (Run-time '1004') when pressing the "Collapse all drill downs" button. So it's best if you copy over a fresh version of the table first (as shown near the end of video "part 2").

Whilst I hope you enjoy this please note that I can't be giving free tech support for Excel related questions. Please leave a comment if you have found this useful.

Video part 1 of 2 (older v2 spreadsheet)


Video part 2 of 2 (older v2 spreadsheet)


7 comments:

  1. Wow, Thank you! I've just stumbled on a golden mine field... I'm very appreciative for your work and commitment to share with traders like myself! :)

    ReplyDelete
  2. Thanks! That's exactly what I'm hoping for!

    ReplyDelete
  3. This is great! Is there anyway to make a copy of the tables, so you have both the original table setup and also a bespoke table to view data in the different format simultaneously? Ideally I would like a second horse racing tab to do this, but don't know it that is possible or not? Alternative having copies of the original tables to customise in the same tab would work too. Any thoughts?

    I must say, I'm very impressed with this spreadsheet, there's a hell of a lot of work gone into it and it's extremely good value for under £4!

    ReplyDelete
  4. Thanks Jay, that's great to hear. You can copy and paste tables, it is a little bit tricky to properly select it before copying though. You need to place the cursor just above the table name but still within the table until the cursor changes into a black arrow (pointing right), then click and type ctrl-c, arrow over to where you want the new table (put it to the side not underneath any existing tables) then ctrl-p to paste.
    Remember to take a backup copy of your spreadsheet first. Very important!

    ReplyDelete
  5. Perfect - Thank you very much, it works like a charm after following your instructions!

    ReplyDelete
  6. My 2 areas of in-play trading are B2L and L2B.
    Is there some way I could add a new column (or 2) somewhere to filter between the two.
    I can't see how this information can be gleamed from the Betfair results, so I presume if possible it would involve a manual data input at the end of each days play, a simple toggle between L2B and B2L would seem suffice.
    Thanks.
    Tadz

    ReplyDelete
  7. Hi Tadz, currently the spreadsheet imports Betfair and Betdaq P&L files unedited. The P&L files are provided at market level (i.e. net P&L after commission for a market such as a horse race or a football match) and not at an individual bet level. As you can do L2B and B2L multiple times within the same market it's not possible to report on them at a market level.
    Let me know if you have any other suggestions, they're good to hear!

    ReplyDelete