Skip to content

Everyone’s thinking about your customers, but who’s thinking about you?

Whilst attending Finovate earlier this month, I noticed a lot of focus on consumers, as companies considered how to make previously tedious tasks simple for end users. Despite this, I couldn’t see how the back-office processes behind these offerings were being made any easier – it seems like the hard work behind the scenes still isn’t streamlined.

Although it was exciting to see how the future of Fintech is taking off rapidly, there must have been someone in the room who was wishing that their job of modeling the growth of these new technologies, sales and investments could be made easier?

As Greg Palmer said in his opening remarks – Fintech really is global (Region). Not only this, but the companies going through the launch process of either a new app or service offering, would have had to look at the timescales and finances against this to ensure success (Time). Additionally, there usually isn’t one idea on the table in development meetings – it’s usual for several variances to be considered (Products). It’s also likely many of these variables were backed by teams, external consultants or even investors (Personnel). When you then take a deeper look at the finances of the launch, including the income required to become profitable; the cost of sale; your outgoings and many more (Line Items), you can be faced with quite a complex array of scenarios.

The words in italics are not mistakes or even notes to remind me what to write. I wanted to highlight the fact the world we live in consists of many dimensions. There is huge complexity when putting these factors into a financial model using a traditional spreadsheet. Notice how, even with what could look like a simple project, I have easily outlined five dimensions of the model.

I believe that Quantrix really could be the missing puzzle piece for many innovative companies, like those who attended Finovate. Quantrix helps simplify, accelerate and perfect the modeling process behind the scenes as well as creating ‘what-if’ type analyses. Because modeling is now very multi-dimensional, we must adapt to the requirements of our users to make their lives easier. After all, who doesn’t want that?

If you want your modeling processes to be best-in-class, download a free 30-day free trial and explore the benefits of Quantrix Modeler or get in touch.

Quantrix Delivers “Incredible Value” for the Astound Commerce Performance Management Solution

Anyone who spends enough time with data understands just how much is involved in turning it into valuable and actionable information. For Astound Commerce, the choice to deploy Quantrix Modeler as part of its comprehensive performance management solution means it now has a true decision support system that enables its business professionals to spend less time on the data, and more time using it to run the business more effectively. And it opens up the opportunity for the company to extend the solutions it delivers to its customers.


Alex Nisenboim Technical Architect Astound Commerce

Based in the San Francisco Bay area with offices around the world, Astound Commerce offers strategies, tools, creative services and The Astound Way process to help some of the world’s most recognizable brands create an enhanced digital shopping experience for their customers. In addition to multiple offices, it had numerous systems it used to manage its global business, including financial transaction records, resource management, HR, and more. “We had the classic set up of systems that weren’t connected,” says Alex Nisenboim, Technical Architect, Astound Commerce. “The challenge of analyzing the data was formidable. We needed a comprehensive solution.”

The first step in building the business intelligence stack for the company was to create a single data warehouse. It invested the time and resources required to perform a major extract, transform, and load (ETL) process to create a unified, coherent data warehouse that would provide a trusted data source for BI modeling. But once the data was ready, which tool would deliver the best platform for data modeling, forecasting, and financial insight? “Most tools put the emphasis on data analysis and exploration. They don’t recognize the value of something like a well-formatted P&L,” says Nisenboim. “But Quantrix has data exploration, visualization, and financial formatting working together in something that resembles a spreadsheet environment. We can produce reports that people understand.”

astoundProviding data-driven answers to business questions is the holy grail of business intelligence. Astound Commerce uses Quantrix to deliver insight into various aspects of the business by allowing stakeholders to readily find these answers in a visual, easy-to-understand format. “Who are our best performing customers/projects, viewed by sales, gross margin, utilization rate, or other metric?” says Nisenboim. “We can incorporate all of these and more into one model and use it as a decision support system. Stakeholders can be served different slices of data and different levels of rollups to get answers to questions in a quantitative manner.”

