Installer

The new installer is available here.

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.

In this release, we deliver the following new components, functions and improvements.

New Components

  • Asset Proxy: The management of asset proxies is now centralized into a single external configuration file that is connected to all your Excel workbooks. It’s accessible through the Edgelab ribbon and you no longer need to calibrate asset proxies using the elProxyCleanidentifier function.

  • Universe Portal: The universe portal is a tool that centralizes the management of your asset universe and ensures that pre-calculations for portfolios and stand alone assets are available. With it, you can add or remove assets, and keep track of your overall universe. Now you can access the portal directly through the Edgelab ribbon and synchronize any change you make.

  • Function Helper: It’s a helper box that aids you complete functions by highlighting the correct inputs to insert.

  • Error Helper: It’s a helper box that aids you trace the cause of the #VALUE error. You just need to click on the “Error Helper” in the Edgelab ribbon and a message will indicate what is wrong and how to fix it. You can use this box to solve and navigate errors one by one. The feature can be disabled at any time.

New functions

  • elAssetMeasure: This function comes as a new UDF for fixed income and structured product instruments. It provides a variety of key measures such as yield-to-call, yield-to-maturity, yield-to-perpetuity etc.

  • ewrDistribution: This function provides the returns distribution of your instruments or portfolio according to 500 possible outcomes, given the selected scenario type, currency and time horizon.

  • elAssetProxy: If an input asset is covered by a proxy, this function returns the asset proxy ID presented in the configuration file. If not, it returns a blank cell.

Enhancements

  • New stress scenario: A historical stress scenario on the COVID-19 pandemic is available.

  • *3elFixedIncomeShift**: There is no longer need to manually divide Convexity by 10000². It has been implemented in the algorithm.

  • Boost Performance: Our Add-in allows now up to 100 requests to be calculated at the same time, without blocking the Excel interface . The #GETTING_DATA status appears while getting the information from our servers.

  • Troubleshooting documentation: Now it covers more situations that you can easily handle: installation issue, spilled array formulas, network proxy, installation dependencies, the asset proxy configuration file and the Error Helper message.

Removals

As the following function and calculation levels were deprecated in the last version, they are now removed.

  • elRiskMetric: This function is now removed. elRiskMeasure, elPrc or elCurrentMeasure must be used instead.

  • Aggregates & Allocations: Both calculations level must be replaced by portfolio and positions respectively. For more information refers to the Calculation Level.

Deprecations

The following Scenario Type and function are deprecated.

  • Simulated: This multi-variate Monte Carlo simulation is now deprecated and will be removed in the next release.

  • elProxyCleanIdentifiers: This function should be replaced by the asset proxy configuration file.

Roadmap

By the end of the year, the main focus will be on the following aspects:

  • Calculating the benefit of diversification thanks to the function elDiversificationBenefit.
  • Computing the yield of a fixed income by inserting the current market price of the instrument in the dedicated function.