inplay timer

[mrcelebrity]

Hi I'm just wondering if its possible to utilise the "in play timer" when making an excel trigger or bot. For example say I want to cancel all my bets when the in play timer reaches 1 minute

Thanks

[silver]

There is some code created by Gary posted at the bottom of this thread which will do what you want:

http://www.gruss-software.co.uk/forum/v ... play+timer

____________________


Alternatively, if you wanted to create an In Play timer using only formulas rather than VBA code, it can be done as follows. The W3 formula below was posted by Gary if I recall correctly. I have a feeling that I got the overall structure from another site about Excel.

I use cells T3, U3, V3 and W3 for this:

In T3. =IF($E$2="In Play","In Play","")

In U3. =IF(T3="","",IF(U3="",NOW(),U3))

In V3. =IF($E$2="In Play",NOW()-U3,0)

In W3 =IF(LEFT(V3)<>"-",(HOUR(V3)*3600)+(MINUTE(V3)*60)+SECOND(V3),-((HOUR(SUBSTITUTE(V3,"-",""))*3600)+(MINUTE(SUBSTITUTE(V3,"-",""))*60)+SECOND(SUBSTITUTE(V3,"-",""))))

I think you'll need to enable iterative calculations for this to work.

I have cells T3 and W3 formatted as General and cells U3 and V3 formatted as Time HH:MM:SS.

When the event goes in play, cell W3 should count in seconds from 1 upwards as time passes.

__________________

If you are able to employ the code from the thread posted above, it is arguably superior in a number of ways, but perhaps it's useful to see how it can be done using formulas too.



Silver

[MarkRussell]

Hi,

You can monitor for when the market is turned in play, start your timer, and use the CANCEL-ALL trigger to cancel all unmatched bets when the timer reaches 1 minute.

It will be accurate to the refresh rate that you have set, e.g. if you had a refresh of 10 seconds and the market is turned in play just after your last refresh it will be 10 seconds before your sheet knows it has turned in play.

Mark