Users are thrilled with the answers and insight that Quantrix delivers. For example, Astound Commerce’s client services team used to spend a lot of time calculating key performance indicators. “With Quantrix, data that KPIs are calculated from flows seamlessly. They can concentrate less on the analytics, and more on the actual management of the accounts,” says Nisenboim. The implementation also positions the company to build analytical and performance management models for clients, a service it plans to add to its portfolio of offerings. “We have built the expertise in delivering the whole solution, starting from managing the data via ETL all the way to building cloud-based models for clients using Quantrix,” says Nisenboim.

The ability to collaborate via the web-based Quantrix Qloud is another positive feature for Astound Commerce. With team members spread throughout Europe and the United States, gathering and sharing data used to be a time-consuming process requiring multiple Google spreadsheets and unreliable data. “Now, we have different stakeholders participating in this dialog, looking at the same analytics all coming from the same data source,” says Nisenboim. “This can only be achieved from a solution like Quantrix.” It has deployed Quantrix’s Enterprise Qloud version, where Astound has an on-premise Qloud server, enabling the company to host models and collaborate via its own private cloud.

With a robust data warehouse serving information into the collaborative Quantrix Qloud for modeling, Astound Commerce now has a single source of data providing precise, tailored views of a company-wide model. “We now have the full stack, from ground to the Qloud,” says Nisenboim. “Quantrix has it all. The value is incredible.”

Mischler Financial Group Uses Quantrix Qloud to Stand Apart

Competition is strong in the institutional brokerage market, and niche firms must find a way to stand out. Mischler Financial recognized that its institutional clients needed more in a partner than a strong reputation and competitive pricing – they needed access to information. A series of models developed on the Quantrix Qloud platform has created a “slam dunk” edge for the firm.

Mischler logoMischler Financial is the financial industry’s oldest broker/dealer firm owned and operated by service-disabled veterans. It serves institutional clients including public entities such as cities, counties, and municipalities, and provides direct access to global equities and fixed income markets, new issue underwriting and syndication within the US Equity and Debt capital markets, and asset management for liquid and alternative investment strategies.

“These large institutions operate very large funds – often in excess of hundreds of millions of dollars,” says Jason Klinghoffer, CFA, Director, Mischler Financial. “But many times the fund managers are public servants without access to the tools and resources a Wall Street money manager has.” Recognizing their budgetary limitations, Mischler sought a way to level the playing field for its customers that buy and sell without access to Bloomberg terminals or costly analytics programs.

Klinghoffer joined the firm in 2014 with a mission to create a new set of analytical models to replace the cumbersome investment strategies and offerings spreadsheets that Mischler provided to clients. One requirement: an online platform for direct client access. “No matter how cool your spreadsheet is, at the end of the day, email is a huge bottleneck,” says Klinghoffer. “It’s inefficient, clients can’t easily access the models on demand, and we can’t track whether or not they are using them.”

Originally he planned on developing an internally housed solution from the ground up, but chose Quantrix after discovering the robustness of the cloud-based Quantrix Qloud. “It has its own admin panel, we can assign logins to clients, and we didn’t have to develop a system to host the analytics,” says Klinghoffer, who uses Qloud tracking functionality to track user logins and usage. “We can see who is logging in and who is accessing and using models, all from within Quantrix. This creates great efficiency in managing our clients’ information and analytical needs.”

The modeling capabilities and calculation engine far exceed what Mischler was able to do with Excel: the firm can separate data from the logic of the presentation, which means it can house data in various places without dragging down performance. “I have data stores that are two gigabytes in size – imagine trying to put them into a spreadsheet and get some intelligence out of them,” says Klinghoffer. “The memory requirements alone would shut them down.”

In addition to improved delivery and calculation, Mischler says plain language formulas and efficient structure makes it much easier to manage models. “Even with such large data sets and complex models, I can come back in after months and understand what’s going on,” says Klinghoffer. “I can step through a formula to see what is being manipulated, and understand the impact of any change I will make. Thanks to category relationships between matrices and dimensional linking through formulas, even my most complicated models only need a few hundred formulas to calculate tens of millions of cells!”

