best refresh set up

[Yorkie]

This may not apply to many people but

currently I have 35 excel sheets in 1 workbook linked to 35 BA pages. Each sheet fires a -6 update at 1 minute intervals based on the current time. For example sheet 1 fires when the time is 08:00:01, 08:01:01, sheet 2 fires when the time is 00:08:02, 08:01:02 etc so they don't all fire at the same time. The refresh rate is currently set to 1 second.
I am planning on increasing this to 70 sheets and 70 BA pages.

My question is what would be the optimum refresh set up for this bearing in mind the 20 calls per second imposed by betfair. Would it be a case of no matter what the refresh rate there is always going to be a backlog of requests that haven't been met and how does BA deal with this?
I realise BA was probably not designed for this but it does it anyway.lol

Any info appreciated

Cheers

[GaryRussell]

There is never a back log of requests. The throttling effectively lowers the refresh rate of each page, they should all refresh at regular intervals as often as they can to avoid going over 20 requests. 1 second is fine.

[Yorkie]

Bearing in mind what you say does this mean that staggering the -6 update doesn't actually do any good and BA would sort it out anyway? I have noticed that if they all fire at once then they can seem to freeze with a refresh of 0 for quite a long time, sometimes over the minute space there is supposed to be.
Also does it mean that with a 1 second refresh and using say 60 sheets the effective refresh rate will be 3 seconds?

Cheers

[GaryRussell]

What you are seeing is the program adjusting the refresh times so that they are staggered. eg. 2 markets both updating every 60 seconds will be adjusted so that the refreshes occur every 30 seconds. While it is doing the adjustment the refreshes will be delayed, but it should settle down.

Yes, it will be 3 seconds, but after you have placed bets in a market it will need to monitor them also so if they all have bets it will be 6 seconds.

[osknows]

Gary,

Is it possible to send a timestamp with each refresh in ms?

For example, theoretically you could have 10 refreshes on a worksheet with no changes in prices or volume, there is no way to detect if a refresh has occured within the data.

The reason I ask is that this would make life much easier to manage multiple worksheets within a single workbook without using change events to identify updates in excel. Also, additional code to monitor average refresh rate would become redundant

Thanks,Os