Betting on selections whose IDs are given in Excel BetFair betting bot - MarketFeeder Pro - triggered automated betting software

Either back or lay on the selections whose order is specified by the numbers given in an Excel spreadsheet.

For example, you enter the IDs of the horses you want to bet on a daily basis, in an Excel spreadsheet. See below:

This means you want to bet on the second, seventh and eighth horse in a race. The numbers in the sheet indicate the position of the horse in the list of selections that BetFair forms for each market.

1. Create a spreadsheet where you will insert the values that the trigger must refer to.
2. Give the sheet where these data will be stored some name, for example, "Sheet1".
3. Now you need to allocate the cells where you will input the indices of selections. For instance, A1:A5 or A1, B1, C1. There can be any number of cells as you may want to bet on any number of selections.
4. Save the sheet somewhere where you'll be able to find it later.
5. Create the following trigger:

Action: back (or lay)
Price, Amount: type in the corresponding values
Markets, Market Status: select appropriate
Selections: All Matching Selections
Conditions are met:
Any Selection's Rank is in list cell_Sheet1_A1, cell_Sheet1_A2, cell_Sheet1_A3, cell_Sheet1_A4 ...

Instead of the ellipsis continue the list of the cells where selections IDs are stored. If there is only one such cell, then certainly the list will end at cell_Sheet1_A1.

The addresses of the cells are made up as an example. Your sheet may be called in a different way, for example "selections". In that case the address of the cell will be cell_selections_A1, or cell_selections_B5 if you choose another column and row.

6. Press the "Launch Excel" button. The program will connect to the sheet that you have just created.
7. Now add the markets you want to trade in to "My Markets", and start monitoring them. The trigger will check the aforesaid cells and place the bet on the selections with those indices.
8. Be sure to always open the previously saved sheet before pressing "Launch Excel", in order to make MF Pro connect to that sheet instead of creating a new one.

You can read the details on Excel-related variables in the help file's chapter "Trigger Variables" / "Excel-Bound Variables".

In order to place bets using only one trigger for all the markets you'll be monitoring, you can insert the list of selections IDs in the corresponding market sheets. These market sheets are created automatically for each market in "My Markets" list as soon as you press the "Launch Excel" button. They are named after the ID of the market. You can allocate a special column for the selections IDs, for example, P, and insert them in each market sheet. Then modify the above trigger:

Conditions are met:
Any Selection's Rank is in list cell_querymarket_id_P1, cell_querymarket_id_P2, cell_querymarket_id_P3, cell_querymarket_id_P4 ...

In this example the trigger will bet on "Miss Sophisticat", "Blue Dynasty" and "Zafisio" in the race "16:50 Sand", and also on other horses whose IDs will be stored in the first three cells of the "P" column of other market sheets.

If you have the names of selections rather than their IDs, then it is more reasonable to use the "Import selections for auto-trading" button. See an example here.

• About
• Solutions
• Demo Pics & Videos
• FAQ & Support
  1. FAQ
  2. System Requirements
• TRY and BUY
• MarketFeeder Blog