getMarketDepth() COM function

[GaryRussell]

1) Download the following spreadsheet which uses the COM function to get the best prices.
https://www.gruss-software.co.uk/Excel/ ... xample.xls

2) View the user guide and following the instructions under "Using COM interface" to configure it.

3) Link BA to the spreadsheet. You should see the best back price in column Z and the best lay price in column AB.

[GaryRussell]

Version 1.1.0.66x61 Beta now supports asynchronous requests for getMarketDepth.

See https://gruss-software.co.uk/forum/viewtopic.php?t=6105

Here is an example spreadsheet which outputs the best 10 back and lay odds.
https://www.gruss-software.co.uk/Excel/ ... _Async.xls