Using the excel template is it possible to cancel all orders x seconds after the race goes in-play?
I'm using the 'in-play' message to place orders, but I only want them to be valid for a set period, ie for a 5 furlong race to be cancelled after 30 secs, for a 3 mile chase maybe 2 minutes.
I'm aware of the in-play dangers, but can anyone advise a way to do this?
Many thanks.
Can you cancel orders after a set time in-play?
-
Nightracer
- Posts: 4
- Joined: Sun Jan 12, 2014 10:58 pm
Thanks Burdo, I can arrange the excel formula's fine thanks, except that when the market goes 'in-play' is not a defined time (ie in some races it could be within seconds of the due off time, if there's a delay it could be substantially afterwards).
I guess therefore what I'm really asking is whether or not there is somewhere to pick that 'in-play' time up from (ie is it stored anywhere in the software that could be available in excel)...
...or is there a way to use formula's etc to use the point where the 'in-play' message appears in the worksheet to time to cancelling bets when the formulas can then pick up and cancel.
Sorry if I'm not explaining myself very well.
I guess therefore what I'm really asking is whether or not there is somewhere to pick that 'in-play' time up from (ie is it stored anywhere in the software that could be available in excel)...
...or is there a way to use formula's etc to use the point where the 'in-play' message appears in the worksheet to time to cancelling bets when the formulas can then pick up and cancel.
Sorry if I'm not explaining myself very well.
Hi there - I can help you with this.
Basically you are looking at and IF and AND formula. The spreadsheet has the time to race clock (countdown) at F4. This counts down to the scheduled race time, goes to a negative figure when it is past the scheduled race time, then goes to a positive timer when the race goes in play. So you are looking for a formula that says is that clock less than, say, 30 seconds AND is the market in play? if so, (and your other criteria is matched of course), then bet. This wo' "cancel" a bet that you have in the market, but it will fire in a new bet of all criteria is matched. In order for excel to match the time to the countdown clock, you need to express your time in the same format at F4. The easiest way to do this is to go to, say, G4 and put in YOUR time criteria eg. 00:00:30. then have your formula reference G4. So the equation would look like this for example:
=IF(AND($G$4<$F$4,$G$1="In-play"),"BACK",""NO"")
you would then enter your own criteria as more AND statements after "in-play" and before the ).
hope that makes sense! let me know if you need any more help
Mike
Basically you are looking at and IF and AND formula. The spreadsheet has the time to race clock (countdown) at F4. This counts down to the scheduled race time, goes to a negative figure when it is past the scheduled race time, then goes to a positive timer when the race goes in play. So you are looking for a formula that says is that clock less than, say, 30 seconds AND is the market in play? if so, (and your other criteria is matched of course), then bet. This wo' "cancel" a bet that you have in the market, but it will fire in a new bet of all criteria is matched. In order for excel to match the time to the countdown clock, you need to express your time in the same format at F4. The easiest way to do this is to go to, say, G4 and put in YOUR time criteria eg. 00:00:30. then have your formula reference G4. So the equation would look like this for example:
=IF(AND($G$4<$F$4,$G$1="In-play"),"BACK",""NO"")
you would then enter your own criteria as more AND statements after "in-play" and before the ).
hope that makes sense! let me know if you need any more help
Mike
-
Nightracer
- Posts: 4
- Joined: Sun Jan 12, 2014 10:58 pm
Thats great Mike, I hadnt spotted that the countdown clock re-started when the race went in-play, so that's the trigger I'm looking for 
Thanks a lot for your help.
Thanks a lot for your help.