reference matrix name in a formula

1.01K viewsFormulas and Functions

If ColumnA contains Matrix names, how to reference the matrix with that name in ColumnB in a formula?

ColumnB = ColumnA::rows 1

Similar to using @ for Category names

Problem: for now I have 10 matrices to combine some of their elements into one matrix

S A U Answered question August 19, 2023

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.

Tahir Posted new comment July 15, 2023

This is exactly what I was looking for. It works. Thank you.
My difficulty was not the syntax of the matrix name call as I thought but how it was being used; indirect() solves the actual problem.

In fact, all I need is indirect(@F&”::Column 14″) to get the one item I need out each @F matrix. Without indirect() the variable matrix name is interpreted as text.

I am glad that I could help you. Good luck with your Quantrix models!

You are viewing 1 out of 6 answers, click here to view all answers.

Latest Questions