Open your Workbook first and then Select 'Log Current Prices' from the Excel menu to open the following window:-
Please note that the Workbook needs to be on a local drive and not stored on a network drive such as OneDrive.
Select the required workbook and worksheet name using the drop down lists which should already be populated, unless you want to open a Workbook in a separate instance of Excel because you already have Excel open for something else.
If you are opening a separate instance of Excel then use the 'Browse' button to navigate to the Excel Workbook.
Select the "Top left hand cell" to log the data from, e.g. if you select A1 then columns A through to X will be used to display the Betfair data assuming that you haven't chosen to include any of the optional data columns.
If you have chosen any of the additional columns then these will appear in column Y onwards.
Please note that to use the additional columns "Enable triggered betting" must be ticked.
The first 4 rows are used for header data followed by the market selections.
Assuming A1 has been selected as "Top left hand cell" then Betting Assistant will populate the following cells as follows:-
If your workbook does not appear in the dropdown box the try clicking on the 'Kill all Excel porocesses' button but please be aware that this will close all instances of Excel.
After using this option click the 'Cancel' button and try again.
Tick 'Enable triggered betting' if you wish to place bets from Excel and/or you want to use any of the additional columns.
Tick 'Show balance' if you want your account balance and exposure to be displayed in Excel.
Tick 'Log bet results' to record your bet results in a separate worksheet (see Logging Bet Results).
Tick 'Log current bets' to record bets triggered from Excel to a separate worksheet (see Logging Current Bets).
Tick 'Export Quick Pick List' to export a list of the markets that are currently in the Quick Pick List (see Logging the Quick Pick List ).
Set your triggered betting options which are as follows:-
You can choose to have the CLEAR trigger clear the matched odds.
You can choose to have your bet refs cleared when markets are auto selected.
You can choose to have your bet refs cleared when markets are manually selected.
If you use the UPDATE trigger there also on option to append N to the the new bet ref.
You can choose to have the P&L column display the win and lose figures for multi-winner markets.
The win figure will be shown first followed by a semi-colon and then the lose figure.
You can choose to have the first market selected whenever a reload trigger is used to reload the Quick Pick List.
You can specify the batch size for below minimum stake bets, i.e. the number of bets that can be sent through in one request if you are betting on multiple selections at the same time.
You may need to lower the number if you have a small account balance.
You can specify the number of the bet requests to be sent when updating multiple bets at the same time.
There are optional additional columns of data that you can have included in your worksheet and these will occupy columns starting from column Y if you chose column A as your first column to log the data to.
A number of these additional data columns relate to horse racing so if you are logging a different sport then the columns will be blank apart from the header cell.