BA/excel interaction question

[dermag]

Hi Guys,

I'm pretty new to BA and the forum, but I can do a bit of vba, so am working on a few ideas.

What I want to know (if anyone knows) is how long the trigger cells need to be populated for BA to pick it up and fire the bets in.

I'm wanting to fire multiple bets and lays in rapid succession. However with a refresh rate of 1 second nothing seems to get through.

On my worksheet_change event I have a bit of code running and it fills the trigger column with BET and the stakes/odds. However I want to clear them as soon as they are sent, I dont care about references or pending, I just want them sent asap. *note, (while writing this) after tinkering with my code I have just acomplished my goal on a 1 sec refresh, but I'd still be interested in how quick BA can pick up triggered bets?

By the way, thankyou immensely Mitch for some of the help you gave others, some of your code helped me over a huge hurdle when I first encountered BA and the excel interface.

Dermag

[Ian]

This is similar to the problem which I have when I try fire bets into the win and place markets at the same time. Most of the time they get through but about 20% of the time only one gets placed. No pattern, sometimes it the win, sometimes the place.

[GaryRussell]

This is similar to the problem which I have when I try fire bets into the win and place markets at the same time. Most of the time they get through but about 20% of the time only one gets placed. No pattern, sometimes it the win, sometimes the place.

The program should have no problem firing multiple bets as it consolidates them all into one transaction. Would you be able to send me the spreadsheet you have this problem with? I understand if you can't as it may reveal your strategy.

[dermag]

Hi Gary,

Thanks for the reply. Whereas I wouldn't want to send you my full sheet, I could quite easily cobble together a test version to demonstrate the 'problem'. It may or may not be a problem as yet.

I had a play today and I managed to fire 17 sets of lays at 1.01 as a test. I had the refresh on 1 second and it took circa 20 seconds to acomplish this task. It fired in a set of orders every refresh. It may well be the logical flow of my code as I've never needed to fire in bucket loads of bets so far.

What I wanted to know was whether BA only takes orders on your chosen refresh interval from excel. So if you had a 1 second refresh BA would take orders at this interval. Or is it in total sync with BA and will fire orders in regardless of refresh rate?

Dermag.

[GaryRussell]

It only fires bets at the refresh interval.

Gary

[dermag]

Hi Gary,

Thanks for that reply. It clears it up and allows me to formulate a plan now.

Really solid program by the way Gary, a real credit to you. You'll do well with this venture. Try not to be too nice and get bogged down with customer service requests that have little to do with the program but more the ignorance of the end user. I've been there and it an easy trap to fall in to.

Dermag