lyndseyweber | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions

Welcome to the Quantrix Answers Community! This is a place for Quantrix users from around the world to share their questions, knowledge, and ideas. If you are posting a question, please include any accompanying information that might be useful to the reader (for example, a demo model or screenshot). Do not include any confidential information in your posts and remember that model attachments must be zipped. If your question is answered, please provide feedback! Providing feedback can help future users understand what’s worked. Thank you for being part of the Quantrix Community!

Please Note: A Quantrix team member will review new questions before publishing to the public. We hope this will reduce unwanted posts on our site.

Commented on a post

Or, depending on what it is you're trying to do, you could just put a formula in Matrix 2 in lieu of the last line in the script above... C1:B[LAST] = #B

October 30, 20232
Commented on a post

Thanks Rich! Maybe this script then? //if you want to clear the previous "last" item value in C1, include this line first: |Matrix2::B|.children.last().value = ""// |Matrix2::B|.children.create() |Matrix2::B|.children.last().value...

October 30, 20232
Posted an answer
A Script That will Create an Item and Populate the Cell of the Just Created Item with a value

Here is a simple example that may not do what you're asking, so let me know. This will check the # of items in Matrix1::B and add that # of items to Matrix2::C. Then, the script will populate/re-index...

October 30, 20235
Posted an answer
A Script That will Create an Item and Populate the Cell of the Just Created Item with a value

Hey Rich, a few questions: each time the script is run, do you want to add another batch of items based on the number of items in Matrix1::B, or is this more like "please ensure the number of items...

October 30, 20235
Answer was selected as best
October 27, 202310
Posted an answer
Reorder items based on multi column sort

Hi John, it's tricky to "lock" in the sorting in other matrices where the Course category is linked. I might tackle this by adding a hard-coded/input column to your Attribute matrix that drives the sort...

October 26, 20235
Received an upvote
August 15, 202310
Posted an answer
Mouseclick

Hi Keith, scripts are designed to be run from "anywhere" (script manager, menu, keyboard shortcut, canvas button, automation rule, etc.) - they are agnostic, so unfortunately there isn't a property like...

August 15, 20235
Received an upvote
August 1, 202310
Received an upvote
July 12, 202310
Asked a question
New Quantrix Video Series - Modeling Mondays

Have you watched our new Quantrix “Podcast” series: Modeling Mondays? The first 4 episodes are available now: https://www.youtube.com/watch?v=Gglk459z3CA&list=PLRLRIbJ2_2lIgYz4msnYbfLarTZP7duaP...

July 12, 20232
Commented on a post

Without seeing how you're getting the EOD data, I'd suggest: 1) Download ticker data to .csv or Excel file 2) Get all the tickers onto a single sheet (use PowerQuery in Excel if necessary) and format as...

July 12, 20232
Posted an answer
reference matrix name in a formula

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...

July 12, 20235
Commented on a post

Lyle - Right, I see what you are trying to do - unfortunately as you know, @level() and other functions (outside of recursion) don't work on the left side of the formula. We have gotten this request in...

July 3, 20232
Posted an answer
sum(summary()) for groups with varying number of items

Hi lyledp, unfortunately, there's not a straightforward way to do this. You could write a script that created the formulae for you, but not one that would help consolidate them. It sounds like you're...

July 3, 20235
Posted an answer
Header and footers in page setup: can I remove the border

I've confirmed that this formatting of the borders is specific to Mac and is not editable. We've logged this as an enhancement request for a future release.

March 8, 20235
Commented on a post

Hi @lerzegov -- I'm checking with our team internally on this to confirm, but today there is no functionality to edit/configure the borders on the headers and footers. Are you using Mac or PC, and what...

March 6, 20232
Commented on a post

Hi Jim - is this a repetitive activity you're doing? It is indeed a slow process and performance heavy. I'm wondering if the data you're hoping to filter and delete is coming from an external source (and...

March 6, 20232
Posted an answer
How-To do a Monte-Carlo-Simulation with Quantrix to add Risk and Uncertainty to Planning

Thanks for sharing your impressive Quantrix model with us Gilbert!

December 16, 20225
Posted an answer
Linked DB Authentication

Hi Alexander - Quantrix does not negotiate any authentication. It's up to the database driver (you select) to do so. For example, for a SQL Server driver, you will need to install the driver from a directory...

December 1, 20225
Load More