Open new tabs using QPL

[scarlett3]

Is there a way to set BA to open new tabs for each market in the Quick Pick List?

I use the Excel Multiple Sheets Quick Link function and this enables me to record the odds from different football 'match odds' markets within Excel (based on a spreadsheet that alrodopial has shared on this forum) and I also use these Excel sheets for triggered betting. But first I have to manually open up the different football 'match odds' into different tabs and then run the Excel Multiple Sheets Quick Link function which can take quite a while.

Anyone know if this is possible?

TIA

[rourkem]

I'd tried checking out some options but still a no go for me. Would be nice to see a confirmation too if this is really not possible yet.

[Captain Sensible]

No simple way to do it via the program, any reason why you don't open all the tabs in the first tab, espceially as they're all football odds so the format would be the same for each game. Otherwise I guess your best bet is exporting the quickick list to ecel and amending your various sheet so they reference it and use the GO:<marketID> trigger to input the various games.

[scarlett3]

Thanks Captain.

I don't want all the market in a coupon on one tab as that doesn't enable me to record the markets odds. That is why they need to open in different tabs.

I can use the workaround with the GO: trigger, but I still need to load a market into each tab first before the GO: trigger can switch the market to the correct one using VBA and the market IDs from my _QuickPickList worksheet, so it doesn't save very much time, if at all.

The GO: trigger won't work if the tab is empty in BA (i.e. has no market already open) as far as I can see.

[Captain Sensible]

Not sure why you can't log all matches from one sheet, excel has a lot of space and can do mulitple workbooks if you need to store individual games data, having a VBA routine storing all markets at once would be a lot more efficient on the CPU than loads of separate sheets especially now the new API can call more than one market at a time.

No idea how you're selecting your quick pick list but if you're using the Log Multiple sheets link doesn't that load the first market from the quick pick list? Shouldn't be too hard to have workbook 2 goto the 2nd market in the list ,workbook 3 to third market and so on before they go into live betting mode.

[scarlett3]

My Excel files are based on alrodopial's 'RECORDING_ODDS_WITH_BA_-_many_markets.xls' file that he provided a few years ago. This uses the Excel Multiple Sheets Quick Link function and so needs the markets to be in different tabs. Yes, it would be much better if they could be opened in the single tab, but I didn't think it was possible to record the odds into different worksheets within Excel using this approach. I haven't seen such an example on this forum.

Yes, I can use the Q2 trigger to select the first market in the QPL. It looks straightforward to set up VBA to use the 'first' and 'next' markets triggers in Q2 in each worksheet to get to the correct market for each worksheet. I'll give it a try.

Thanks for the solution

[alrodopial]

exporting the quickick list to ecel

How can you do it?

[alrodopial]

Yes, I can use the Q2 trigger to select the first market in the QPL. It looks straightforward to set up VBA to use the 'first' and 'next' markets triggers in Q2 in each worksheet to get to the correct market for each worksheet. I'll give it a try.

The steps will be (???)
sheet1 load the first market
sheet2 load the market from sheet1
sheet2 move to next market (-1 trigger)
sheet3 load the market from sheet2
etc

????????????????????

[Captain Sensible]

exporting the quickick list to ecel

How can you do it?

When you log prices to excel there's a option to export the quick pick list to a sheet called 'YourWorkSheet_QuickPickList' .

[alrodopial]

so you enable it "manually"?
do you also get each market's id?
- beside the market description I guess -

[Captain Sensible]

If you consider ticking a box next to the option when initially logging the sheet to excel then yes, manually.

I think it gave marketID's but I gave up on it, since the change to NGAPI half the data like BSP and IN PLAY didn't come across. I tried to get it working just but no joy and finding any manual on Gruss to describe what it does is like finding a needle in a haystack.

[alrodopial]

When you log prices to excel there's a option to export the quick pick list to a sheet called 'YourWorkSheet_QuickPickList' .

Tried it a couple of times, nothing happens

[scarlett3]

If the worksheet that you link BA to is called 'W1', for example, you will need to create a new worksheet called 'W1_QuickPickList'. This will be the worksheet that is populated with the QPL info.

[alrodopial]

If the worksheet that you link BA to is called 'W1', for example, you will need to create a new worksheet called 'W1_QuickPickList'. This will be the worksheet that is populated with the QPL info.

It's ok now, thanks

match description,
date and start time
market id
parent id

is the info you get
good enough as long as the market id exists