Hi jefcc, Yes, it is possible to reorder items based on values via script. See basic version below. It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index)....
I am glad that I could help you. Good luck with your Quantrix models!
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...
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...
Hi lyledp, one way to solve this problem would be adding a new item to calculate cumulative values for each group with a single formula. Then you will not need sum summary items and formulas at all. Let...
I am glad I could help you. This could be relevant to anyone who runs script on large number of calculated cells. Good luck with your model!
Hi Jeffc, Use this script: |Matrix1|.formulae.each {allFormulas -> allFormulas.text = "//" + allFormulas.text } Hope this helps, Tahir
Hi Olaf, in the menu go to View then check Synchronize Views. This will synchronize filter tray items across all your matrices. You will have the same item selected in filter area in all matrices and views....
Have you tried new $RoleName? This video shows practical usage of Role Names in Quantrix Modeler and Qloud. This feature can save your time because you do not need to create a separate matrix view for...
Nice job!
Hi, We have a new post in Quantrix Europe blog about how to improve model audit and ensure accuracy of entered data. The idea is to see all changes directly on the matrix and even to filter by date and...
Thank you, it is a good suggestion. I wish Quantrix has some kind list of improvements online, where we can add our suggestions and everyone can vote for them. There are many things which can be improved...