In the spring of 2016, Mischler rolled out its package of models to customers via the Quantrix Qloud, available 24/7, including portfolio and security analytics, investment strategy development, and inventory offerings. It offers these tools for free to clients who execute some of their bond transactions with Mischler, providing intelligence and data that were formerly out of reach to them and leveling the playing field for Mischler with the largest investment firms.

“Clients can buy their bonds from anyone – this is our value-add,” says Klinghoffer. “We give them the tools they need to make decisions, all within a seamless online cloud environment. This is a slam-dunk for us – and we’re just getting started.”

Mike Salisbury on the Quantrix Product Roadmap

Mike Salisbury is the Director of Quantrix and is responsible for the overall Product Roadmap for the Quantrix Modeler and Qloud products. Mike took a few minutes to share some insights on recent product developments and upcoming new features.

It has been a busy few months for the product teams. Can you give us an update on recent product developments on the Desktop modeler?

Certainly! In January we released a major version of the desktop product and I am pleased to say it is getting great reviews from our user community. We totally reskinned the User Interface application and focused on making the commonly used features much easier to use. New icons, new color themes, new launch panel, all aimed at making the most seasoned user to the new user more comfortable with our application.

The Dependency Inspector was completely redesigned in a recent edition of Quantrix Modeler, and it is now much easier to debug formulas.

The Dependency Inspector was completely redesigned in a recent edition of Quantrix Modeler, and it is now much easier to debug formulas.

Our Dependency Inspector (DI) redesign is a big hit. It makes formula debugging much simpler and users of all abilities can trace the calculation thread throughout the model. I personally use the Salesforce integration daily in our Quantrix sales forecasting model, and our Tableau integration means users can get information directly out of Quantrix into Tableau reports.

In our March release, we enhanced the DI even further by allowing users to navigate directly to the formula from the DI to make formula edits. Users can re-index and rename their category items on-demand, and we continue to make strategic UI improvements like shading the formula edit area in a light green to make it clearer to the user where the focus is on the screen.

How about recent Qloud developments?

New iOS tablet integration for Quantrix Qloud opens up in-the-field uses for Quantrix.

New iOS tablet integration for Quantrix Qloud opens up in-the-field uses for Quantrix.

We are really excited about our IOS tablet integration. I encourage iPad users to navigate to to check it out. Having the ability to use Quantrix Models on a Tablet device should open up some opportunities for executive and ‘in the field’ type use-cases we have in our customer community. I think one of the best features is being able to move a matrix dimension tile to the row, filter, or column tray simply by dragging it with my finger. Simple but very effective!

In our March release we introduced Salesforce compatibility for Qloud. If you are using the Salesforce integration on your desktop models, you can now use this integration on both Hosted and Enterprise Qloud. We believe the data analysis you can do in Quantrix far exceeds anything you can do within the Salesforce application itself.

How often do you release new software?

We strive to have a new desktop and Qloud release every three months. We have adopted the Agile method of software development. This allows us to quickly iterate on new features (and bug fixes) in two-week cycles or ‘sprints’. At the end of each sprint, we have a functioning product. At the end of the three-month cycle we move into a formal test period and then release to our customers. Doing this allows us to be much quicker and more reactive to our customer needs.

What is next for the Desktop Modeler and Qloud?

For Qloud, we are actively converting the Qloud framework to AngularJS. This JavaScript framework allows us to develop new features much quicker, and is more suited for tablet development. This is a big project, but our production Qloud already has many of the AngularJS pieces in place on the login page and the models list on the current hosted Qloud. We continue to work on switching over other non-model elements of the Qloud to this new technology.

In regards for Qloud features, we are actively working on Multi-user Edit. This will be an Enterprise-only feature that will allow Enterprise Customers to deploy models to users, and then allow those users to edit the model at the same time – no more waiting for your colleagues to release the lock on a model. With this comes some powerful new features including tagged versions and ‘save-as-you-go’, all to ensure you can collaborate effectively.

For Desktop, continuing the improvement of our user interface and ease of use as well as developing more getting-started help is high on our list. We are making our Salesforce integration even better by allowing joins between multiple tables in the Salesforce hierarchy. We continue to address issues and enhancements to make sure our calculation engine is as efficient as possible, because we know our customers like to make very large models!

