Installer

To install this version, please visit the installation guide.

Our Edgelab Add-in is now available on the Microsoft Store and Google Store. The add-in can be installed on MAC, and Windows and used in Google Sheets. Finally, the add-in is supported in Excel on Web as well.

Note that the add-in in Google Sheets offers fewer functionalities. However, all functions are available to perform analysis.

To enable these features in your Excel you should install the new Add-in version. It is recommended to perform a full uninstallation of any previous version of the Add-in.

New measures and a new granularity for PRG

  • Mean VaR: it is a more robust tail measure than VaR. You can benefit from it by using the confidence bounds instead of the confidence level.
  • Correlation: it captures the linear relationship between two variables.
  • PRG contributions: It is now possible to compute the positions’ contributions to the PRG.

Functions

New

  • ELVALUATIONDATES displays the valuation dates inside the Edgelab Add-in.
  • ELCURRENCIES displays the currencies that are supported inside the Edgelab Add-in.

New format

  • Before: There were functions starting with “el” and “ewr” where the amount had to be either quantities or weights respectively.
  • Now: There is only one type of function starting with “EL”. Quantities or weights are inserted in the parameter “amount” and in “amountScheme” you can specify either “quantity” or “weight”. To make the transformation to the new format easy, we prepared the migration buttons which automatically transform your functions.

Ribbon

The button “Error Helper” is no longer part of the Ribbon. The detailed messages will be directly displayed in the erroneous cells when the box In-cell error message is ticked inside Settings. The ribbon contains 3 new buttons that permit the transition to the new function formats: Transform the selected functions, Transform worksheet and Transform file.

Templates

In the cross asset group, we have discarded “Portfolio simulation - current” and “Portfolio simulation - rebalancing (incl. PRG)”. “Alternatives Analytics” is now named “Structured Products and Derivatives Analytics”.

Deprecations

Version 21.3 is now deprecated and will be removed at the end of the year from the documentation and will no longer be pro-actively monitored by the Add-in team.

PRC methodology “2017q4” is deprecated. “2020q3” is the default one.

Previous version

Version 21.8 is still available. However, it will not benefit from the new features.

Roadmap

The next release will aim at including the risk driver’s contribution to risk.

Please note that the information here is subject to change right up to release go-live time. This roadmap is not a commitment to provide any features within a certain time frame and enhancements to the product may change before release.