getMarketDepth for mulitple markets

[BFDon]

I'm trying to get away from using 'log current prices' because it's a bit annoying to do and just run a spreadsheet completely through COM. My issue is I cant seem to grab market data across many tabs effectively. I have assessed the getMarketDepthExample_Async_multisheet and it has 6 sheets all running the ba.getmarketDepth False command which fires through the worksheet_change event. Having set all the tabs to the same market I can see that these commands return and output the market depth within ms of each other.

However my code below will only raise 1 getmarketDepthComplete event even with 4 tabs open. Oddly if i just set ba.TabIndex = 0 and run the code if does loop it and raise the event 4 times

Code: Select all


Public Sub RequestMarketDepth()

Dim TabNumber As Integer


        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
        End If
       
    For TabNumber = 0 To 3
   
    ba.TabIndex = TabNumber
    ba.getMarketDepth False

   
    Next TabNumber
   
End Sub

Private Sub ba_getMarketDepthComplete(ByVal MarketDepth As Variant, ByVal resultCode As String)

MsgBox MarketDepth(0).Selection

End Sub