Trigger modifier

[dixiedean]

Hi All

Can anyone have a look at my sheet and tell a novice how to modify it? I lay a bet at 30 seconds from the off and what i need is if the bet does not get matched after 10 seconds to automatically cancel it and resend bet at the new odds up till the race is off, obviously if matched do nothing, i am totally stumped with this.

Any help greatly appreciated.

Thanks
D

[dixiedean]

Sorry file attached

markettest.rar

(11.61 KiB) Downloaded 1233 times

[Captain Sensible]

To automatically cancel the bet after x seconds you can just use the fill or kill options with the Fx modifier i.e.

LAY-F10 would cancel a bet after 10 seconds

If the bet is cancelled it enters CANCELLED in the betref column, if youwanted to clear the betref/bet time columns so another bet gets submitted you use the CLEAR trigger.

I don't have time to download and look at your sheet to amend it but basically you'd need to amend your trigger to use LAY-F10 instead of LAY and add the CLEAR trigger so it clears columns to allow further bets



i.e. if your current trigger is

IF($D$2<=TIMEVALUE("00:00:30"),"LAY","")

you'd change it too (in trigger column Q5)

=IF(T5="CANCELLED","CLEAR",IF($D$2<=TIMEVALUE("00:00:30"),"LAY-F10",""))

[dixiedean]

Thanks for your help Captain i have had a go but i am still struggling to modify my trigger and get it to work properly, i guess i am abysmal at excel formulas, can anyone help?

Cheers
D

[Captain Sensible]

If your current trigger is working OK all you do is put it inside the formula I put up and change your LAY to LAY-F10

so say your current formula is If(............","",LAY) change that to If(............","",LAY-F10) and stick it inside

=IF(T5="CANCELLED","CLEAR", If(............","",LAY-F10) )

If you still can't figure it out I'll try and look at the sheet after racing

[dixiedean]

Thanks captain got it working now cheers for your help

D

[Captain Sensible]

Good to see it's working, as usual just test with small stakes to see everything works as itshould before using full stakes.