Double Betting

[steven]

I'm just getting started with vba triggered betting, and I have hit a slight hicup. When I trigger a bet and the bet reference is returned on the following update, then all is well, but occasionally the bet isn't matched untill the second time round and this is activating a second bet being placed. I have a flag which is set when a bet is placed, in order to stop any further bets occuring by the program untill a bet is fully matched, and this appears to work, but there is still a second bet going off for the same amount and oods. Is this me (very likely) or is BA picking up on the "BACK" trigger twice when the Reference cell is still empty and sending a second bet. I am just using the standard 1 second interval for updates.
Thanks

[GaryRussell]

If your VBA code is inserting the trigger during the worksheet_change event then this can cause problems if you don't insert the trigger during the appropriate update. We advise that you only insert the trigger when the prices are updated. See example code below. Note that it only runs when the updated column count is 16 which is when the prices are updated and the triggers are processed by Betting Assistant. It also disables events because when your code inserts the trigger it will cause the event to fire again unnecessarily. It's definitely not BA picking up the empty cell just because it isn't matched. It actually inserts "PENDING" before the bet is even placed to prevent multiple bets.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 Then
        Application.EnableEvents = False
        ' insert your code here
        Application.EnableEvents = True
    End If
End Sub


[steven]

Thanks Gary I just needed the confirmation that it's me. My code is in the correct place and fires at the correct time. But then it gets complicated. I do not get the Pending notification, so i guess my sequence is too long or I'm missing something and overwriting the columns Q-T again. I figured you would have put in place a check, I must be messing it up. Can I find the timing and sequence of events that BA goes through anywhere, so that I can trim down my code and fit it in the gaps.
Thanks