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)