Excel triggered betting - betting refresh rates - help plz

[Coolhand22]

I've noticed that BA checks your betting inputs from excel at the same rate that it refreshes it's market information from betfair.

For example, if I set the betfair refresh rate at 10 seconds, and then set off a triggered bet just after it refreshes; then I have to wait 10 seconds before BA sees the trigger in excel, and sends the bet to the betfair API.

Is there a way to have BA check excel or read excel for triggered bets instantaneously, regardless of how fast it checks market information from betfair?

Can we de-couple these two things?

Thanks,
Will

[Graham]

I'm pretty sure (although might be wrong, it's not unknown!) that BA used to work in this way.

From what I can remember, before requests were shared among multiple tabs monitoring the same market, I used to have one tab set to the minimum refresh rate, and the others set to a much higher figure. I would populate the trigger column from the data in the fastest refreshing sheet, to save on data requests. (hope that makes sense)

I suppose though only Gary or Mark can confirm if that was previously the case, and provide the reason as to why it is now dealt with differently.

[Coolhand22]

It still works this way for me.

BA seems to be pulling the information from excel at intervals depending on the refresh rate.

How can you make excel push your triggered bet directly into BA near instantaneously?

[alrodopial]

How can you make excel push your triggered bet directly into BA near instantaneously?

You have to use worksheet_change event and then place your bets using com

[Coolhand22]

Ty worked

[austingrd]

You have to use worksheet_change event and then place your bets using com

Awesome! Worked right here too.