Cast your Vote for new Features
Greetings Forum Community,
We are looking for your feedback! The seven features below are requests you have raised with us. Please help us prioritize and choose the top 3 of features you would like to see addressed in a future release of Quantrix Modeler by voting in the poll at the top of this thread. [b:2h5gy025][i:2h5gy025]You need to be logged into your MyQuantrix account to vote in the poll.[/b:2h5gy025][/i:2h5gy025]
Thank you in advance for your participation in this poll which will help shape future releases of Quantrix Modeler. The poll will be open until March 3, 2007.
[b:2h5gy025]DataLink Source – Quantrix Model File [/b:2h5gy025]- Develop functionality to allow a Quantrix Model file to be used as a DataLink source. This would allow users to establish a DataLink with matrices residing in a separate model file.
[b:2h5gy025]Smart Time Dimension[/b:2h5gy025] – Develop functionality to support nested time dimensions in a model. For instance, the model could know 4 quarters belong to a year, and 3 months belong to a quarter, eliminating the need to write recurrence formulas between time dimensions.
[b:2h5gy025]Presentation Engine[/b:2h5gy025] – Develop functionality that allows users to link in pieces of Quantrix matrices, views and charts onto a single presentation canvas for using, printing, or exporting the model.
[b:2h5gy025]Develop User and Viewer Application[/b:2h5gy025] – Develop a Viewer version of the application that would allow the user to only view the model. Also develop a User version of the application that would allow the user to modify data and structure, but not the model formulas.
[b:2h5gy025]Solver[/b:2h5gy025] – Develop a solver / goalseek module for Quantrix to solve complex models with variable inputs.
[b:2h5gy025]Scripting[/b:2h5gy025] – Develop a scripting language for the application to allow users to customize Quantrix functionality to their needs.
[b:2h5gy025]XBRL Desktop Support[/b:2h5gy025] – Develop integrated support for the eXtensible Business Reporting Language (XBRL) ([url:2h5gy025]http://www.xbrl.org[/url:2h5gy025]) to allow users to import and export XBRL documents.
Is there a feature you would like to see that is not on this list? Please feel free to post it on this thread.
Thank you for your vote and support of Quantrix!
[b:2h5gy025][i:2h5gy025]Please note:[/b:2h5gy025] This poll will be used to help the Quantrix development team prioritize and schedule features. It does not represent a commitment by Quantrix that it will develop any particular feature in any timeframe.[/i:2h5gy025]
I would like to encourage the addition of a yield-to-maturity (YTM) formula to the financial functions. It’s a variant of your rate() formula. YTM is applicable to any debt security, including:
– mortgage annual percentage yield calculation
– CD yield to maturity calculation
– bond yield to maturity calculation; also applies to Treasury securities, commercial paper, etc.
Please vote in favor of adding this feature.
Sponsored by the ‘YTM for Quantrix alliance’ 😉
For those interested, the full details for the most general case of the formula are:
* maturity date (e.g. 22-june-2016)
* coupon (interest payment per annual, e.g. 5.5%)
* payment frequency (annual, semi-annual, quarterly, monthly)
* nominal amount (the face value of the debt security/mortgage)
* price paid for debt security (100 is ‘par’); alterantively, one could specify the principal amount (the price paid for the security at purchase)
* accrued interest (the accrued interest paid for the security at purchase)
* purchase date (the purchase date)
When buying/selling a debt security, there’s a principal amount to be paid, defined as price * nominal amount / 100, but then there’s also accrued interest to be paid. If e.g. one buys a security that pays interest yearly one month after interest was paid, the buyer pays off the seller 1 month worth of interest. This keeps the price free of such predictable ‘distortions’.
For someone calculating the annual percentage yield on a CD, mortgage, T-Bill, some of the parameters would not be necessary.