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.

New Functions

Diversification benefit: You can measure how well your portfolio is diversified with the functions elDiversificationBenefit (which uses quantity as a parameter) and ewrDiversificationBenefit (which uses weight as a parameter). The closer the result to 1 is, the more your portfolio benefits from diversification.

Yields for fixed income instruments: The function elYieldSolving allows you to measure several different yields for fixed income instruments given their price: yield-to-maturity, yield-to-put, yield-to-call, current-yield.

Portfolio benchmarking: Four new functions allow you to measure your portfolio against its benchmark: elBenchmarkMeasure and ewrBenchmarkMeasure (which compute various benchmarks measures) and elTrackingError and ewrTrackingError (which compute directly the tracking error). The “el” functions use quantities as a parameter, while the “ewr” functions - weight.

Enhancements

Simplified asset proxy configuration: When you use the weight-based functions (“ewr”), it’s not necessary to enter values for “Asset Last Price” and “Asset Currency” in the asset proxy configuration file.

Removals

In the last release note, we announced the deprecation of the following scenario type and function. With this release, we remove them.

  • Simulated or Monte Carlo: Only “historicalInnovations” and “historicalReturns” are available.
  • elProxyCleanIdentifiers: The asset proxy feature replaces this function.

Version support

In 2020, we released several major enhancements to our Excel Add-in. So far, we have maintained all versions in parallel. As of next year, we will focus on providing support only to the latest two versions. This will enable us to focus more resources on further strengthening and expanding our Excel Add-in capabilities.

From January 2021:

  • The supported versions will be version 20.12 (released on December 29, 2020) and version 20.7.2 (released on October 30, 2020).
  • All manuals and installers of earlier versions than 20.04 will be removed from our website.

We encourage you always to use the latest Excel Add-in version because it contains the newest features and product enhancements. Our team stays at your disposal to facilitate version upgrades.

Roadmap

The next product release is planned for April 2021. It will come with a long-awaited feature: pre-designed Excel templates that address various portfolio management needs.

In January 2021, we’ll share with you more details of our annual roadmap. Should you need any particular feature or enhancement, please reach out to us and we will do our best to accommodate your needs.

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 by a certain time frame and enhancements to the product may change before release.