COM Inplay Refresh Rate

[jc0r]

Hi,

I am looking for a way to adjust the refresh rate inside of betting assistant using Excel and the COM interface. I know about ba.RefreshRate = 0.2 but i am having a hard time using it efficiently and wondered if anyone could offer any advice. What i need to be able to do is if the market is not inplay, set the refresh rate to 2 seconds, then, when the event turns inplay i need that refresh rate to be adjusted to 0.2 seconds.

The reason i say i am struggling to find an efficient way of executing this is because lets say i have the trigger off Sheet1!E2 which is the "In Play / Not In Play" cell. Using Worksheet_SelectionChange, Excel will recognize a change on every refresh whether the cell changes or not. This is very inefficient as it runs the macro every refresh, and when refresh rates adjust to 0.2, this hogs CPU severely.

Am i right in thinking this can't simply be achieved by a setting in the software? Ive had a look in settings but the only adjustment i have found is regarding the throttling not the actual refresh rate itself.

[jc0r]

For anyone interested, i found a solution to my problem. On the age where you log Excel data too, instead of using the COM method, cell Q2 can contain a formula that will adjust your refresh rate. For me i have just gone with

Code: Select all

=IF(AND(E2="In Play",F2="Suspended"),2,IF(E2="In Play",0.2,2))

This basically sets any event that is in play to a refresh rate of 0.2. Any other time it will be at 2 seconds.