excel sreadsheet refresh time

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
THENUTS
Posts: 152
Joined: Mon Sep 10, 2012 9:05 pm

Hello,

I have all horse races for each day on one spreadsheet. The problem i have is that although the main bet angel page for each market refreshes at 300 milliseconds ( my preffered rate ) the same market on the excel sheet only seems to refresh once per second which is too slow for me.

Is there a setting somewhere i am missing or do i just have a crap processor on my laptop which is causing the delay.

although up to 40 markets are on one spreadsheet i only refresh one market at a time so this is not slowing it down

Any help would be much appreciated
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Hi
To get the fastest refresh, try connecting your spreadsheet via the Excel tab rather than via Guardian.
As guardian switches the excel connection automatically updates on that race.
I have guardian refreshing at 2 secs and use the advance settings in guardian to only start refreshing 1 sec before the race upto 900 secs after
Regards
Peter
THENUTS
Posts: 152
Joined: Mon Sep 10, 2012 9:05 pm

thanks Peter - i will give that a go tomorrow to see if it makes it any quicker as im all set up for today already.

I also use the advance settings 60 secs before 1000 after so thats not slowing it down
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Hi
I saw your other posts as well.
If you get chance try experimenting by switching off Cross matching in the settings tab.
This last few weeks I have switched mine off and found that Im getting matched almost the same but the profits are bigger
Worth experimenting with
Thanks
regards
Peter
THENUTS
Posts: 152
Joined: Mon Sep 10, 2012 9:05 pm

had no idea that was even possible - thank you. i'll have look
THENUTS
Posts: 152
Joined: Mon Sep 10, 2012 9:05 pm

Peter - where in settings do you turn off cross matching ? Can't see it
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Hi
Click on the spanner from the main screen.
Click on Display
Untick "Use Betfair's cross matching rules"

It doesn't make much difference Pre Play, but doesn't in play
Ideally, you can run two accounts (ie your's and the missus) on separate systems (ie IP addresses) one on XM, One with XM off. Then see which does best.

Good luck!
regards
Peter
THENUTS
Posts: 152
Joined: Mon Sep 10, 2012 9:05 pm

got it - thank you
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”