Excel - Multiple simultaneous bets on several horses

[greenfingers]

Hi, I was wondering about the most efficient way to mange multiple open orders on each of several horses in the same market. I'd have 2 or 3 orders per horse that fits the criteria.

My guess is to open the same market in 3 times in seperate tabs in BA and link them to 3 sheets in the same workbook. Then I can quite simply replicate the trigger with different variables.

The alternative I suppose would be some pretty complicated (for me!) code to be able to handle the different criteria for each of the open orders on each horse. I'd rather not get into that!

If I have the same market open 3 times in BA and the throttle set to 20 requests per second, will each market get a maximum of 6.66 refreshes a second or does it get the data from Betfair once and distribute it to the 3 tabs?

Is there a more efficient way?!
Thanks

[GaryRussell]

It sounds like 3 tabs is your best option. One tab cannot handle simultaneous requests, it can only handle sequential requests.

Each market as you say will get a maximum refresh of 6.66 refreshes per second. It would be a useful feature if it could recognise it is the same market and share the refresh requests. I will look into this.

[greenfingers]

Thanks for confirming that Gary, it's good to know before I delve into trying to code it! Also for looking into the same market / multiple tabs possibility.

[Lewis]

Hi Gary,

I also use two markets in BA linked to excel and feel that it is 'wasteful' to poll the API for both when the market data should be the same. However I understand this would be a big change to make to BA.

Currently I am writing the data a single sheet with one market below the other on sheet1. What you have said suggests that I should have the two markets spread over two excel sheets as otherwise BA deals with it sequentially?

I understand I am using BA in a way it was not designed and I am currently 'hammering' the refresh rate however hopefully I can find the most efficient workaround.

[GaryRussell]

It doesn't matter if they are on the same worksheet, if you are logging the market twice the requests will be simultaneous. You will be pleased to know however that it's not as big a change as you might think. I have actually already implemented this in the latest Beta which will be released in the next few days. As long as all tabs displaying the same market are set to the same refresh rate it will only make one set of requests.

[Lewis]

Implementing the update before a request is made - now that is first quality support

I look forward to trying out the new version and thanks for the fast response.

[GaryRussell]

It's ready to try if you are willing to test it for me. See http://gruss-software.co.uk/forum/viewtopic.php?t=4992

[greenfingers]

Hi Gary, I've been away for a few days so it was a great surprise to see this implemented already - perfect timing! I'll try it out today. Many thanks.