×
Full Guide
Quick Links

Syntax of Global Commands

 
Cell L6 allows us to issue commands that apply to the whole market rather than a specific selection.
 
For instance all current unmatched bets in the market can be marked to Take SP:
 
 
Global commands
 
CANCEL_ALL
Cancels all unmatched bets in the market
GREEN_ALL
This will execute the greening routine within Bet Angel to close any open positions on all the selections in the market and evenly spread any profit or loss. It's the equivalent of using the greening column on the one click screen with the ‘Green’ checkbox ticked. 
TAKE_SP_ALL
Marks all unmatched bets in the market to be matched at SP when the market turns inplay.
KEEP_ALL
Marks all unmatched bets in the market to be Kept by Betfair at times when they would normally be cancelled (e.g. when the market suspends and goes inplay).
 
Advanced commands to link Excel with Advanced Automation
 
SET_AUTO <automation rule name>
Assign an Automation rules file to the market in Guardian
CLEAR_AUTO
Clears the rules file from the market
SET_SV FOR:<MARKET|EVENT> NAME:<name> VALUE:<value>
Assigns a stored value
CLEAR_SV FOR:<MARKET|EVENT> NAME:<name>
Clears a stored value
 
 
Notes:
 
The FOR command is optional and defaults to MARKET when used in a global command
 
The commands can be chained together to set multiple values in one go, e.g.
 
SET_SV FOR:MARKET NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200
 
or
 
CLEAR_SV FOR:MARKET NAME:Test1 NAME:Test2 NAME:Test3
 
 
As with all commands, they will be processed when the Status cell in column O is empty and will show OK / ERROR when processing is complete.