Win bet placement from Excel file

Hi
A couple of things to check first:
It is possible to import selection names from Excel but it would be much easier to have your selection names in a text file. The following two videos give an idea of how this would be done.
https://www.youtube.com/watch?v=JxBkUawZb2U
https://www.youtube.com/watch?v=-zNhSl5ypn0

Betfair Starting Price (BSP) is available at the off as soon as the market turns in-play. If you wanted to back at best back price 2mins before the off your trigger would be something like below:

this trigger does not need the import process, it uses a condition to check if the selection's name is in the text file

back
price: back_price
amount: xx
all matching selections
once per market
conditions:
markets minutes before the off is less than 2.00
and selections name is in file ...path to .txt file
and selections back price is greater than 2.40

if you want to go Excel route it can be done, worth looking at the Excel Interface section of the help file
  

Hi
I had a look for a video showing the Excel interface but could not find one. The helpfile section on the Excel Interface explains how it works, please see attached screenshot.
 
Your requirement is not complicated and the standard method for doing this is from a text file. Just save your Excel file as a text file (File > Save As > Type: .txt) and follow the formatting guidelines in the video. You can use the simple trigger above to place the bets. No problem with unlimited number of selections in a text file.

Using the Excel link to MFP to do what you want to do is going to be more complex as you will glean from the helpfile and it will be more cumbersome to operate.

As mentioned it is possible to code a trigger to bet through the link to Excel. Have a look at the helpfile and see what you think. Due to the complexity if you want it coded it would need to be through the trigger writing service.

My suggestion for your requirement is the easy way using .txt file

highlight the cells to format
right click > Format > Custom
paste this into the Type: box
\"@\"
click ok
 

yes it's fine to leave the quotes around single words, have a play in test mode

I tried and I get double quotes in Notepad.

Nice one, I'm still getting """three double quotes""" which I can find and replace

teamwork