Green All after Close Trade

[davebeddo]

Hi folks
I have been building an automated strategy where by I use guardian to place back bets on front runner while a race is in play.
I have then been using an excel spreadsheet to place a close trade bet if the backed horse goes into 2nd place. The theory being that this will be 0.00 profit/loss bet if it fails to win.

I would like to green all if the horse then moves back into 1st place but I am struggling to find a way to do this.

At the moment I am using IF's to trigger the close trade, however if the horse moves back into 1st place the cell clears and so unable to trigger green all if cell contains close trade.

I have looked on the forum and cannot seem to find any similar threads, can anybody help?

Cheers

[probro]

I am not sure what do you mean. But I use 3 times green all in my spreadsheet because one green all is not always do the job right.

[davebeddo]

Thanks for the reply - you are right about greening up.
Relying on one trigger to work every time is living on the edge. It was another idea which got consigned to the Reclycle Bin...