Problem with GetPrices

[ipgriffiths]

Hi,

Firstly, I have joined up after using BA on trial for a month, and think it is superb - thanks for the hard work that has clearly gone in to it!

I have a small problem with some VBA I am writing. I have got it picking up in each race in turn, and 90 seconds before it starts I need it to grab the latest runners and prices.

I have got it to open up the correct market, and see it do so on the BA interface. However, when I call GetPrices, it sometimes reverts to what seems to be a random race from earlier in the day.

I am using the code pinched from the example in the help section:

"prices = ba.getPrices
x = 8
For Each priceItem In prices
x = x + 1
Cells(x, 2).Value = priceItem.Selection
Cells(x, 3).Value = priceItem.backOdds1
Cells(x, 4).Value = priceItem.layOdds1
Next"

Has anyone else had any similar issues, or got any tips on how to use the GetPrices function? I suspect I am missing a trick!

Many thanks,

Ian

[laffo16]

a ha, tought i remembered reading this somewhere, i havent quite put my finger on where the problem is yet but im having exactly the same problem where the previous markets data is taken from getPrices().

my code runs as follows:
loop {
$BAcom.openMarket()
$prices = $BAcom.getPrices()
}

in the first call of getPrices, it takes the prices from the market which was open previously. But all markets their for after seem to be ok. Acutaly come to think of it, i didnt check the other markets specificly. Will do more testing and post my findings later.

[laffo16]

Basicly when you change market using openMarket(), getPrices() requires approximately 0.1 secs to refresh its content with the new market otherwise it uses the data from the prev market.