The following trigger keywords are for cancelling unmatched bets and for making the spreadsheet ready to accept new bets:-

Trigger	Description	Notes
CANCEL	Cancels a single unmatched bet.	The Bet ref column must contain the bet reference of the unmatched bet that you wish to cancel.
CANCEL-EXIP	Cancels a single unmatched bet unless the bet is flagged to be kept in play in which case the trigger is ignored.	As above.
CANCEL-KO	Cancels a single unmatched bet but keeps the offset when Tick Offset or Stop Loss has been used,e.g. if an initial bet is partially matched and you want to cancel the remaining unmatched portion it's possible that as you issue the trigger to cancel that some of it gets matched in which case you want the offset bet to be increased by the same amount so you can use this trigger to prevent the offset part being cancelled.	As above.
CANCEL-ALL	Cancels all unmatched bets for the selection on the row where the trigger is used.	The bet ref column must contain something which doesn't need to be a valid bet reference just as long as it isn't blank, e.g. you could use DUMMY
CANCEL-ALL-EXIP	Cancels all unmatched bets for the selection on the row where the trigger is used excluding bets which are flagged to be kept in play.	As above.
CANCEL-ALL-KO	Cancels all unmatched bets for the selection on the row where the trigger is used but keeps any offset bets as described above.	As above.
CANCEL-ALL-BACK	Cancels all unmatched back bets for the selection on the row where the trigger is used.	As above.
CANCEL-ALL-BACK-EXIP	Cancels all unmatched back bets for the selection on the row where the trigger is used excluding bets which are flagged to be kept in play.	As above.
CANCEL-ALL-BACK-KO	Cancels all unmatched back bets for the selection on the row where the trigger is used but keeps any offset bets as described earlier (above).	As above.
CANCEL-ALL-LAY	Cancels all unmatched lay bets for the selection on the row where the trigger is used.	As above.
CANCEL-ALL-LAY-EXIP	Cancels all unmatched lay bets for the selection on the row where the trigger is used excluding bets which are flagged to be kept in play.	As above.
CANCEL-ALL-LAY-KO	Cancels all unmatched lay bets for the selection on the row where the trigger is used but keeps any offset bets as described earlier (above).	As above.
CANCEL-ALL-MARKET	Cancels all unmatched bets for the current market.	As above.
CANCEL-ALL-MARKET-EXIP	Cancels all unmatched bets for the current market. excluding bets which are flagged to be kept in play.	As above.
CANCEL-ALL-MARKET-KO	Cancels all unmatched bets for the current market but keeps any offset bets as described earlier (above).	As above.
CLEAR	Clears the bet reference, i.e. blanks the cell	Use this trigger if you want to submit another bet for the same selection as the bet ref must be blank to use the back and lay triggers