Home > Betting Assistant Features > Excel Triggered Betting > Special Trigger Cells > Cell Q2 > Q2 Other

Q2 Other

Use the triggers listed below to force Betting Assistant to do the actions specified.

Trigger Description Notes
n Sets the Refresh Rate where n represents the seconds required.     
-1 Select the next market in the Quick Pick List. If no market is already selected then the first in the list will be selected.
-2 Select the previous market in the Quick Pick List.  
-3 Reload the Quick Pick List according to the option set in preferences. This option can be used to run BA continuously without user intervention 
(eg. Reload the quick pick list each morning to load the current day’s racing)
Use -4 to load the different venues into separate tab pages
-5 Select the first market in the Quick Pick List.   
-6 Refresh the bet results sheet, if you are using this option.   
-7 Clears the bet results sheet, if you are using this option.   
-8 Removes the current market from the Quick Pick List   
-9 Adds existing market bets to Results   
 -10 Reloads the current market If Betfair have changed the order of the runners or there are now non runners since the market was opened then you can use this trigger to reload the current market to reflect the new order of runners.
GO:n Use this trigger to open a specific market where n
represents the Betfair Market ID
The Market ID is output in cell N3.
You must already have a market open in the worksheet before using this trigger
PRICE-STREAM-ON
Sets Price Streaming on
PRICE-STREAM-OFF
Sets Price Streaming off

ORDER-STREAM-ON
Sets Order Streaming on

 ORDER-STREAM-OFF
Sets Order Streaming off

ALL-STREAM-ON 
Sets Price Streaming & Order Streaming on

ALL-STREAM-OFF
Sets Price Streaming & Oder Streaming off

FULL-STREAM-ON
Enables Full Price & Order Streaming
Price and Order streaming need to be on for this to take effect 

FULL-SREAM-OFF

Disables Full Price & Order Streaming As above 
LQP:n

Load the Quick Pick List from a saved file where n is the name of the file

See Saving / Restoring Markets

LQPC:n Load the Quick Pick List from a saved file and then open all the markets in a Coupon View  
LQPS:n Load the Quick Pick List from a saved file and then open all the markets in separate tab pages
 
AQP:n  Add markets to the Quick Pick List from search criteria where n is the search text and parameters

For example:- 

AQP:soccer+over/under+2.5_Y_N (only include markets going in play which is the default)

AQP:soccer+over/under+2.5_Y_Y (include all markets)

AQP:soccer+over/under+2.5_N_Y (only include markets not going in play)

CASHOUT-n 

Sets Betfair's Auto Cash Out option where n represents the value to use for the cash out. 

Use 0 to cancel once set.

Note this is not an API call, it just sets the option as seen on Betfair's website. 

See Betfair Auto Cash Out

The Bet Ref column must already be populated with something to use this trigger.

Once it is triggered the Bet Ref column will be replaced by AUTO-CASHOUT-SET, AUTO-CASHOUT_CANCELLED or AUTO-CASHOUT-FAILED

Note that a new cash out amount cannot be set until previous value has been cancelled.





See also