Hi Bristly, I think I found a solution for you. As you see on the screenshot I used indirect function to make a matrix name variable. You do not need to change this formula when you add a new ticker, it works automatically when you add a new ticker item. Hope I could help you.
Hi Bristly, it is a good question. I understand the pain of doing it one-by-one. The best way would be to find a single source or a single link to all of your tickers. But if you do no want to pay for such service, I think you can use a script. This script can update your data links, loop through all matrices, get necessary data and paste it into summary matrix. Quantrix formula cannot loop through all matrices like that.
“combine them all into one matrix…”
That is essentially what I’m trying to do. I grab market data for 10 tickers using a DataLink for each ticker so each each ticker makes it’s own single-row multi-column matrix named for the ticker symbol (best free option I have found for EOD data, unable to use single DataLink for multiple tickers).
Hello Bristly, we would advise not making matrix selection part of your model’s structural design.
If you have multiple matrices with similar structure, sometimes you can combine them all into one matrix with a category shared across the former matrix names. I’d have to learn more about your model and what you are attempting to do. Sometimes your formulas may have to be a little less fancy than you might be hoping to achieve.
It’s also possible that you could join a few matrices/categories together via Data Import from Matrix, but this may not be what you need.