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. |