SIMM for Excel

Access the power of cloud-hosted SIMM analytics directly from spreadsheets

For financial firms using ISDA SIMM, we offer a free trial

Start your FREE Trial »

CLARUS Excel Workbook or Add-in

SIMM Initial Margin and what-if analysis

Generate CRIF sensitivities

Easy to Trial, Purchase and Start Using

Learn about SIMM for Excel


Latest Posts

  • Sep, 20

    Margin for Non-Cleared Derivatives

    Uncleared Margin Rules (UMR) for IM have now been in force for one year The ISDA Margin Survey 2017 provides a snapshot of IM delivered and received $47.2 billion and $46.6 billion respectively, between Phase One firms (March 31, 2017) I look at how the figures compare to an $800 billion estimate from 2012 What […]

    Read more
    Sep, 12

    ISDA SIMM 2.0 – What You Need to Know

    ISDA SIMM version 2.0 is coming in December 2017. Re-calibration and new risk factors will mean Initial Margin changes for all portfolios. SIMM for Excel gives you the tools to understand and model these changes. Quickly compare before/after SIMM levels in Excel. Drill-down into Counterparty and Risk Factor levels. Perform your own analysis and optimisation […]

    Read more
  • Sep, 5

    VM Big Bang – Impact on FX Markets

    The six month reprieve from UMRs expired 1st September. We look at trading in uncleared markets in the past six months to see if anything changed. The number of uncleared IRS trades has shrunk by 50% as the regulations took hold. Products with no cleared alternatives continue to trade bilaterally. Volumes have continued to be […]

    Read more
    Aug, 9

    Array Formulas in Excel

    We explain how to work with Array Formulas in Excel. Master the Three Finger Salute CTRL+SHIFT+ENTER. CTRL+/ is an amazingly effective shortcut. It is always easier to expand an array than shrink it. Consistent formatting provides an obvious visual cue when working with arrays. SIMM for Excel SIMM for Excel is an add-in that performs […]

    Read more
  • Aug, 2

    ISDA SIMM™ IN PYTHON

    The Clarus Microservices API makes it very easy to compute ISDA SIMM™ from Python The input data required is a CRIF file contain risk sensitivities What-if trades can be easily added to determine the incremental change in margin We provide a Sandbox within our API Reference page for you to try the API methods Before moving […]

    Read more
    Jul, 18

    ISDA SIMM For Excel

    SIMM for Excel performs ISDA SIMM™ Initial Margin calculations from Excel. Free 14-day trials are available for all financial firms. Reconcile ISDA SIMM calculations. Perform pre-trade analysis of your bilateral trades quickly, simply, reliably. The functions calculate Initial Margin across a whole portfolio. Users can also create CRIF sensitivities from trade-level details. Functions That Won’t Kill Excel Our […]

    Read more
  • Apr, 18

    Microservices: ISDA SIMM™ in R

    The Clarus API has a function to compute ISDA SIMM™ from a CRIF file contain portfolio sensitivities. What-if analysis can be performed in addition to the portfolio margin calculation. The function is very easy to call from many popular languages, including R, Python, C++, Java and Julia. What is R? R is a language and […]

    Read more
    Apr, 5

    ISDA SIMM™ in Excel – Cross Currency Swaps

    The ISDA SIMM™ methodology has been expanded to include Cross Currency Swaps. We explain in detail how to create the required input sensitivities. These sensitivities are not the typical cross currency basis risk that a risk management system would calculate. Once the input sensitivities are calculated, the calculation of Initial Margin follows the typical SIMM equations. We show how […]

    Read more
  • Apr, 4

    Microservices: A SIMM Sensitivities Calculator

    The Clarus API has a function to compute SIMM sensitivities from many trade description formats, including FpML and CSV trade lists. Results are in ISDA SIMM™ CRIF file format. The function is easily called from popular languages, e.g. Python, R, Julia, C++, and Java. Many related functions are available, see our API documentation. Calling directly […]

    Read more
    Mar, 1

    ISDA SIMM™ in Excel – Equity Options

    We build an IM calculator in Excel for Equity Options under ISDA SIMM™. The methodology builds on the margin methodology for Swaptions, and uses very similar formulae. We cover all forms of IM. This blog is for the Vega and Curvature Margin. There are subtle differences to the implementation for Rates. UPDATE: We now offer free […]

    Read more