Author Topic: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER  (Read 6674 times)

Tags:
  • All members
  • Posts: 105
MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« on: 04 Feb 2014, 21:12 »
CAN ANY ONE HELP ME TO  IMPORT AN EXCEL FILE IN MARKET FEEDER SOFTWARE AND SET UP A TRIGGER TO BET ON THE FAVOR IF THE PRICE IS LESS THAN THE GIVEN PRICE

HOME          AWAY         1          X           2
MAN UTD     ARSENAL     2.00    3.50      2.70

CHELSE        MAN CITY    2.90    3.30     1.90

I WANT TO INPORT A FILE IN THE ABOVE FORMAT AND USE A TRIGGER TO BET THE FAVOR IF THE OFFER BACK PRICE IS HIGHER  BY AT  LEAST 3 TICKS THAN THE FILES PRICE OTHERWISE IF THE LAY PRICE  IS SHORTER THEN LAY

FOR EXAMPLE IF MAN UTD OFFER BACK PRICE IS HIGHER THAN 2.06 THEN BACK IF IT IS UNDER THAN 1.94 THEN LAY

  • Moderator
  • Posts: 3605
*
Re: INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #1 on: 05 Feb 2014, 18:47 »
Hi
You may have to change the format of the Excel file, or even better if you are happy to use a text file it will help a lot. The format you have shown will not work, because each selection needs to be on a separate line. Also because we have a common selection "The Draw", we need to identify the market.

The following format will work for text files (easier to write triggers for) and Excel.
Spelling of selection names must be exactly as Betfair selection names.
[Real Madrid v Atl Madrid]Real Madrid   1.98
[Real Madrid v Atl Madrid]Atl Madrid    4.30
[Real Madrid v Atl Madrid]The Draw      3.80
[Preston v Nottm Forest]Preston         3.60
[Preston v Nottm Forest]Nottm Forest    2.24
[Preston v Nottm Forest]The Draw        3.60


If you can agree to the above format, ideally in a text file, I can write a trigger for you. Let me know if it's OK.

 
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: 105
Re: INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #2 on: 05 Feb 2014, 19:27 »
THANKS FOR THE REPLY,
YES IT IS OK !

I WILL BE HAPPY IF YOU CAN HELP ME TO SET UP A TRIGGER BCZ I CAN CHANGE THE FORMAT OF THE FILE

THANKS I WILL WAIT

NIKOLAS

  • Moderator
  • Posts: 3605
*
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #3 on: 06 Feb 2014, 11:59 »
Hi
Attached please find a trigger file and a sample text file.

The text file must have a Tab separator between the selection name and the price.
The trigger will back or lay the favourite according to your specification.
In the constants you can set
back price higher than ticks
lay price lower than ticks
minutes before the off to bet

Please try the trigger in test mode.
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: 105
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #4 on: 06 Feb 2014, 16:50 »
HI ,

THANKS FOR ALL

CAN I MAKE A LIST ONLY WITH THE FAVOR TEAM AND THE PRICE AS FOLLOW:

MAN UTD 2.00
ARSENAL 1.80

INSTEAD OF USING THE FORMAT

MAN UTD 200

FULLAM 3.30

THE DRAW 5.00

  • Moderator
  • Posts: 3605
*
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #5 on: 06 Feb 2014, 16:59 »
HI ,

THANKS FOR ALL

CAN I MAKE A LIST ONLY WITH THE FAVOR TEAM AND THE PRICE AS FOLLOW:

MAN UTD 2.00
ARSENAL 1.80

INSTEAD OF USING THE FORMAT

MAN UTD 200

FULLAM 3.30

THE DRAW 5.00
Hi
Yes that will be fine. Just make sure there is a single Tab between selection name and price.

Load Match Odds Markets
Use Import Selections for auto-trading button on My Markets
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: 105
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #6 on: 06 Feb 2014, 19:27 »
I did but always put a back bet on favor without to check the imported price if it is lower or higher

  • Moderator
  • Posts: 3605
*
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #7 on: 06 Feb 2014, 19:38 »
I did but always put a back bet on favor without to check the imported price if it is lower or higher
Hi
Please can you attach the text file you are using so I can check it.
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: 105
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #8 on: 06 Feb 2014, 19:59 »
here it is

  • Moderator
  • Posts: 3605
*
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #9 on: 06 Feb 2014, 20:33 »
Hi
Your file had some strange price of 1050.00 and there was a space before the tab on one selection. Of course you need to have realistic prices in the file.

I tested it OK.
The trigger will back if the best back price is at least 3 ticks higher than file price
The trigger will lay if the best lay price is at least 3 ticks lower than file price
It will do nothing if the prices do not meet the above.

The attached text file is for 2 games later tonight. You should get 1 back bet and 1 lay bet if prices do not move too much.

Set the minutes before the off constant to say 300 just to test it.
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: 105
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #10 on: 06 Feb 2014, 21:03 »
THIS CAN BE APLY AND FOR THE AWAY TEAM;;;;;;

NAME(TAB)PRICE

  • Moderator
  • Posts: 3605
*
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #11 on: 06 Feb 2014, 21:08 »
THIS CAN BE APLY AND FOR THE AWAY TEAM;;;;;;

NAME(TAB)PRICE
Yes you can do that, but not for "The Draw". You will need to add the market name as shown earlier for "The Draw".
The trigger is set to bet on the favourite so you may need to change that
or let me know what you want to do and I will change it for you.
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: 80
Re: MOVED:INPUT AN EXCEL FILE AND SET UP A TRIGGER
« Reply #12 on: 09 Feb 2014, 16:26 »
Is there any plans of having The Draw possible in the future versions though?
We only live once.

 

Please note, BetFair is seems to be currently OFFLINE