How to disable the refresh

[Maxim Zaytsev]

Hi All!
If the hour before the launch, the refresh is once per second - it's not a problem to do.
But how to do if the market is "Closed" to disable the update?
Please tell me advice. Maybe there is a command for Q2? (not found on the forum and answer in User Guide)

[Captain Sensible]

There's no way to disable the refresh other than closing the tab or unticking the AUTO box next to the refresh on the main screen. The best you can do is set the refresh rate to the highest amount 1000 in Q2, that's one refresh every 16 minutes so effectvely sht down.

Just add some simple VBA to your sheets like

Code: Select all

If Range("F2").Value = "Closed" Then Range("Q2").Value = 1000

[Maxim Zaytsev]

Thanks for the help, Captain Sensible!
Last question: can you show a working example of the function "refreshMarkets" (example, for the market id 129158576), If you is not difficult?
(Link to User Guide http://www.gruss-software.co.uk/Betting ... arkets.htm)

[Captain Sensible]

I don't use the COM functions myself but it seems that function refreshes the market menu list, it doesn't refresh individual markets. It's the same as putting -3 in the Q2 cell.

[Maxim Zaytsev]

Thanks for the quick answers! I will use your method.
Thank you very much!