Author Topic: Win bet placement from Excel file  (Read 13412 times)

Tags:
  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #15 on: 30 May 2020, 21:37 »
Is there a way of adding the bet amount to the text file ?
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #16 on: 31 May 2020, 06:25 »
If the bet amounts are in the next column in Excel, save the Excel file as Tab Delimited text. Triggering will be different to selections name is in file as above.

The text file will need to be imported into MFP (can be automated). The bet amount is then accessible in a variable imported_1 

This article describes it and shows how to write a trigger using the imported values
https://marketfeeder.co.uk/learn/articles/automating-betting-tips/ 

in your trigger you would put imported_1 in the amount field
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #17 on: 01 Jun 2020, 13:40 »
A tricky thing configuring it to bet via Excel to txt file.
I failed in several attempts.
Here's what I did.
1)  Saved an Excel file to Tab Delimited File contained names in one column and bet amount in the other.
2)  list in file saved to user owner mfp 8
3)  imported_1 in back amount

It worked if I just used the text file no bet amounts and names in "" 

Where am I going wrong ? any idea ? 

I was unsure what you meant by  "Triggering will be different to selections name is in file as above".  
Condition is: FALSE.
12:25:26Checking condition and Selection's Name is in file C:\Users\IAN\MarketFeeder Pro 8\Bets.txt.
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #18 on: 01 Jun 2020, 15:26 »
The trigger posted earlier will work if just the selections names are in the file. To be able to use data linked to specific selections e.g. bet amounts, the text file needs to be imported to MFP as described in this article
https://marketfeeder.co.uk/learn/articles/automating-betting-tips/


  • settings > monitoring options > market refresh > start monitoring 3 to 4 (ish) minutes before beginning
  • get tab delimited text file ready, "selection name"<tab>bet amount
  • load markets for the day into my markets
  • press the button: import selections for auto-trading, you will get a message saying how many were imported and you will see the non-imported selections greyed out in the markets
  • use the trigger below

back
price: back_price
amount: imported_1
all matching selections
once per market
conditions:
markets minutes before the off is less than 2.00
and selections back price is greater than 2.40

Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #19 on: 02 Jun 2020, 03:13 »
The importing of selection works okay.
However still getting the FALSE message from the trigger. (below)
The location is correct
I tried with and without quotes without success.
I then removed bet amounts with names still enclosed in quotes and bets were placed.
For some reason it doesn't like the bet amounts.


Condition is: FALSE.
02:40:23Checking condition and Selection's Name is in file C:\Users\IAN\MarketFeeder Pro 8\Bets.txt.
"Tough Remedy"   5
"Jackstar"   1
"Fahad"   4
"Lord Of The Sky"   1
"Arcanada"   5
"Sandret"   2
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #20 on: 02 Jun 2020, 06:29 »
The import process identifies the selections to bet on. Please remove the condition selections name is in file. See screenshot in reply #18, it shows the trigger.
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #21 on: 02 Jun 2020, 09:49 »
aah that's where I went wrong. Sorry for being such a dumb cluck. I tested it and all working perfectly now.
Thanks again Mark for your extreme patience.  Ian
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #22 on: 02 Jun 2020, 15:32 »
After a market is settled is there a way that it will move onto the next race without deleting settled markets ? I looked in settings but couldn't see anything.
Can you kindly confirm
Thanks
Ian
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #23 on: 02 Jun 2020, 16:34 »
Hi
untick: settings > general options > delete settled events automatically
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #24 on: 02 Jun 2020, 17:37 »
I was hoping the next race would open automatically after the previous one finished but it doesn't. Seems it can only be done manually by clicking on race. 
I was just exploring all possibilities. I'm completely sold on the bet placement system. Easy peasy :)
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #25 on: 05 Jun 2020, 17:53 »
I'd like all unmatched bets to be placed at 'SP'
I already ticked option in settings but on race screen it shows 'cancel' button depressed. Will the bets still be placed at SP ?
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #26 on: 05 Jun 2020, 18:04 »
In the trigger next to the amount you will see "cancel". Click on that and choose Take SP and save the trigger. 
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #27 on: 05 Jun 2020, 18:08 »
Oh of course, why didn't I think of that (don't answer:))
For some reason I was fixated on settings.
Thanks
Ian
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 832
Re: Win bet placement from Excel file
« Reply #28 on: 10 Jun 2020, 13:41 »
When a bet has been imported for auto trading how can I delete the bet if I later decide it is not required. ?
Thanks
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3654
*
Re: Win bet placement from Excel file
« Reply #29 on: 10 Jun 2020, 14:12 »
Hi
Edit the text file (remove that selection and save the text file) and re-import

 
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE