Default Columns
| Cell | Description | Notes |
| A1 | Market Name |
|
| D1 | Official Start time of the next market in Quick Pick List | If you are already at the last market in the list then the cell will be blank. Cell may need formatting as a time. |
| F1 | Full Market Path |
|
| I1 | Flag to indicate if Betfair SP is accepted |
Y=Yes, N=No |
| N1 | Parent Market ID of event | |
| P1 | API Market Version |
|
| B2 | Date Betting Assistant last updated the spreadsheet |
Cell may need formatting as a date |
| C2 | Time Betting Assistant last updated the spreadsheet |
Cell may need formatting as a date |
| D2 | Time until official start of the market |
Cell may need formatting as a date |
| E2 | In Play status |
"In Play" or "Not In Play" |
| F2 | Market status | Blank=Market Open, "Suspended"=Market Suspended, "Closed"=Market Closed |
| I2 | Account balance | Optional |
| J2 | Updates account balance and exposure |
See Special Trigger Cells |
| L2 | Exposure | Optional |
| N2 | Number of transactions in the hour |
See Transaction Charges for more details |
| Q2 | Controls Refresh Rate, Quick Pick Loading, Bet Results sheet |
See Special Trigger Cells |
| B3 | Total amount matched |
|
| E3 | Number of winners paid out on | |
| G3 | Number of non runners |
Applies to horse racing and greyhound racing |
| I3 | Flag to indicate if market allows 'In Play' betting |
Y=Yes,N=No |
| J3 | Quick Pick List position indicator |
F= First, L=Last, number=remaining number of markets in the list |
| L3 | Betfair imposed delay for "In play" markets (in seconds) |
0 when not in play, between 1 and 9 for "In Play" markets |
| N3 | Betfair Market ID | |
| P3 | Commission rate |
| Column | Description | Notes |
| A | Selction name | Column may need formatting as text |
| B | Best back odds 3 | |
| C | Amount available at back odds 3 | |
| D | Best back odds 2 | |
| E | Amount available at back odds 2 | |
| F | Best back odds 1 | |
| G | Amount available at back odds 1 | |
| H | Best lay odds 1 | |
| I | Amount available at lay odds 1 | |
| J | Best lay odds 2 | |
| K | Amount available at lay odds 2 | |
| L | Best lay odds 3 | |
| M | Amount available at lay odds 3 | |
| N | Reduction factor | Applicable to horse racing only |
| O | Last price matched | |
| P | Total amount matched for the selection | |
| Q | Trigger | See Triggers |
| R | Bet Odds | Must be populated before trigger |
| S | Bet Stake | Must be populated before trigger |
| T | Bet Reference | As returned by Betfair |
| U | Time Bet was accepted by Betfair | |
| V | Average matched odds | |
| W | Matched stake | |
| X | Profit / loss for selection |