The VBA debugger says that its happening on the line that moves the previous data down the sheet.
I am using the Office 2000 version of Excel.
Recording market odds and traded volumes spreadsheet - capturing data
I wanted to record more than one market with this, so have managed to copy some of the sheet from the Multiple BetAngel spreedsheet to this one, i can make another Data sheet inside this spreedsheet show the value of another market, but it doesnt record it, i have made a copy of the original "Data" module and changed all the Sheet 'Data' text to Sheet 'Data (2)' but it doesnt work, it gives me an "Ambiguous name " in the range word of the Private Sub Worksheet. Anyone can help ?
Thanks in advance
Thanks in advance
-
- Posts: 1
- Joined: Sun May 19, 2013 3:34 pm
Emerson wrote:I wanted to record more than one market with this, so have managed to copy some of the sheet from the Multiple BetAngel spreedsheet to this one, i can make another Data sheet inside this spreedsheet show the value of another market, but it doesnt record it, i have made a copy of the original "Data" module and changed all the Sheet 'Data' text to Sheet 'Data (2)' but it doesnt work, it gives me an "Ambiguous name " in the range word of the Private Sub Worksheet. Anyone can help ?
Thanks in advance
Hi, I extended the sheet a little bit. I can now
record 6 markets at same time.
I have to imporve it a little bit.
More details come later. I have to test now.
-
- 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
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
- MemphisFlash
- Posts: 2191
- 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
www.youtube.com\watch?v=EF0UQm-wIvU&list=PL68313D48EDF522F6
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?
You do not have the required permissions to view the files attached to this post.
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 wrote: ↑Tue Jan 02, 2018 7:41 pmHas 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
BA takes its time from your PC/Laptop, it's that clock you need to check and make sure is synced correctly
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.
I will check my clock to see how that compares.