Help with a trigger

[wine]

Hi,

I've tried this and the trigger isn't working. I'm using it on soccer markets inplay.

=IF(AND($E$2="In Play",$F$2="",$R12>=3,$R12<=7),"BACK-TL5-IP","")

Any ideas where i've gone wrong?

When it is working, i'd like to repeat the trigger if the first one is matched, (both back and tick offset). If someone could show me how that's done, i'd be very grateful.

Thanks for your help.

[U.F.O]

Nothing wrong with your if statement,
providing the cell F2 is actually empty ie not 0

what info goes in cell F2 anyway ?

[U.F.O]

Oh I see now
Suspended is displayed in F2

that should work fine then,
if it doesn't it means something else other than a blank is being displayed in that cell when suspended is not, if that makes sence.

[GaryRussell]

When you set up the Excel link tick "Offset bet matched flag" under "Additional columns". Column Y will contain "Y" when both bets are matched. You can than use a formula like the following.

Code: Select all

=if(Y5="Y","CLEAR",IF(AND($E$2="In Play",$F$2="",$R12>=3,$R12<=7),"BACK-TL5-IP","")
)

[wine]

When you set up the Excel link tick "Offset bet matched flag" under "Additional columns". Column Y will contain "Y" when both bets are matched. You can than use a formula like the following.

Code: Select all

=if(Y5="Y","CLEAR",IF(AND($E$2="In Play",$F$2="",$R12>=3,$R12<=7),"BACK-TL5-IP","")
)

Thanks for that formula. Does the first "if" have to be lower case?

Also, will the persistance be "keep" on these bets? If not, is there a way of doing that?

I'll try this out later, and let you know how it went.

Thank you once again.

[GaryRussell]

No, it doesn't matter if upper or lower case. "-IP" on the end of the trigger means that both back and offset lay bets will be keep bets.

[wine]

Great. Thank you very much!

[wine]

Hi

It's not placing the bets. I've noticed that in column Y, it's displaying an N. Presumably it needs to display Y for a bet to be placed?

Best regards

[GaryRussell]

No. That won't be it. If it's not placing bets in the first place then there's possibly something wrong with your formula or your understanding of how it works. It will only display "Y" when the back bet has been placed and matched and then it will fire the CLEAR trigger which will clear column T so that the next bet can be triggered. A bet can only be triggered when column T is blank.

1) Is your trigger appearing in column Q and are columns R and S polulated?
2) If the answer to question 1 is yes then is column T blank so that it can place a bet?

[wine]

Hi
I'm replying on a different PC to the one I normally use, so I can't check at the mo.

I tried the trigger on the horse racing, and it worked, so I guess it's set up for horse racing. Are there different columns in the football? Also, i'd like to use the coupon markets in soccer inplay over/under 1.5, so there are lots of matches, would the trigger need to be different for that?

I just want to back then tick offset 5.

Also, can I specify between which minutes of the match to bet?

Thanks for your help.

[GaryRussell]

It's not just horse racing. It shouldn't matter which market you are using it on. There is nothing different about football markets.

Which bets aren't being placed, the back bet or the lay bet?

BA does not know when a market turned in play so you would need to be linked to the market before it went in play and capture the time when "In Play" appears in cell E2. You will need to use VBA to capture this.

You could use the following code in sheet1 module to output the number of minutes since the market turned in play to cell [T1] and then use this in your trigger formula. It will only work if the market was not in play when you first linked it.

Code: Select all

Option Explicit

Dim inPlayTime As Date
Dim turnedInPlay As Boolean
Dim currentMarket As String

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 Then
       If [A1] <> currentMarket Then
           currentMarket = [A1]
           turnedInPlay = False
       End If
       If [E2] = "In Play" And Not turnedInPlay Then
           turnedInPlay = True
           inPlayTime = Now
       End If
       Application.EnableEvents = False
       If turnedInPlay Then [T1] = DateDiff("n", inPlayTime, Now) Else [T1] = 0
       Application.EnableEvents = True
    End If
End Sub