How can a Quantrix user provide feedback?

We very much appreciate feedback from our users. Many of the new enhancements and features are the direct result of user suggestions. There are many ways to provide feedback:

As always, thank you everyone for your support of Quantrix!

Richard Holohan, Logistics Capital and Strategy, Finds Quantrix Delivers “Massive Cost Efficiency”

At last fall’s Seminar by the Sea conference for Quantrix users, Rich Holohan of LogCapStrat sat down with us to talk about his use of Quantrix for quantitative modeling. Like many former Excel users, he needed a replacement for an Excel model that had “gotten out of control.” In this video, he talks about the flexibility and efficiency of Quantrix, including the dramatic reduction of man hours required to update one client’s model. From three people full time for two weeks, to one person for two days, the Quantrix model offered “massive cost efficiency.” Watch the full video for more.  


People of Quantrix: Brian Cabana, Engineering Manager

Brian is the Engineering Manager and Lead Engineer for the Quantrix team and has been with the company for over ten years. He has actively participated in the design, production and testing phases of each of the releases of Quantrix since version 1.0. He currently manages the engineering team and is the lead engineer on the various projects for Quantrix Modeler and the Qloud.

Brian Cabana, Engineering Manager, Quantrix

Brian Cabana, Engineering Manager, Quantrix

What is involved in your role as lead developer for the Quantrix Modeler desktop product, and how has it changed over the years?

As Engineering Manager, I help manage the prioritization of issues and run the projects from an engineering standpoint, as well as other typical managerial duties. I also do a lot of coding of features, which I enjoy. I’ve been with Quantrix since 2003 and from an engineering perspective, a lot has changed. Java, the base language we code in, has improved. User interface design principles have changed, particularly in terms of migration to mobile devices. In that period, we’ve moved from being a desktop only application to the web, launching the Qloud, and continuing to move to mobile device. And we have had a lot of fun.

What is most important focus from an engineering standpoint?

Two things: usability and stability.

Talk about usability.

In the 1990s, usability meant, “Can you do it?” Today, it’s “How easy is it to do it?” That is a big shift. We want to make new users more comfortable using Quantrix. Power users love it, but we are working on making it more usable for more people. That means making things easy to find and easy to do.

Some recent examples of our work on usability include the recently improved launch panel and the major changes to the Dependency Inspector. Before, it was hard to understand what was happening in the cell. Now there are a lot of clues as to how it calculates, including the ability to hover over the formula in the dependency inspector to see the calculations. Another change is that when a user starts to edit a formula, it gets a green background. You know exactly what you’re editing. We plan to do more usability improvements like this as well as revamping some other tools.

How important is user feedback?

We have a great user base, and they provide great feedback. We also track when people call support. If they have a hard time doing things, we try to fix that in development. We try to be as responsive as possible. At one of our Seminar by the Sea events, a power user told us that it would be great to be able to select a range of cells and filter on them immediately. One of our programmers went home that night and coded up a proof of concept. We included that feature in our next release.

Have you always been a software engineer?

I served in the Navy on submarines. Then I became a high school math and science teacher. I went for a masters in computer science, and learned about Quantrix. I pestered the company founder until he gave me a job.

What do you do when you’re not coding for Quantrix?

I have a lovely wife and two young children. We love to go cross-country skiing and snowshoeing. I also love to read – I’m currently reading a fascinating history of Maine called The Lobster Coast.

Validus Uses Quantrix for Financial Planning

Dan Kirkpatrick of Validus Holdings Group attended the 2015 Seminar by the Sea in Portland this fall, and shared his thoughts about Quantrix Modeler. In this video, he discusses how the company uses Quantrix for financial planning, including developing P&Ls and balance sheets by company and division. It also uses Quantrix for scenario testing and for building capital models. Validus is a holding company for reinsurance and insurance operating companies and investment advisors, and it has a high volume of historical data – its models are large, with some at 1.2+ billion cells. Kirkpatrick says that Quantrix is “leaps and bounds ahead of Excel” in its ability to create models that deliver insight to senior management.