Schematiq data map_edited.png

SCHEMATIQ FOR FINANCE AND TRADING

Perfect Execution

The Schematiq Platform is used by Finance and Trading organisations to find and fix data and calculation issues in existing business critical spreadsheets, as well as enhancing investment on in-house platforms and third party solutions.

Schematiq delivers advanced capabilities to users of Microsoft Excel.

 

Initially built for Finance and Trading teams by an experienced development team of Capital Markets veterans.

 

Schematiq introduces a new way of working with data and analytics for Excel users of all experience levels. Schematiq addresses the common problems and limitations of complexity, performance and governance associated with using Excel for advanced analytics.

The Schematiq Platform is used by Finance and Trading organisations to find and fix data and calculation issues in existing business critical spreadsheets, as well as enhancing investment on in-house platforms and third party solutions, such as:

 

  • Integrating with Energy Trading and Risk Management (ETRM) tools, e.g. ENDUR AND FINDUR (OPENLINK)

  • Integrating with internal systems, e.g. pricing libraries and compute resources.

  • Running What-if analysis, including custom scenario and pre-trade questioning to fully analyse effects of a potential deal on existing portfolios, along with risk and position

COMPLEX PRICING AND COMPUTING

SCENARIO AND TRADE WHAT-IF ANALYSIS

SPREADSHEET AUDITING AND GOVERNANCE

Schematiq transforms pricing with its unique ability to access the largest data sources, perform the most complex calculations and interface to 3rd party BI platforms in real time.

 

The offloading of calculations to external computing sources improves pricing performance and stability, while custom connectors reduce manual data entry, streamlining for efficiency and removing error.

Schematiq places powerful analytic capabilities into the hands of business users via Excel. Analysts can execute advanced scenarios to drive better decision making and regain the competitive edge.

 

Schematiq provides the ability to stress-test existing spreadsheet models and users are able to convert spreadsheets into functions that can be deployed to powerful servers or the cloud, increasing performance and reducing manual re-runs.

Schematiq’s versioning and spreadsheet management capabilities overcome the challenges associated with sprawling spreadsheets and satisfying financial regulatory directives.

 

Build an inventory of spreadsheet usage in the enterprise and understand user behavior. Control and release changes with confidence using Schematiq's workflow and automated regression testing capabilities for spreadsheets.

SPREADSHEET STABILITY AND PERFORMANCE

STRATEGIC RISK AND PRICING SERVICES

AD-HOC REPORTING, AGGREGATION AND RECONCILIATION

Schematiq addresses the common Excel challenges of instability and speed, allowing users to handle extremely large data sets and complex calculations within a single cell, and offloading memory heavy process outside of Excel.

 

Schematiq’s library of functions allows users to work on whole blocks of data in one calculation rather than having to apply formulas to each row separately, reducing both complexity and errors.

For organisations wishing to undertake re-engineering initiatives of their risk and pricing technology, Schematiq can act as an accelerator, exposing these strategic services to Excel and ad-hoc analysis use cases.

 

Out-of-the-box connectors to the commonly used platforms and file formats such as JSON, XML and CSV, as well as custom connectors to in-house systems, are available.

Schematiq functions and connectors transform users’ productivity when working with new data sources and building reports.

 

Asset Manager enables the development of core templates for data retrieval that can support ad-hoc reporting requests, and can be saved and re-run seamlessly, eliminating time consuming manual processes.