Do I need to adjust any setting to my excel or use a particular version of excel?
I use the original spreadsheet and when I tick the "tick to record" box it captures data once and then it stops capturing data even though the information is changing above it.
anyone else had a similar problem?
Recording market odds and traded volumes spreadsheet - capturing data
- pdupre1961
- Posts: 410
- Joined: Fri Feb 18, 2011 8:01 pm
- Location: Morden, London
Hi Mythos,
Yes, you need to change your refresh rate on Guardian to 500ms.
The capture rate on Guardian must be less than on the spreadsheet...
Paul
Yes, you need to change your refresh rate on Guardian to 500ms.
The capture rate on Guardian must be less than on the spreadsheet...
Paul
What did you find out on the net?
A brief search of Google shows this to be a generic error that could be caused by any number of problems.
http://www.google.co.uk/search?rlz=1C1S ... error+1004
A brief search of Google shows this to be a generic error that could be caused by any number of problems.
http://www.google.co.uk/search?rlz=1C1S ... error+1004
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: 2161
- 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