Odds Recording Help Needed

[Josy]

OK, I am back with my questions.
I checked it again and still can't to force it work my way...
I compiled my own Quick Pick List (markets I need).
A separate List for each soccer match I am interested (or I need only one List for all markets I am into?).
But when I want to set up Multiple Quick Link for Excel I can't choose from my selected markets to arrange to each sheets in spreadsheet as it offers me only the default markets from default Quick Pick List...
Please help me to figure it out how does it work.
Thank you for any help.

[Josy]

So, would be somebody so kind to explain me how can I use the Multiple Sheets Quick Link with the markets not listed in Quick Pick List or from a Quick Pick List I build myself?
Thank you for any help.

[Captain Sensible]

I think the Multiple Sheets Quick Link will only ever link your market tabs to excel sheets. The selection of those markets will be down to however you set up BA to choose the markets ie minutes before the off/auto select first market......

It's not going to go thru your quick pick list and stick each market into a separate tab and link to excel, you'd have to code that sort of thing into your sheets.

[Josy]

Thank you Captain for answer.
So, if I understood you right I cannot use my own Quick Pick List to choose from (BTW than why I can build my own one?) and than I need to choose the market itself from the spreadsheet.
OK, it's getting a bit more clearer, I think.
So, how can I build it into my spreadsheet which market I need and how to do it working?..
Yeh, I know I have a lot of questions...

[Captain Sensible]

Thank you Captain for answer.
So, if I understood you right I cannot use my own Quick Pick List to choose from (BTW than why I can build my own one?) and than I need to choose the market itself from the spreadsheet.
OK, it's getting a bit more clearer, I think.
So, how can I build it into my spreadsheet which market I need and how to do it working?..
Yeh, I know I have a lot of questions...

You can use your quick pick list to choose from but you can only monitor 1 market in excel per tab from that list (not strictly true but in this situation yes).

I'm assuming you wish to monitor all markets from that quick pick list in excel at the same time i.e. a few football matches starting at the same time as you haven't clearly stated what you want to do. If that is the case then no BA doesn't have the option to open all market from the QPL to separate tabs as far as I'm aware.

[Josy]

Hi there,

Thank you Captain for your time to answer my questions. Appreciate it.
Yep, you are right I didn't explain clearly what I am after.
Here is an example.
I would like to record all Under/Over markets of selected soccer match.
For each U/O pair (like U/O 1.5, U/O 2.5, etc.) I have a separate sheet in my spreadsheet. And I start to record from about 60min b4 KO.
Yes, there could be some matches running at the same time but, I suppose, I can load them from separate instances of BA, do I?
So, I just would like to be able to set up this Multiple Sheets Quick List to load my markets connected to appropriate sheet as it takes a long time to load them one by one manually.
Or is it what you said is not available from current BA version?
Thank you for your help.

[Captain Sensible]

Still none the wiser as to how you're populating your quick pick list. But I doubt it's going to do exactley what you want straight out of the box so to speak. It'll certainly be useful and cut down the time you spend but maybe not do all things for you.

Here is an example.
I would like to record all Under/Over markets of selected soccer match.

The version I use at the moment doesn't have an option to load up over unders markets for me, might do in the latest beta etc. How are you loading markets, VBA manaually etc - This is possibly your stumblimg point if you expect one market tab to populate various excel sheets with different markets from the same tab.


For each U/O pair (like U/O 1.5, U/O 2.5, etc.) I have a separate sheet in my spreadsheet. And I start to record from about 60min b4 KO.

Each pair a separate sheet ? Does that mean on each sheet you have one market logging at say cell A1 and the next logging at say cell A100 or do you mean each market is in a separate sheet' on the same workbook? Either way neither are a problem and I'm sure you're able to sort the logging time just thru formulas vba etc


Yes, there could be some matches running at the same time but, I suppose, I can load them from separate instances of BA, do I?

No need to run from separate instances of BA they can easily run in different market tabs and if your quick pick list is automated in one tab it can just as easily be replicated in another


The only problem I can see is to do with how you populate your quick pick list , but having BA save you time setting up all the tabs and linking them to excel is easy enough and would save you a lot of time.

If you're currently the quick pick list manually anyway I'm not too sure where you're getting stuck

[Josy]

Still none the wiser as to how you're populating your quick pick list. But I doubt it's going to do exactley what you want straight out of the box so to speak. It'll certainly be useful and cut down the time you spend but maybe not do all things for you.

Here is an example.
I would like to record all Under/Over markets of selected soccer match.

The version I use at the moment doesn't have an option to load up over unders markets for me, might do in the latest beta etc. How are you loading markets, VBA manaually etc - This is possibly your stumblimg point if you expect one market tab to populate various excel sheets with different markets from the same tab.

For each U/O pair (like U/O 1.5, U/O 2.5, etc.) I have a separate sheet in my spreadsheet. And I start to record from about 60min b4 KO.

Each pair a separate sheet ? Does that mean on each sheet you have one market logging at say cell A1 and the next logging at say cell A100 or do you mean each market is in a separate sheet' on the same workbook? Either way neither are a problem and I'm sure you're able to sort the logging time just thru formulas vba etc


Yes, there could be some matches running at the same time but, I suppose, I can load them from separate instances of BA, do I?

No need to run from separate instances of BA they can easily run in different market tabs and if your quick pick list is automated in one tab it can just as easily be replicated in another


The only problem I can see is to do with how you populate your quick pick list , but having BA save you time setting up all the tabs and linking them to excel is easy enough and would save you a lot of time.

If you're currently the quick pick list manually anyway I'm not too sure where you're getting stuck

I appreciate your help Captain however I am getting a bit confused as we are moving ahead...

Currently I connect each market to the separate sheet in the same workbook. And only one market per tab in BA.
Like U/O 1.5 in 1st tab connected to cell A1 in FT1.5_Data sheet, U/O 2.5 in 2nd tab connected to cell A1 in FT2.5_Data sheet, etc. in the same workbook. Is that OK or not?
Let's disregard how I build the Quick Pick List (btw manually, didn't have time to figure out by VBA), the problem is I don't know how or it simply doesn't work for me to choose my markets from it when I want to set up Multi Links...
So I have this MyQPList.qpl file but how can I use it? Or I misread something and we are talking about different things?

[Captain Sensible]

"For each U/O pair (like U/O 1.5, U/O 2.5, etc."

K, it was the bit about pairs being in separate sheets and the "etc" bit implying there were other markets being monitored, I needed clarifying.

If you're doing the markets quick pick manually why not just have the multiple sheets quick link just load up the excel sheets for you and pop in the markets manually in each tab there's no difference in time or the end result? The multiple quick pick can set all the logging cells in advance like sheet 1 sheet 2 etc and doesn't need markets to be automatically loaded , as soon as you stick a market in the tab it'll log to the cell thats set.

If you're not using VBA you're pretty much limited as to how to pick your markets from the quick pick list , you just have the default options listed in Auto Select Markets