How to select different Markets.

[Royville]

Hello,

Using BA for Betdaq, I want to program my excel spreadsheet to select a market, - say 14:00 Redcar, record the current odds for each horse, then select another market, say Lingfield and record those odds, etc etc for about 8 races. I want to select these markets straight after each other.

Does anyone know if this is possable using excel, how could I do it?

Hoping you can help - thanks

Royville

[osknows]

There's 2 ways I know of, either ...

a)First you need the market ID's you want to navigate, eg 103688955. Then you can navigate directly to the market either using GO: 103688955 in cell Q2 in Excel

b) Using the COM. Assume cell F1 in sheet1/tab1 contains the market path Soccer\English Soccer\Npower League One\Fixtures 13 September\Sheff Utd v Huddersfield

then assuming 2 tabs are open in BA

Code: Select all

ba.TabIndex = 2
result = ba.openMarket(BAEvents(Sheet1.Range("F1").Value).eventId, BAEvents(Sheet1.Range("F1").Value).exchangeId)

will open the market in tab1 in tab2 of BA

[osknows]

Oh - just realised you mean Betdaq.. I'm not sure if all of this works in that version?
Sorry