How to log all the markets from a tab into a sheet using com

[enzoo]

Hi, I have a BA instance running with several markets opened in the first tab. I would like to log this tab with all the markets into a sheet using com interface.

No problem logging one market, but I didn´t find the way to log more than one market into the same sheet, (newbbie using com).

Code: Select all


Private Sub ba_pricesUpdated()
    prices = ba.getPrices
    i = 4
    For Each priceItem In prices
        i = i + 1
        Cells(i, 1).Value = priceItem.Selection
        Cells(i, 2).Value = priceItem.backOdds1
        Cells(i, 3).Value = priceItem.layOdds1
    Next
End Sub


(I am using the test_BA example spreadsheet from the help)

[enzoo]

Any help?

[kiint]

I don't know about all the markets on a single tab but if you have your markets open on separate tabs then have a look at Osknow's postthat explains how to handle these through the COM interface.