1. Checking my assumption is correct. If you have a Stop Loss trigger modifier set up and your bet ends up in a positive situation then the stop loss is effectively null and void? ie LAY with SL ended up less than BACK.
It could still trigger if it goes back into a negative position unless you also use the tick offset modifier and the offset bet is matched.
2. If there's an unmatched or pending bet and the odds have moved out of that bets parameter LAY req. odds 5, but they're now at say 9. Can you just change the odds in column 'R' or does the bet need - 'CANCEL' then 'CLEAR' and redoing? or is there a way to do this in excel?
You can use the 'UPDATE' trigger. Specify the new odds in column R.