getMarketDepth

[alrodopial]

Hi,

Inside the "Worksheet_Change" event ( If Target.Columns.Count = 16 Then) I have the "ba.getMarketDepth False"
There is also the function "ba_getMarketDepthComplete" that is also been running

1. At which point does the "getMarketDepth " runs? (at the end of "Worksheet_Change" event ? (this is what i think))
2. When the "ba_getMarketDepthComplete" runs? (at the end of "Worksheet_Change" event ? (this is what i think))
3. When BA takes the triggers from column Q? (and submits a bet) (before the "Worksheet_Change" event takes place - so before the odds been updated- , at the end (after) of the "Worksheet_Change" event or at the end (or start) of the "ba_getMarketDepthComplete" run)????
Thanks
Al

[GaryRussell]

The getMarketDepthComplete event is called as soon as the data has been returned by the API and as soon as Excel is ready to run the code. If the API is slow to respond then there could be several worksheet_change events run in between. The only thing you can guarantee is that if you call getMarketDepth in the background in the change event is that getMarketDepth complete cannot be called before executing the remaining code in the change event. Basically this event can be called at anytime after you make the call and no other code is running.

If you want to ensure you have the latest data before triggering bets then you could set a flag before making the call to indicate the data is pending and set it again when getMarketDepthComplete has been called.

[alrodopial]

Thanks for the above
Now the below:

3. When BA takes the triggers from column Q? (and submits a bet) (before the "Worksheet_Change" event takes place - so before the odds been updated- or at the end (after) of the "Worksheet_Change" event )????
Thanks
Al

[GaryRussell]

Triggers are processed after the worksheet change event so the most recent odds are used.