Home > Betting Assistant Features > Excel Triggered Betting > Special Trigger Cells

Special Trigger Cells

As well as the trigger column for placing bets there are some other cells where you can force Betting Assistant to take some specific action.

So assuming that you started logging to Excel using the default A1 as the "Top left hand cell" then the Special Trigger Cells are J2 and Q2.

J2
Trigger Description Notes
U Updates your balance and exposure figures                                                    The cell is blanked by Betting Assistant once the action has been performed.



Q2
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 Refresh the Quick Pick List according to the option set in preferences. This option can be used to run BA continuously without user intervention
(eg. Refresh the quick pick list each morning to load the current day’s racing)
-4 Refresh the Quick Pick List but load the different venues into separate tab pages. This option can only be used on a spreadsheet linked to the first tab page.
-3.1 Refresh the Quick Pick List with All UK Win (Horse Racing) Use -4.1 to load the different venues into separate tab pages
-3.2 Refresh the Quick Pick List with All UK Place (Horse Racing) Use -4.2 to load the different venues into separate tab pages
-3.3 Refresh the Quick Pick List with All IRE Win (Horse Racing) Use -4.3 to load the different venues into separate tab pages
-3.4 Refresh the Quick Pick List with All IRE Place (Horse Racing) Use -4.4 to load the different venues into separate tab pages
-3.5 Refresh the Quick Pick List with All US Win (Horse Racing) Use -4.5 to load the different venues into separate tab pages
-3.6 Refresh the Quick Pick List with All US Place (Horse Racing) Use -4.6 to load the different venues into separate tab pages
-3.7 Refresh the Quick Pick List with All AUS Win (Horse Racing) Use -4.7 to load the different venues into separate tab pages
-3.8 Refresh the Quick Pick List with All AUS Place (Horse Racing) Use -4.8 to load the different venues into separate tab pages
-3.9 Refresh the Quick Pick List with All NZL Win (Horse Racing) Use -4.9 to load the different venues into separate tab pages
-3.11 Refresh the Quick Pick List with All RSA Win (Horse Racing) Use -4.11 to load the different venues into separate tab pages
-3.12 Refresh the Quick Pick List with All UK Win (Greyhound Racing) Use -4.12 to load the different venues into separate tab pages
-3.13 Refresh the Quick Pick List with All AUS Win (Greyhound Racing) Use -4.13 to load the different venues into separate tab pages
-3.14 Refresh the Quick Pick List with All UK & IRE Win (Horse Racing)    
-3.15 Refresh the Quick Pick List with All UK & IRE Place (Horse Racing)    
-3.16 Refresh the Quick Pick List with All UK Forecast Greyhound Markets    
-3.17 Refresh the Quick Pick List with All In-Play Soccer (Match Odds)     
-3.18 Refresh the Quick Pick List with All In-Play Tennis (Match Odds)    
-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   
GO:n Use this trigger to go to a specific market in the Quick Pick List
where n represests the Betfair Market ID
The Market ID is output in cell N3





See also