Schematiq Release 4.0

November 20, 2017 | Darren Harris
What's new in Schematiq 4.0 Highlights Version 4.0 brings a new, cleaner look and feel to the viewer, with Back / Forward browser-style navigation as well as the ability to click on parts of a cell formula to understand a calculation, and to follow links back to the previous cells in the calculation tree. Read More

Schematiq Detailed Introduction

September 25, 2017 | Darren Harris
Transforming an Option Pricer spreadsheet using Schematiq.  Externalise data held in spreadsheets, simplify complex forumula, increase calculation performance and govern shared spreadsheet logic. Read More

Schematiq Workbench

September 07, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform the way you use Microsoft Excel. Read More

Schematiq converts your Excel Spreadsheets into dynamic API's

August 11, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform your existing Excel spreadsheets into dynamic API's. Read More

Novae Group plc improves their Capital Modelling Process in Microsoft Excel using Schematiq.

July 13, 2017 | Darren Harris
Novae Group, a Lloyd's of London insurer, has been listed on the London Stock Exchange since 1998 and wrote premiums of over £900m in value in 2016. When Novae Group wanted to enhance their Capital planning process the amount and complexity of data meant that their models could only be updated a few times a year.  Read More

Schematiq solves the Top 4 Excel Challenges for Insurance Firms

May 25, 2017 | Darren Harris
  Microsoft Excel is pervasive across the insurance industry, particularly in areas such as capital modelling, forecasting, pricing optimisation, risk management and regulatory reporting. However, while Excel itself is robust, the error prone spreadsheets people create can be fragile. Errors are caused by manual data entry, cutting and pasting data and formula complexity can simply generate wrong numbers.  For insurers, this can lead to incorrect regulatory reporting (under GAAP, IFRS and Solvency II) and material misstatements resulting significant losses, fines and reputational damage. Read More

Microsoft Excel and BCBS 239 – 7 Steps to transform your End User Compute (EUC) capability

March 01, 2017 | Darren Harris
September 15th 2008, the day that Lehman Brothers Holdings Inc. filed for Chapter 11bankruptcy protection was another significant milestone in the global financial crisis that began in 2007. For those of us working at Credit Suisse during this entire period, fire drills [urgent business requests] were an hourly occurrence as we fought to respond to ad-hoc requests from the business in the face of swinging markets and creaking models (negative interest rates anyone?). Read More

Data Links, Viewer and a little bit of Magic brought to Microsoft Excel.

September 29, 2016 | Darren Harris
When introducing the Workbench to someone for the first time, we typically start by explaining two innovations that we’ve introduced into Excel called ‘Data Links’ and the ‘Viewer’. Grasping these concepts is..key to understanding the technology underpinning Schematiq and how it delivers new capabilities to users of Microsoft Excel. Read More