"Trigger After" Feature

[excelhasey]

I don't fully understand this button / option / feature

I have just had a play on todays racing and the trigger option in conditional betting is saying 10:34:22 but the first race is in about 3 hours time, so what is it triggering ??

Is it triggerring my bets to be active in 10 and half hours time in which case the race is over ??

Do I have to manually change this to say 3 hours so it triggers just before the race ??

Or are these conditional bets ready to go and the trigger time is irrelevant ??

I have ticked Active and also In-Play

Can someone help please ??

[GaryRussell]

It means that the bet can only be triggered after the time specified even if the conditions are met. eg. if you enter 13:00:00 then the bet can only be triggered if the conditions are met after 1pm.

[excelhasey]

Ah right brilliant

Ok so when I log current prices in Excel how do I set up a time trigger so the spreadsheet doesn't become ACTIVE until, say, 20 seconds before the off (presumably this will obviously have to be the scheduled off time), i.e. I am not Backing or Laying at ridiculous under or over inflated prices

Thanks

[GaryRussell]

You make it part of the criteria in the trigger formula. See http://gruss-software.co.uk/forum/viewtopic.php?t=4886 for an example.

[excelhasey]

Yes I have copied that into S1 thank you, great stuff

Now that is counting down to the scheduled start time, what about a count from the moment E2 changes to "In Play" ??

Cheers

[GaryRussell]

Yes I have copied that into S1 thank you, great stuff

Now that is counting down to the scheduled start time, what about a count from the moment E2 changes to "In Play" ??

Cheers

You need to use VBA to achieve this. Put the following code in sheet1. It will put the seconds from the off in cell T1 and when not in play T1 will be blank.

Code: Select all

Option Explicit

Dim inPlay As Boolean
Dim inPlayTime As Date

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If [E2] = "In Play" Then
        If Not inPlay Then
            inPlay = True
            inPlayTime = Now
        End If
        [T1] = DateDiff("s", inPlayTime, Now)
    Else
        If inPlay Then
            inPlay = False
            [T1] = ""
        End If
    End If
    Application.EnableEvents = True
End Sub

[excelhasey]

I added the code below late yesterday to a spreadsheet of mine and I started working / counting, I then shut it down and switch PC off

I have just opened the spreadsheet again now and the market has been updated with the latest horse race but this value is now 1182 and counting, it is as if it has started re-counting from where it was last switched off

Any ideas how to re-set this when the market auto refreshes ??

[excelhasey]

My apologies on the 2nd race re-fresh all is working fine, bizarre thanks anyway