Away too long

[summit]

Hi there,

I remember the basics and have got the excel spreadsheet linked.

However, at the moment my bets are triggering at all times including IN PLAY and I just want the bets triggered if conditions are met prior to OFF.

Also can you please tell me which cell I populate to set the bet to 20 seconds before the OFF.

Thanks for any help.

[2020vision]

http://gruss-software.co.uk/forum/viewtopic.php?t=4588

the above link will take you to a countdown timer which you can use in
conjunction with an "IF" statement included in your trigger(s).

[summit]

Brilliant, I have pasted that into Cell T1 and incorporated it into my IF statement for the TRIGGER...works perfectly, thanks a lot.

Now I have you How can I actually stop it from betting IN PLAY? I think I can prevent it by telling the software to move to the next race at scheduled OFF time, but just wondered whether there was an easier way?

Thanks again for the first piece of help. Much appreciated.

Steven

[2020vision]

Something along these lines as part of your trigger should do it...

Code: Select all

=IF(AND($E$2="In Play",$F$2<>"Suspended","",rest of your formula))

[summit]

That's great, thanks very much.

I am gradually remembering the general idea now