Adding to list of various data-capture spreadsheets floating around I've created my own version of a data-capture spreadsheet.
Requires Excel 2010 (or higher) and a good spec machine to handle at-least 10-20 MB of excel file running alongside BA.
Download link: https://drive.google.com/file/d/0B8rbBn ... sp=sharing
Instructions & demonstration in this video: http://youtu.be/dDIgU-Hwz3c
Make sure to view the video in 1080HD setting on YouTube else it might appear a bit blurry.
Here's a brief list of some of the features in this spreadsheet:
- PL Stats
Strike-rate
Turnover
Return on turnover
Volatility Profile
Market Overivew Graph
Betfair Graph (at-least similar to it)
Front 3 Back & Lay money Graph
WOM Graph
Market Volume Graph
Trading Range Stats
Ladder View for individual runner
The spreadsheet can also capture data for Post-time & In-Play but I haven't actually tested in-play data-capture that much so let me know if you find any bugs there.
And lastly, I'm not really an Excel developer, I just created this spreadsheet for my own custom needs so if it benefits other pre-off traders it's a bonus.
Enjoy!