Hello everyone,
I work with Building Blocks and create blacklists for each strategy with symbols that should not be traded in that strategy. These blacklists can be created manually in Norgate, but you have to search for each individual symbol and add it to the list. This is time-consuming and error-prone. You can then have Norgate create a new list, e.g., S&P 500 C&P without the blacklisted symbols.
Therefore, I tried to exclude symbols in WL using the "Symbol Filter" conditions block ("if Symbol is NOT one of Symbol(s)").
Unfortunately, it's not possible to copy a symbol list copied from Excel into the filter list. Only one symbol can be added at a time. This makes it just as time-consuming and error-prone as with Norgate.
My question:
Would it be possible to allow the insertion of an Excel symbol list in the WL Symbol Filter block?
Alternatively, I have the idea of enabling blacklists in WL as well. If necessary, you could define a second dataset directly in the "Strategy Settings" to serve as a blacklist. The advantage: When creating datasets, you can insert Excel symbol lists of any size.
Thank you very much, and sorry for the long text...
I work with Building Blocks and create blacklists for each strategy with symbols that should not be traded in that strategy. These blacklists can be created manually in Norgate, but you have to search for each individual symbol and add it to the list. This is time-consuming and error-prone. You can then have Norgate create a new list, e.g., S&P 500 C&P without the blacklisted symbols.
Therefore, I tried to exclude symbols in WL using the "Symbol Filter" conditions block ("if Symbol is NOT one of Symbol(s)").
Unfortunately, it's not possible to copy a symbol list copied from Excel into the filter list. Only one symbol can be added at a time. This makes it just as time-consuming and error-prone as with Norgate.
My question:
Would it be possible to allow the insertion of an Excel symbol list in the WL Symbol Filter block?
Alternatively, I have the idea of enabling blacklists in WL as well. If necessary, you could define a second dataset directly in the "Strategy Settings" to serve as a blacklist. The advantage: When creating datasets, you can insert Excel symbol lists of any size.
Thank you very much, and sorry for the long text...
Rename
The following may not be ideal for your situation, but you could do the following in your Excel spreadsheet. Assume your symbols are in column A. Pick an empty cell somewhere in your spreadsheet and set the formula to the following:
CODE:Then you can select that cell and use CTRL-C to copy the symbols. You can then paste the symbols into the Symbol Filter condition block in Wealth Lab.
=TEXTJOIN(" ", TRUE, A:A)
thank you very much!
Your Response
Post
Edit Post
Login is required