Empowering Actionable
Uniper (white).png
 
Project: Risk Management in Trading

The Problem

  • New portfolio modelling approach being implemented, requiring integration with trading, market data and optimisation systems 
  • Ease of use made Excel indispensable for traders, but calculations were slow and workbooks tortuous to use and maintain
  • New system needed to have transparent calculations, be user-friendly and have flexibility to add incremental further functionality

Our Solution

  • Schematiq allowed an integrated solution, seamlessly combining users' customised sheets, new models and controlled data sources

  • Used Excel as the interface, but with Schematiq doing the heavy-lifting of data manipulation and interfacing

  • Agile implementation, with short initial delivery expanded after proven success, and continued development as new deal types added

Our Delivery Differentiators

  • Careful implementation: true agile approach, with demos available on a weekly basis

  • Flexible solution: old models were easily migrated and extended while new models were developed

  • For the first time traders were able to use strategic enterprise modeling and data capabilities within Excel

Results

  • Proof-of-concept implemented within weeks, followed quickly by first live trial

  • Excel used as a complete trading solution, from valuation and pricing through to reporting and risk

  • Traders can work with structured deals directly in Excel, and risk managers see when and how spreadsheets change

Underground gas storage.jpg

Gas trading involves the physical logistics of moving a commodity combined with the complexity of financial instruments, but by using Schematiq as the Traders' Workbench, in a single place traders can:

  • Connect to trade systems to view physical and financial positions
  • Run scenarios easily by importing asset and market data
  • Price new deals in a fast, controlled manner
VPP.jpg

Excel provides a familiar, yet customisable interface to power the Traders' Workbench. Schematiq then creates data-links to strategic data sources and models, including:

  • Quant models for optimising physical gas network including storage, physical demand assets and structured contracts (such as virtual power plants)
  • Valuation engines - direct access to end-of-day valuation models
  • Data repositories containing trade, asset and market price data