Author Topic: FOOTBALL HT Score trigger  (Read 8463 times)

Tags:
  • All members
  • Posts: 82
FOOTBALL HT Score trigger
« on: 30 Sep 2013, 12:09 »
MarkV,

Got a bit of a challenge here and not sure how easy this is to do as a trigger.

What I want to be able to do is have a excel file or text file which has each score (0-0, 1-0, 2-0, 2-1....) and then a BACK and LAY price next to each.

From this I want to have the trigger run on all correct score games in the premiership and at HT it either backs or lays dependant on the price in the market at a given time (eg 53minutes after going in-play), or a no bet if it falls between the two odds specified.

Is this possible?

The working example would be that it is 1-0 at HT and the price is 4.2 to back and 4.3 to lay. In this case I would want it to lay the score at the lay price. If in this example the prices were 5.5 and 5.6, I might want it to back at 5.5.
I would need it so that I can edit the prices for each score it would back/lay at each month.

Let me know if I am not clear at all.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #1 on: 30 Sep 2013, 16:53 »
Hi
Thanks for the new topic.
Quote
From this I want to have the trigger run on all correct score games in the premiership and at HT it either backs or lays dependant on the price in the market at a given time (eg 53minutes after going in-play), or a no bet if it falls between the two odds specified.
How would the choice of either back or lay work? In your working example, how do you determine "back" if the price is 4.2 4.3, or "lay" if the price is 5.5 5.6?
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: 82
Re: FOOTBALL HT Score trigger
« Reply #2 on: 30 Sep 2013, 19:06 »
Hi MarkV,

Basically I decide the prices I want the trigger to back at and to lay at.

Take for example:
0-0 - I would want it to back if the price at HT was greater than 5.2, but lay if less than 4.3. If it was any price in between (4.4, 4.5, 4.6, 4.7, 4.8, 4.9, 5.0 and 5.1) it does nothing.
So I need it to take the current price, then lookup whether it shoudl back.lay dependant on the price and then perform the bet as expected.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #3 on: 30 Sep 2013, 19:28 »
Ok thank you.
one more question for now:
is this to operate on all selections in Correct Score market including Any Unquoted?
or
please provide a list of the scorelines you want to trade
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: 82
Re: FOOTBALL HT Score trigger
« Reply #4 on: 30 Sep 2013, 19:51 »
Yes I want it to have all the possible score lines included, but I want the trigger so that I can change the back/lay price of each individual score each month.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #5 on: 01 Oct 2013, 10:26 »
Hi MarkV,

Basically I decide the prices I want the trigger to back at and to lay at.

Take for example:
0-0 - I would want it to back if the price at HT was greater than 5.2, but lay if less than 4.3. If it was any price in between (4.4, 4.5, 4.6, 4.7, 4.8, 4.9, 5.0 and 5.1) it does nothing.
So I need it to take the current price, then lookup whether it shoudl back.lay dependant on the price and then perform the bet as expected.
Hi
Please can you confirm as per the above example:
0-0 example range 4.3 5.2 back if HT price is greater than 5.2, or lay if HT price is less than 4.3
0-1 example range 6.00 7.00 back if HT price is greater than 6.00, or lay if HT price is less than 6.00
etc..

in other words
will you ALWAYS back if HT price is greater than range high for that score
will you ALWAYS lay if HT price is greater than range low for that score
?
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: 82
Re: FOOTBALL HT Score trigger
« Reply #6 on: 01 Oct 2013, 13:32 »
Mark,

The problem I have is that I want to be able to adjust each of the criteria each week/month.

Currently I would like:
Score    BACK IF GREATER THAN       LAY IF LESS THAN     
0-0    4.77     4.41
         
0-1    6.57     6.04
         
0-2    2.00     1,000.00
         
0-3    2.00     1,000.00
         
1-0    4.91     4.54
         
1-1    4.82     4.45
         
1-2    9.40     8.60
         
2-0    5.73     5.28
         
2-1    5.55     5.12
         
2-2    2.00     1,000.00
         
3-0    5.20     4.80
         
3-1    2.05     1.95
         
4-0    2.05     1.95
         
4-1    2.00     1,000.00


Let me know how you get on.

Thanks,
Tom.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #7 on: 01 Oct 2013, 13:35 »
That's great, thanks. Yes, you will be able to adjust the criteria.
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.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #8 on: 01 Oct 2013, 15:25 »
Hi
Some of the scorelines you listed are not selections in the Correct Score Market.
I will continue with the trigger for now with Correct Score scorelines only and we can look at the others later.
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.

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #9 on: 01 Oct 2013, 20:23 »
Hi
Please find attached the trigger file and an Excel file.
You will see from the trigger conditions that specific cells are referenced for the criteria. These must not be changed or the trigger will not work, or if you do change the cell references, you need to do the same in the trigger.

I have tested it on 3 games tonight and all looks to be in order, but please do use test mode yourself for trying this out.

I made an xls file because I do not know the version of Excel you have, but it should work in any Excel and of course you can set your own prices in the Excel file.
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: 82
Re: FOOTBALL HT Score trigger
« Reply #10 on: 05 Oct 2013, 15:09 »
Thanks MarkV,

Seems to be a bit of an issue. Take the Fulham v Stoke game today (on now), the 0-0 price is 3.5 and having prices the following prices, it has backed the selection instead of laying the selection.

 Index   ScoreLine   Back if greater than   Lay if less than
         
1            0-0                   5.91                         5.44
2            0-1                   5.05                         4.66
3            0-2   17.80   16.20
...


Why does it back in this case, as it should lay?
Is it because I didn't click on the 'Launch Excel' and connect to an already open instance of Excel, therefore it doesn't lookup against any spreadsheet?

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #11 on: 05 Oct 2013, 16:50 »
Thanks MarkV,

Seems to be a bit of an issue. Take the Fulham v Stoke game today (on now), the 0-0 price is 3.5 and having prices the following prices, it has backed the selection instead of laying the selection.

 Index   ScoreLine   Back if greater than   Lay if less than
         
1            0-0                   5.91                         5.44
2            0-1                   5.05                         4.66
3            0-2   17.80   16.20
...


Why does it back in this case, as it should lay?
Is it because I didn't click on the 'Launch Excel' and connect to an already open instance of Excel, therefore it doesn't lookup against any spreadsheet?

Hi
Yes - it is because it is not picking up your prices from Sheet1
you should open the workbook in Excel
then click Launch Excel
and answer Yes to connect to the already open instance of Excel
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: 82
Re: FOOTBALL HT Score trigger
« Reply #12 on: 06 Oct 2013, 10:18 »
Works a treat, thanks MarkV.

  • All members
  • Posts: 82
Re: FOOTBALL HT Score trigger
« Reply #13 on: 06 Oct 2013, 10:21 »
Last little question:

In the price part of the trigger (for the back bet) if i put the following in, will it work still?

=IF((back_amount*0.35)>lay_amount,lay_price,back_price)

I basically want to say, if the amount on the back side is 75% greater than the lay side, then put the back bet in at the lay price, if not then back at the back price and take the odds.

On the flip slide, for the lay block I have the following:

=IF((lay_amount*0.35)>back_amount,back_price,lay_price)



Hope they will work and not cause the trigger to not do anything?

  • Moderator
  • Posts: 3597
*
Re: FOOTBALL HT Score trigger
« Reply #14 on: 06 Oct 2013, 11:13 »
Hi
That should be OK. Just don't include the "=".
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