To submit a bet from Excel you must ensure that you use the correct trigger keywords along with odds and stake.

The odds and stake columns (R & S) must be populated before the trigger column (Q).

If the odds in column R are not valid Betfair odds then they will be rounded to the nearest valid odds when the bet is submitted.

Please note that all triggers are in uppercase.

​

Excel is refreshed according to the refresh rate as set in Betting Assistant.

​

On each refresh Betting Assistant checks the trigger columns and takes the appropriate action.

​

If the trigger is to submit a bet then the Bet Ref column will display PENDING until it is replaced with the actual bet reference which should only take milliseconds to happen unless the bet is being submitted whilst a market is 'in play' where all bets are subject to a Betfair imposed delay of between 1 and 9 seconds depending on the sport.

​

Once the bet reference is returned then the Bet Time, Avg Matched Odds, Matched Stake and Profit/Loss columns are also populated.

​

If the bet is unmatched then the Matched Stake will display 0.

The trigger keywords are categorised as follows:-