Multiple excelsheets connected to one market

[JDTrader]

I'm wondering if it in any way is possible to connect multiple excel-sheets to one market?

I currently solve this by opening three instances of BetAngel, using Guardian setting up the same markets for BetAngel to follow in each instance, and connecting one Excel spread sheet to each market.

A preferred option would be to only have one instance of BetAngel opened which automatically could either:
a) connect and update X number of Excel-files
b) Connect to one Excel-file but update (and placed bets based on those) multiple tabs in that Excel-file.

I've browsed the forum and looked for answer but I was not able to find anyone asking this having this question before so I guess either there's an obvious way of doing this that I've missed or it is a strange question .

[Euler]

This should be easy if I understand your request. You can replicate the data on the first sheet by linking individual cells on the first sheet to the second. But not sure why you would want to do that?

[JDTrader]

Not sure I understand how that would solve my question.

And the main reason why I want to link multiple Excel-sheets to one market is that I want to place different bets (for example LAY ManU at 2,2 and BACK ManU at 2,3) at the same time. I can achieve this with a few seconds difference (which is fine) by first placing the LAY bet and then placing the BACK bet but my issue then becomes that I want to know (for statistical reasons) if these bets were matched or not when the market was suspended. Currently I catch this info by running VBA scripts when the market gets suspended. And if i place a BACK bet after placing a LAY bet I will lose the history if the LAY bet was matched or not...?

(I could of course log the BETID and then download the transaction history from Betfair and go through this list with VBA to extract info if the bet was matched or not but this would mean a lot more work)

Does this make any sense?

[Zapata]

The latest version of BA has an enhanced worksheet and shows matched and unmatched back and lay info in 12 new columns on the right. With this info plus vba you will be able to work out bets matched or not.

When placing your command into the "L" column if you use BACK OFFSET:"number" this would allow back and lay bets to be placed at the same time. Hope this helps.