Recording market odds and traded volumes spreadsheet - capturing data

tiagotiks
Posts: 1
Joined: Mon Jan 20, 2014 10:06 pm

Hello everyone.
Can I use this spreadsheet for football markets as well?
How to place more then one market at the same time?

cheers
Yirkaa
Posts: 23
Joined: Sat Jun 08, 2013 12:53 am

Hi, did anyone managed to get this to work on multiple markets and is willing to share the file? I tried copying DATA sheet, but without changing macros it doesnt work. And I dont know how to change them. Any help would be appreciated. Thanks
masmarinho
Posts: 1
Joined: Thu Jun 11, 2015 2:39 pm

Great Work i-XL :)

Ive been trying to record with a less than 1 sec interval (like 300ms)
But im not be able to :(

How can i make it record 3 or 4 times per second ?

Best Regards
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Hi! Is this sheet still working? I've loaded it into the betangel excel and clicked connect, making sure its set to auto switch at 300, clicked ticked to record but it's not recording any of the loaded markets. Help anyone?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

watch this and it should help

www.youtube.com\watch?v=EF0UQm-wIvU&list=PL68313D48EDF522F6
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Has anyone else noticed the time difference between the time that`s recorded from the Bet Angel sheet as 00:00 and the Actual Off time of the race. There looks to be a 2 second delay in the Excel sheet and coupling this with the 1 sec bet delay that BF impose are you potentially 3 seconds behind the action once you place a bet from Excel. So if you are seconds behind at the start, more importantly you are seconds behind at the end. Can any of the more learned bods on this forum shed any light on this?
BA Time Query.png
You do not have the required permissions to view the files attached to this post.
LinusP
Posts: 1871
Joined: Mon Jul 02, 2012 10:45 pm

Atho55 wrote:
Tue Jan 02, 2018 7:41 pm
Has anyone else noticed the time difference between the time that`s recorded from the Bet Angel sheet as 00:00 and the Actual Off time of the race. There looks to be a 2 second delay in the Excel sheet and coupling this with the 1 sec bet delay that BF impose are you potentially 3 seconds behind the action once you place a bet from Excel. So if you are seconds behind at the start, more importantly you are seconds behind at the end. Can any of the more learned bods on this forum shed any light on this?

BA Time Query.png
A human clicks the inplay button so you can’t assume it will be perfect, however if you are finding it consistently off I would check you clock is up to date.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

I would have thought that it would be the BA clock that needs checking as the time is fed from the Bet Angel sheet. Also think that 2 secs is a recurring time rather than an exception. Will have a look.
User avatar
Dallas
Posts: 22673
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Atho55 wrote:
Tue Jan 02, 2018 8:49 pm
I would have thought that it would be the BA clock that needs checking as the time is fed from the Bet Angel sheet. Also think that 2 secs is a recurring time rather than an exception. Will have a look.
BA takes its time from your PC/Laptop, it's that clock you need to check and make sure is synced correctly
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

I`ve just connected to a race tomorrow and there looks to be a difference between the two BA times being the Countdown on the Excel sheet and the time at the bottom on the 1 Click screen. http://prntscr.com/hv9qc4

I will check my clock to see how that compares.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

My time appears to be ok according to this http://prntscr.com/hv9x5z
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

A 3 second delay on this race. http://prntscr.com/hva27b so if the clocks look to be ok is this delay from BF pressing a button as suggested. Seems a long time to me.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

If you look at the actual race duration as quoted by Sporting Life and inserting this into the timeline gives us the exact position the race has finished and how many seconds after the completion the odds hit 1.01. 3 seconds. http://prntscr.com/hvajhj.
User avatar
gutuami
Posts: 1858
Joined: Wed Apr 15, 2009 4:06 pm

I would suspect that your pc is slow or you have too many charts open or other apps.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

The spreadsheet is designed to record every second which it does adequately so I`m struggling to see how having any other charts or apps open on my PC can influence the race going In Play 2-3 seconds after it has actually started then actually finish with Bet Angel still firing bets into the market for the 2-3 seconds when the race outcome is already known by BF. That`s the problem, just wondering how/why it happens as it gives BF 2-3 seconds to influence results should they wish.
Post Reply

Return to “Betfair Data”