Formula for clearing after successful trade.

[easternpromise]

I order for me to place another trade. Could someone show me the formula to clear the trigger cell once the lay part and the back part of my current trade is matched.

I presume I will have to log my current bets in MyBets worksheet.

Thanks.

[Shaun]

You need to set up multiple triggers for different events but after a bet is made and you want to make another ad "CLEAR" this will clear the bet ref cell so another bet can be made.

Be careful when using this type of trigger as if your trigger is not set up correctly it could go in to a loop, maybe add a max number of trades to look for then stop.

[bolpx001]

Can I just clear the cells after the trade, so far I have been using the following:
Range(Sheets("rawData").Cells(5, 17), Sheets("rawData").Cells(5, 17)) = "CLEAR"
followed on the next refresh by
Range(Sheets("rawData").Cells(5, 17), Sheets("rawData").Cells(5, 21)) = ""
It would be really handy and faster if I could just use the second line of code - best regards Paul

[Shaun]

As long as the betref cells are clear you can place another bet, because you are using VBA you can just clear the cells your self with the second code.

The reason for the "CLEAR" trigger is for those using a formula because you can't have a formula in the betref cells.