Data-capture spreadsheet

Post Reply
Posts: 527
Joined: Mon Jul 11, 2011 8:43 am

Hi Traders,

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: ... sp=sharing

Instructions & demonstration in this video:
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
    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
PS: I designed this spreadsheet specifically for capturing pre-off horse race trading data (about 5 mins pre-off) so it may not work for other sports like tennis, soccer etc.
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.

You do not have the required permissions to view the files attached to this post.
User avatar
Posts: 258
Joined: Sun Jun 12, 2011 11:18 am

Very impressive, and most of all, thanks for sharing.


Posts: 3596
Joined: Wed Apr 15, 2009 3:19 pm

thanks Switesh,I'll take a look at that tomorrow, much appreciated
Posts: 342
Joined: Mon May 11, 2009 8:56 pm


Thankyou for this spreadsheet.

You are a very generous person, your contribution to this forum exceptional. I wish you well and hope your screens are all green.
Posts: 16
Joined: Sun Aug 07, 2011 9:42 am

Brilliant, thanks for sharing the spreadsheet Switesh.
Posts: 108
Joined: Mon Jan 23, 2012 1:10 pm

Great stuff, for someone who's not an Excel developer you certainly seem to be getting the hang of it - thanks for sharing :D
Posts: 1770
Joined: Mon Jul 02, 2012 10:45 pm

Thanks for sharing Switish! I am sure I will find some use for this as I want to look into WOM. Have you developed many bots, as you seem to have some great excel skills!
Posts: 351
Joined: Sun Jun 09, 2013 4:13 am

absolutely brilliant!
You must of had some falling out building this.....
cant wait to test this, cheers.
User avatar
Posts: 1918
Joined: Sun Jun 26, 2011 11:03 am

Legend. Great stuff. Sensational really. And great spirit by sharing.
User avatar
Posts: 4913
Joined: Fri May 08, 2009 6:04 pm

I've only just taken a good look at the spreadsheet

I absolutely tip my hat, Switesh!

Not only is that a magnificent piece of work, but your willingness to share it with others is something else
Post Reply

Return to “Betfair Data”