ecxel and BA

[alrodopial]

Hi ,
I'm asking this again, Garry / Mark can you post the "order" that ba communicates with excel?
First it updates the bets (4 columns) then the odds (16 columns) etc.

Or if it's hard - does it firstly updates the bets and then the odds?
Thanks

[GaryRussell]

It updates the odds and then the bets. I will post a complete list shortly.

[GaryRussell]

You can also get Excel to show you using the worksheet change event. The following code will show you the range being updated.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
    Debug.Print Target.Address
End Sub

[alrodopial]

It updates the odds and then the bets. I will post a complete list shortly.

That means that any VBA code that is based on odds is executed and after this if any trigger is put in column ..... is checked and the bet is send to BF from BA?

How does BA "understands" that my VBA code is finished so it is now time to check the betting triggers?

[GaryRussell]

When you use VBA code that is based on odds it should look like the following.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 Then
       ' your code goes here
    End If
End Sub

The above code executes immediately after the odds are written. Note that it only runs your code if the column count is 16 which is when the odds are written. BA does not need to "understand" that your code has finished. It cannot read or write to Excel while your code is running, it has to wait for it to finish. BA then reads the triggers.

[alrodopial]

Thanks , I thought it was the other way .

Does the refresh rate - Q2 - updates the same way?
or this one "is checked" before the odds update?

[GaryRussell]

Thanks , I thought it was the other way .

Does the refresh rate - Q2 - updates the same way?
or this one "is checked" before the odds update?

Q2 is checked before the odds update.