Home > Betting Assistant Features > Excel Triggered Betting > Additional Columns

Additional Columns

When you start logging to Excel there are some additional columns that you can optionally select.


These additional columns will appear in columns Y onward assuming your starting column is A.


Please note that in order to use any of these columns you must have "Enable triggered betting" ticked at start of logging.


The available columns are as follows:-

Data Item Description Notes
SP Displays the Betfair SP (pre-play it is the projected SP and In play it is the actual SP).

See Betfair's SP The Basics for more info on SP betting.

Saddle Cloth The number on the saddle cloth. Applies to Horse Racing Markets.                                              
Form The horses recent form. As above.
Days Since Last Run The number of days since the horse last ran. As above.
Jockey

The name of the jockey.

Please note: This field will contain 'Reserve' in the event that the horse has been entered into the market as a reserve runner.

Any reserve runners will be withdrawn from the market once it has been confirmed that they will not run.

As above.
Trainer The name of the horse's trainer.
As above.
Owner The owner of the horse. As above.
Age / Weight The age and weight of the horse. As above.
Bred The country in which the horse was born. As above.
Dam The name of the horse's mother. As above.
Sire The name of the horse's father. As above.
DamSire The name of the horse's grandfather. As above.
Colour / Sex The colour and sex of the horse. As above.
Official Rating The horse's official rating. As above.
Forecast Price The horse's forecast price. As above.
Jockey Claim The reduction in the weight that the horse carries for a particular jockey where applicable.
As above.
Wearing Any extra equipment the horse is wearing. As above. 
Stall Draw The stall number the horse is starting from. As above. 
Offset bet matched flag A flag that signifies whether or not an offset bet generated by Tick Offset or Stop Loss is fully matched. Flag will be Y for fully matched. 
Offset bet references The Betfair Bet Reference for the offset bet generated by using the Tick Offset or Stop Loss functions. If more than one bet reference is generated then they are delimited by ; and suffixed by the following:-
P offset bet placed as a result of original bet being partially matched.
F offset bet placed as a result of original bet being fully matched.
S offset bet is a Stop Loss bet.
So you could see several bet refs suffixed with P followed by a final ref suffixed with F or a final bet suffixed with S.
Average last price matched Displays a calculated average price for all traded amounts

To see the calculation used, download the following example:- Download link

Selection ID  Betfair Selection ID   
Silks URL  The URL address for the Jockey silks image  Applies to Horse Racing Markets 
Silks description A text description of the Jockey silks As above. 
Level Profit  Displays the potential level profit amount that could be achieved based on current market odds.   
Tennis Scores Live Tennis Score data 

6 columns of data will be output when using this option comprising the following:-

Sets, Games, Points, Server, Incident, Set Scores

The server column is a Y or N to indicate current server.

The set scores are delimited by a comma.

Race Status Displays the current status of a horse race market or greyhound market. See Race Status definitions for the list of possible text values.
Result Displays WINNER or LOSER for the selection once market is closed. Does not require a bet to have been placed to display the result.





See also