What is an array formula?Įxcel functions typically return a single value. Here is how to work with array formulas in Excel. To implement this in Excel, we must use “array formulas”.
The results that are returned are not necessarily single values – we return a grid of results ( x rows by y columns). Then we send the results back to your Excel spreadsheet. Send us the function name and parameters and we do the rest remotely. It is quick, simple to use and reliable.Ĭloud-hosted analytics are made available to users via a data connection in Excel. These tools allow you to reconcile ISDA SIMM calculations, as well as performing pre-trade analytics across whole portfolios. We offer a 14-day free trial to get you started, along with example workbooks.
SIMM for Excel is an add-in that performs ISDA SIMM Initial Margin calculations from Excel.