Betfair Data : Data-capture spreadsheet

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

Sun Feb 02, 2014 6:54 pm

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: 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
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.

Enjoy!
You do not have the required permissions to view the files attached to this post.

User avatar
EyePeaSea
Posts: 258
Joined: Sun Jun 12, 2011 11:18 am

Sun Feb 02, 2014 8:06 pm

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

Regards

Ian

PeterLe
Posts: 3325
Joined: Wed Apr 15, 2009 3:19 pm

Sun Feb 02, 2014 10:18 pm

thanks Switesh,I'll take a look at that tomorrow, much appreciated
regards
Peter

herbie
Posts: 342
Joined: Mon May 11, 2009 8:56 pm

Mon Feb 03, 2014 2:03 pm

Switesh,

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.

Arta700
Posts: 16
Joined: Sun Aug 07, 2011 9:42 am

Mon Feb 03, 2014 3:06 pm

Brilliant, thanks for sharing the spreadsheet Switesh.

Wainwright
Posts: 106
Joined: Mon Jan 23, 2012 1:10 pm

Mon Feb 03, 2014 4:24 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

LinusP
Posts: 1350
Joined: Mon Jul 02, 2012 10:45 pm

Mon Feb 03, 2014 4:40 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!

burdo77
Posts: 351
Joined: Sun Jun 09, 2013 4:13 am

Tue Feb 04, 2014 1:10 am

absolutely brilliant!
You must of had some falling out building this.....
cant wait to test this, cheers.

gazuty
Posts: 1022
Joined: Sun Jun 26, 2011 11:03 am

Mon Mar 03, 2014 10:40 am

Legend. Great stuff. Sensational really. And great spirit by sharing.

User avatar
LeTiss
Posts: 4168
Joined: Fri May 08, 2009 6:04 pm

Mon Mar 03, 2014 7:36 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”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest