Data-capture spreadsheet

Post Reply
switesh
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: 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

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

Regards

Ian
PeterLe
Posts: 3715
Joined: Wed Apr 15, 2009 3:19 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

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

Brilliant, thanks for sharing the spreadsheet Switesh.
Wainwright
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
LinusP
Posts: 1871
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!
burdo77
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
gazuty
Posts: 2547
Joined: Sun Jun 26, 2011 11:03 am
Location: Green land :)

Legend. Great stuff. Sensational really. And great spirit by sharing.
User avatar
LeTiss
Posts: 5386
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
sweetybt
Posts: 500
Joined: Sat Apr 18, 2009 4:35 pm

Totally agree, I discovered it on Friday and meant to write a post but got lost playing with it.

Well done Switesh.

Can't believe only 100 people have watched the video
chris_ri
Posts: 36
Joined: Wed Apr 15, 2009 1:57 pm

Hi Switesh,

Great spreadsheet!!

Im trying to run on 64bit Windows 7 today and I received the following error when I connect

Compile Error

The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute.

Wondered if you know what is needed, I cant be the first to run it on 64 bit windows.

Cheers,

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

Thanks all for your kind & generous comments, & to Euler for the blog post.

Chris - I run it on Win 7, 64 bit, Excel 2010 laptop error free. I will however try to replicate your error and address it.

I assume it works fine for others?
chris_ri
Posts: 36
Joined: Wed Apr 15, 2009 1:57 pm

Thanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.

Replaced

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

with

Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

note the PtrSafe modifier.

Thanks again for the great spreadsheet.

Chris
User avatar
woodhousejj
Posts: 47
Joined: Thu Oct 24, 2013 11:19 pm

Thanks Chris I had the same mesaage, altough on one of the Windows forums it states that its not a problem so long as you don't want to amend the code.

John
Post Reply

Return to “Betfair Data”