Timing 30s with Full Streaming on

[rhysw]

I have a problem where I need to check the price hasn't moved for 30 seconds, and if not then I can place bets. There are various VBA functions to help me with this (Now, Timer) however I want to use the Full Stream option as this provides the fastest speed which my scalping strategy needs. Is there a way to place the code outside of the worksheet change event which might not trigger in 30 seconds with full stream on (such as in a cell)? Or alternatively can I use VBA to turn the full streaming off as I don't need it on during this time anyway, and then turn it back on after the 30s period when betting recommences?

[Captain Sensible]

You can turn streaming on and off by stickng either FULL-STREAM-ON or FULL-STREAM-OFF in Q2

[rhysw]

Thank you Captain! I don't suppose there is a com function for it? It doesnt matter though, that will work fine.