Excel Trigger Lagging

[Frenszisz]

Hi all!

I started to use BA excel betting a few days ago to horse racing only inplay.
My problem is when the trigger put eg. lay the excel slow down and sometimes the program too.
My internet connection is stabile, another such program like this didn't do that.
I would like to use BA, but i don't want make a red for this reason, because every second is very important for inplay!

What's the problem, what is the solution ??

Here, what i'm talking about:

https://www.youtube.com/watch?v=_6R5lKnmvao

[Captain Sensible]

I think it's basically down to BA waiting for the bet response from Betfair to be returned and displayed in excel. Remember once the market turns in play there's a 1 second delay to the bet (more if it's under £2) plus the API price returns from Betfair do seem to be slower once the market's in running.

[Frenszisz]

When BA waiting for the bet response from Betfair the grid or ladder interface not freeze at 1 second only the excel.
I think this problem is between BA and the excel connection, i hope you fix it in the future.

THX

[Captain Sensible]

There's no need to freeze data on the grid or ladder but with excel you want to know the response to any triggered bets i'e' betid's matches etc otherwise it could continue to place bets based on the original trigger.

[Captain Sensible]

Remember there are separate calls being made to the API getbets, placebets, getmarketdata etc, I'm guessing the excel link is waiting for the response to placebets whereas there's no need for the ladder or grid to 'freeze' the displayed prices

[Frenszisz]

Only your excel link is waiting for the response the other betting program with excel (eg.other BA) continuous the data flow during triggering too.
(if you want i upload video will show)
While freez 1 second every triggering, golden entry points pass out.

Don't get me wrong this is a good program with excel, but without this problem it will the better for me...

[Frenszisz]

https://www.youtube.com/watch?v=kzGzPMh ... e=youtu.be

[Captain Sensible]

The problem with using a simple excel interface is that it really needs that returned bet reference to keep track of things. Without a bet reference entered you'd have no way of stopping that runner firing again and the program also needs it to fire all the offset fill kill options etc. Somehow I doubt the other software has the triggers you need otherwise you'd be using that.

Excel is always going to be somewhat limited maybe you'd be better off using the COM to programs things as that can keep it's own arrays of bets and you'd be able to flag runners to avoid duplicate bets.