Betfair Data : Recording market odds spreadsheet - capturing data

Post Reply
i-XL
Posts: 2
Joined: Thu Aug 26, 2010 12:06 pm

Thu Aug 26, 2010 12:27 pm

Hi all,

After reading the many requests for users wanting some kind of data logging spreadsheet and seeing that no one could come up with one I decided to quickly put one together.

This would be handy for recording a whole day's horse racing data for example.

An example setup:

1. Load up all the horse racing markets into Guardian (make sure no markets clash otherwise only one will be recorded).
2. Set Guardian to auto switch to the next market at 300 seconds. Select the first market and make sure the main Bet Angel app is looking at it.
3. Go to Bet Angel and load the spreadsheet up via the Excel tab and click 'connect'
4. Go to Excel and check the 'Tick to record' check box. This will record data once per second.
5. You can manually record data if you want with the 'Manual' button and clear the data with the 'Clear Data' button.
6. Save the data under a unique name at the end of the day.

Be aware that using your computer for ANYTHING else whilst this sheet is running is not recommended. There will be LOTS of data recorded and I imagine a whole days UK & Irish racing will probably make the average machine fall over and die. I've not tested to this extreme yet. Also, looking at any other sheet other than the 'Data' sheet might cause it to give an error. You'll have to restart Excel or even your machine if this happens.

Post here if you find this is useful or not. No doubt some people will want it quicker/slower/bigger/smaller/record other data/display graphs/autobet/ and so on. So I've left it open source so you can modify and add these things if you wish.

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

Exacta
Posts: 151
Joined: Wed Aug 25, 2010 2:57 pm

Thu Aug 26, 2010 2:34 pm

Excellent stuff!

Merry Terry
Posts: 49
Joined: Tue Aug 10, 2010 2:37 pm

Thu Aug 26, 2010 9:22 pm

Thanks for this.

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

Thu Sep 30, 2010 6:19 pm

thanks you've saved me hours..
Could you please point me in the direction regarding changing 1 second to 1 minute or 5 minutes please?

regards
Herbie

User avatar
exsolister
Posts: 8
Joined: Tue Oct 12, 2010 5:51 pm

Thu Oct 14, 2010 11:07 am

Thanks. U r my star. Leave it open source saves me a lot of time.

Bet Angel's service worth me paying. :-)

donfede
Posts: 23
Joined: Wed Jul 08, 2009 3:35 pm

Tue Feb 22, 2011 2:00 pm

Good stuff really!

But 1 second interval is a whole lot of data.
How can I switch to 5, 15 or 20 seconds???
thanx

pbigmoon
Posts: 2
Joined: Fri Sep 03, 2010 12:39 am

Thu Mar 31, 2011 10:52 pm

just what i was looking for can this be used for any market as i usually bet on american sports so i wanna record the odds ect while in play so over time ill be able to see if im better leaving the bets till inplay for higher odds as with basketball odds up and down alot on most games

thanks

i-XL
Posts: 2
Joined: Thu Aug 26, 2010 12:06 pm

Fri Apr 01, 2011 11:26 am

Someone just nudged me about this. I've updated the sheet so you can specify an interval. Remember to untick 'Record data' before changing the value.

I've not tested with all intervals from 1 second to 5 mins but it should be ok. Post up here if you find any problems or have a go at sorting it yourself. There is nothing hidden.
BetAngel_Record_datav2.zip
You do not have the required permissions to view the files attached to this post.

blueport
Posts: 227
Joined: Mon May 18, 2009 7:35 am

Mon Apr 04, 2011 8:19 am

i-XL wrote: Also, looking at any other sheet other than the 'Data' sheet might cause it to give an error. You'll have to restart Excel or even your machine if this happens.
BetAngel_Record_data.zip
What would cause the sheet to do this?

I need to be able to look at other sheets while recording data.

When I change tabs the record data sheet goes haywire and starts spitting out row after row of data.

I know support is not offered with this sheet but I thought I would ask anyway.

Cheers,

Simon

Predicton
Posts: 281
Joined: Sun Sep 13, 2009 3:41 pm

Wed Apr 20, 2011 3:48 pm

I can only sit back and applaud you i-XL. I dread to think of the work which has gone into this spreadsheet. Well done

For my part, I am so useless at computing that I can get as far as instruction no 3 in your first e-mail, then the trail peters out.

Cheers, P

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest