×
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
CANCEL_ALL_BACK
Cancels all unmatched back bets in the market
CANCEL_ALL_LAY
Cancels all unmatched lay 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.
TAKE_SP_BACK
Marks all unmatched back bets in the market to be matched at SP when the market turns inplay.
TAKE_SP_LAY
Marks all unmatched lay 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).
KEEP_ALL_BACK
Marks all unmatched back 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).
KEEP_ALL_LAY
Marks all unmatched lay 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_AUTO1 <automation rule name>
Assign an Automation rules file to the market in Guardian
(using the Automation Rules 1 column)
CLEAR_AUTO1
Clears the rules file from the market in Guardian
(using the Automation Rules 1 column)
Note: Similar commands exist for Automation Rules columns 2 to 5
 
 
 
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:
 
SET_SV will normally store a numeric value, but if you want it to store Text then the value specified in the Excel command should be placed in quotes.
e.g. SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 VALUE:"This is text"
 
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.