Problem with Net_Stake sample sheet

[craigy]

Hi all
I am trialing a few ideas with the sample sheet net_stake and I while I can get it to complete back and offset once it seems to stop there and not trigger anymore bets. The trigger col is filled ok but unless I manually clear the bets ref col it won't go through through the cycle again.Any idea what Im missing?
Thanks for any help.

[GaryRussell]

That's how the triggers work. It wont place another bet until you clear the bet ref column so you need to make it do this. You can use the CLEAR trigger to do this or if using VBA just clear it using your code.

[craigy]

Sorry. I thought it supposed to trigger clear once it had completed a back and offset and start the process again.