Win bet placement from Excel file

Hi,
I am a little ring rusty as been concentrating on building models and data management for the past couple or so years.
Now with the restart of racing looming I would like to place win bets from an Excel file.
Bets to be placed 2 minutes before official off time and BSP odds >2.4
Can someone please assist
Many thanks
Ian

The content in this post is good content that is suitable for those who are looking for various content.

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
  

Mark, Thanks for the link however I would like to go the Excel route
as I potentially will bet 60+ selections on any given day.
I checked out the Excel help section but it was mostly troubleshooting.
Is there a video ?
I simply want to put on a list win bets at >2.40 at around 1 min before OFF 
Thanks
Ian

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

The idea of formatting 60 runners with "" for runners with 2 or more parts to the name sounded a 
bit daunting. Perhaps I am a lazy git. I guess I'll have to do that if as you say the Excel route is more complex.
Cheers
Ian

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

That makes it easier. Just one question though. In the example above the runner Docklands is a single word. Will the "" surrounding it still work
or would I need to remove them ?

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

hmm just tried that formatting and I got triple quotes in the text file. need to research more on Excel formatting, will post here.   

I tried and I get double quotes in Notepad.

Here are my early bets for Monday showing double Quotes
"Al Ozzdi"
"Stone Mason"
"Dancin Boy"
"Bonds Boy"
"Ice Pyramid"
"Alignak"
"Thibaan"
"Hatheem"

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

Are your source cells in Excel set to General format ?

teamwork