q2 trigger -1

[alrodopial]

Hi,
can someone provide a working code for placing -1 in cell q2 when the race has finished?
I can do it but ba goes to the race after the next one , I haven't found a way to delete it at the correct time and ba reads it for second time and goes to the race after next one.

[MarkRussell]

Hi,

Here's an example for you which also demos an in play timer.

http://www.gruss-software.co.uk/Excel/In_Play_Timer_And_Moving_Markets_At_The_End_Of_The_Race.xls

Regards,
Mark

[alrodopial]

Thanks

[alrodopial]

It drove me crazy but now is ok.
Mark your code is working ok
A variable when just placed the -1 done the job , that it will not allow further -1 places and it will reset at the market change.
The way I see it:
The code places the -1
BA updates the 16 columns, reads the -1 and deletes it.
Then I believe that there is another one 16 columns update but with the same as previous market - at this point my code was placing the -1 for the second time -
Next update is with the new market.