Traded range in Excel

[vanbuuts]

Whats the simplest way to show which horses are currently trading at the top or bottom of their range in Excel?

The Excel link is great, but it gives you nothing on where the horses current odds are in comparison to where they have been previously.

Is this possible?

[Captain Sensible]

You can access traded volumes by using the COM features of BA, guess you'd only need to call it once when entering a maret and then just use last price traded if you need to extend the traded ranges.

[vanbuuts]

But if a horse was currently trading at 2.2 and had been as low as 1.96 and as high as 2.42 would it show that?

[Captain Sensible]

Traded volume shows the amounts that have been matched at each price point since the market opened on the site so would show all previous data regardless of when you enter the market.