Excel provides traders with a flexible way to model trades, and create on-the-fly scenarios, but is not powerful enough to handle all the data in a modern trading environment - until now

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


  • 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

"An example of how a smaller dev team of highly skilled people can achieve more than much larger teams"

Senior client, Uniper

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

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

  • LinkedIn
white logo (1) (1).png