Afternoon,
Going to have a crack at creating a simple bot for the football this afternoon on a test account...
I'm keen to take advantage of the new Guradian binding and batches features, so loaded up a simple spreadsheet and connected it to guardian...(NB I wouldnt normally use multiple sheets connected via guardian but have to in this instance as the football all kicks off at 3pm and all run simultaneous..)
The first thing I notice is that the "Last Update" In Guardian is refreshing nicely, but the time for instance in cell C3 on the individual sheets is refreshing much too slow although I have the refresh interval set to 200ms...
This is what I mean :-
http://www.youtube.com/watch?v=T5_rsL7DvkU
Is there an easy way to correct??
Thanks
Peter
Using Guardian
When connecting to multiple markets using Excel, only the market loaded into the main application window will update real time. The other markets will update as per the Guardian refresh cycle.
See here - http://www.betangel.com/knowledge-base/ ... run-slowly
See here - http://www.betangel.com/knowledge-base/ ... run-slowly
Thanks TT
Just had a look at that link and an extract says:-
A market in Excel will update each time the market data is updated by Bet Angel. If the market is currently displayed in the main application's trading screen then it will update at the refresh rate set. If not, it will update once per guardian refresh cycle.
I've got five markets loaded, the first displayed in the main screen (which seems fine)..Guardian is set to 200ms refresh, so should the other 4 not refresh at 200ms intervals then? (i.e. I would expect each sheet to refresh at 1 sec intervals (5 Mrkts *200ms)?
Thanks
Peter
Just had a look at that link and an extract says:-
A market in Excel will update each time the market data is updated by Bet Angel. If the market is currently displayed in the main application's trading screen then it will update at the refresh rate set. If not, it will update once per guardian refresh cycle.
I've got five markets loaded, the first displayed in the main screen (which seems fine)..Guardian is set to 200ms refresh, so should the other 4 not refresh at 200ms intervals then? (i.e. I would expect each sheet to refresh at 1 sec intervals (5 Mrkts *200ms)?
Thanks
Peter
Yep, it should, but i think it is down to speed of the PC.... i find anything less than about 400ms is too fast for either the PC/BA/Excel (could be all or any of these) to cope with.
The only slight annoyance is even with the VPS service i pay £60/month for it still isn't perfect below about 400-500ms (but otherwise BA is great and i think this is still quick enough for most purposes)
Has anyone with a really fast PC with latest excel version and lots of RAM still got these issues?
The only slight annoyance is even with the VPS service i pay £60/month for it still isn't perfect below about 400-500ms (but otherwise BA is great and i think this is still quick enough for most purposes)
Has anyone with a really fast PC with latest excel version and lots of RAM still got these issues?
True - it should in a perfect world.
But your PC is probably busy doing other things too. Checking the internet, monitoring the firewall, running an antivirus, updating the clock, tidying files, downloading mail, checking for Microsoft updates, monitoring for bluetooth connections, moving the mouse pointer, displaying the screen, loading a webpage, stoking the fire, polishing the china & a million other things the OS does each clock cycle.
So the actual refresh rate will be as close as it can get whilst doing everything else.
But your PC is probably busy doing other things too. Checking the internet, monitoring the firewall, running an antivirus, updating the clock, tidying files, downloading mail, checking for Microsoft updates, monitoring for bluetooth connections, moving the mouse pointer, displaying the screen, loading a webpage, stoking the fire, polishing the china & a million other things the OS does each clock cycle.
So the actual refresh rate will be as close as it can get whilst doing everything else.
-
timnicholson
- Posts: 1
- Joined: Sat Apr 10, 2010 4:50 pm
Hi,
I have been experiencing a similar issue with refresh speed on a multi market spreadsheet running through Guardian.
My observations are that the Guardian is updating the events at the speed expected (number of events/refresh interval per event), but despite what the guardian window is telling me for the time of the "last update", the updates are not consistently hitting the spreadsheet unless I select a refresh interval lower than about 3 seconds.
What could be causing this delay ? I have tried two different PCs, but am really keen to know if the limitation is the data restrictions from the Betfair server or something I can actually work around, such as more RAM.
Many thanks,
I have been experiencing a similar issue with refresh speed on a multi market spreadsheet running through Guardian.
My observations are that the Guardian is updating the events at the speed expected (number of events/refresh interval per event), but despite what the guardian window is telling me for the time of the "last update", the updates are not consistently hitting the spreadsheet unless I select a refresh interval lower than about 3 seconds.
What could be causing this delay ? I have tried two different PCs, but am really keen to know if the limitation is the data restrictions from the Betfair server or something I can actually work around, such as more RAM.
Many thanks,