Trimmer

[gvigliani]

Hello Russ,
I am a VB6 programmer and I use this platform to drive the bets made with the BA. I have a problem. If I place a bet with the usual method by inserting "BACK" in the space of the trimmer, after a few seconds I see a reference number that gives me the OK on matched. But when I use a special type trimmer "BACK-TL5" I have the reference number on the first part of the bet but I do not have the reference number on the next bet in Lay. How could we solve the problem?
Thanks

[gvigliani]

Russ, I'm sorry but I forgot another detail. As can be solved the problem of the correct start time of the event? The BA tells me all the time time before the beginning of the event but then after it started there is no way to trace the minutes right. You have some solution for this problem?

Thanks again

[GaryRussell]

Have a look at the following thread. I implemented a new column to show the bet refs of the offset bets. See the messages from 1st August onwards.
http://gruss-software.co.uk/forum/viewt ... c&start=15

The API does not provide the actual start time of an event after it has started. The only way you can capture it is to continuously monitor cell E2 for when it first displays "In Play" and capture this time.

[gvigliani]

The API does not provide the actual start time of an event after it has started. The only way you can capture it is to continuously monitor cell E2 for when it first displays "In Play" and capture this time.

Excuse me Gary but time in cell H7 in prelive is eg: 0.31.58 0.31.57 etc.
When event is in time this Cell is eg: -1:23:28

1) Why minus sign??
2) - 1 is the HOUR??
3) 23 it's the minutes??
4) 28 it's the second ??

Unfortunately not

[milfor]

Without a minus sign it's the time UNTIL the scheduled off.
With a minus sign it's the time SINCE the scheduled off.

[osknows]

You can track exactly when the market has gone into play by doing the following

Cell D2 is the refreshed time from BA to excel
Cell Q3 is Time Market went into play (placed by VBA code below)
Cell U3 is seconds since market went into play (excel formula)

excel formula in U3

Code: Select all

=IF(ISERROR((MID(D2,2,2)*60*60+MID(D2,5,2)*60+MID(D2,8,2))-(MID(Q3,2,2)*60*60+MID(Q3,5,2)*60+MID(Q3,8,2))),"",(MID(D2,2,2)*60*60+MID(D2,5,2)*60+MID(D2,8,2))-(MID(Q3,2,2)*60*60+MID(Q3,5,2)*60+MID(Q3,8,2)))


VBA to place time market went into play in Q3

Code: Select all


    'log time race went in play
 Application.EnableEvents = False
    If Cells(2, 5).Value = "In Play" And Cells(3, 17).Value = "" Then
      Cells(3, 17).Value = Cells(2, 4).Value
    ElseIf Cells(2, 5).Value <> "In Play" Then
      Cells(3, 17).Value = ""
    End If
Application.EnableEvents = True

eg. market went into play when D2 was -00:02:01

then when D2 = -00:02:13; Q3 = -00:02:01, U3 = 12