COM vs Excel

[vanbuuts]

Hello all, I have an Excel file that currently places all my bets using formula to trigger the bets into the market when criteria is met.

This can be fairly clunky, and often I miss the position as the market has moved by the time my sheet places the bet into the market.

So my question is, does the COM option improve speed?

I have never really used it so do not understand how it works, but will tackle that separately - just want to establish if the benefits of the COM function is speed of bet placement and making the sheet quicker due to less continuous calculations

[MarkRussell]

Hi,

There is no speed advantage, COM offers more flexibility as it is all code based.

To get the best speed you need to optimise your code.

Regards,
Mark

[vanbuuts]

Thanks Mark, so a COM coded bot wouldnt fire a bet into the market any quicker than a well coded Excel bot?

[vanbuuts]

I ask specifically as I notice my Excel sheet quite often "freezes" and will miss 2 to 3 second at a time, sometimes up to 10 seconds. Not sure if this actually affects the bets going into the market,

I have even tried a plain Excel sheet with just a countdown to off clock and it does the same. Is there anyway to improve refresh rate when connected to Excel?

[Captain Sensible]

You probably need to be looking at when, and why, these 'freezes' occur especially if you're getting them with a blank sheet. Sometimes the market freezes in play but that'll be down to the API sending the data. Maybe look at monitoring your internet connection make sure that's not dropping.

[vanbuuts]

It’s all done via VPS. But perhaps as I have full stream enabled, it’s doing this an hour or so before the race as nothing changes second by second. Seems slicker now as race time approaches

[Captain Sensible]

That'd make sense as an hour out there's usually little activity so 10 seconds without activity might not be that odd. You could always monitor the change in total matched on a separate polled sheet to see if there are lulls in activity just to put your mind at ease.