Trigger betting

[philuk]

Hi there

Currently I have a formula for the trigger betting that will initiate a Lay bet under certain circumstances :

=IF(AND($D$2<=TIME(0,0,5),H37="LAY",$H$45=1),"LAY","")

Now I have incorporated a back bet into it , but have no idea how to insert it in there :

=IF(AND($D$2<=TIME(0,0,5),J47="BACK"),"BACK","")

All I would like it to do is if the lay bet is triggered Lay the selection or not , or if the Back bet is triggered Back it or not.

Or if none of them are triggered just leave the race alone.

Thanx

Philip

[doris_day]

This is how I'd do it but I may be wrong:
=IF(AND($D$2<=TIME(0,0,5),H37="LAY",$H$45=1),"LAY",IF(AND($D$2<=TIME(0,0,5),J47="BACK"),"BACK",""))

[philuk]

This is how I'd do it but I may be wrong:
=IF(AND($D$2<=TIME(0,0,5),H37="LAY",$H$45=1),"LAY",IF(AND($D$2<=TIME(0,0,5),J47="BACK"),"BACK",""))

Thanx for that Doris , will let you know if it works

[philuk]

Did not work , gave me a cancelled on backing bets. Although it did the lay bets....

Although maybe another alternative :

Will it be able to open the same race in a second tab and then log those races on a different excel workbook ?

then I will be sitting with two books open ex : laybook1 and backbook1 and in BA i will have the same market open in two tabs.

[doris_day]

Yes, I think it would be a work around. Have the same market open on 2 tabs and 2 worksheets, one for Backs and one for Lays.
Also the Cancelled you got may only be because the price it was trying to Back at wasn't available. I take it you have a routine for altering the relevant odds you're asking for depending on whether you're backing or laying ?