# Release Notes ## 1.1.0.11887 (2025-08-14) ### Updated * [**LOSSPR**](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/losspr) revised for vectorization support. ## 1.1.0.11885 (2025-05-02) Spring cleaning season! ### Updated Prerequisites for Matlab runtime updated for version 24.2 ## 1.0.0.11884 (2023-12-26) Happy holidays! Santa has been busy, new API connection this holiday season. ### Added New licensing server API connection. * New licensing API connection. ## 1.0.0.11875 (2023-12-01) Preparations for licensing server upgrade support for unlock code feature. ## 1.0.0.11863 (2023-10-09) Fixed a gremlin that is fussy on double-precision machine errors. ### Updated * [**ISMATRIXPSD** ](https://excelhelp.windhamlabs.com/functions/general/ismatrixpsd)now checks and accounts for double-precision differences in the upper and lower triangular corrected matrix, i.e. symmetry is verified. ## 1.0.0.11845 (2023-06-27) Refinements to several existing functions and new runtime framework. ### Updated * [**IMPLIEDRETURNS** ](https://excelhelp.windhamlabs.com/functions/return-models/impliedreturns)added specification for covariance matrix as an optional parameter. * [**PSR** ](https://excelhelp.windhamlabs.com/functions/regression-analysis/psr)improved handling for machine epsilon. * [**ISMATRIXPSD** ](https://excelhelp.windhamlabs.com/functions/general/ismatrixpsd)now uses Newton's method by minimizing the Frobenius distance. * New runtime (9.13). ## 1.0.0.11555 (2022-08-05) Added desmoothing returns functionality to Excel Lab. ### Added * [**DESMOOTHRETURNS**](https://excelhelp.windhamlabs.com/functions/return-models/desmoothreturns) using a first-order autoregressive model. ### Updated * Improvements to authentication process. ## 1.0.0.11271 (2021-11-18) Introducing scenario modification functionality to Excel Lab based on our innovations in [scenario analysis](https://doi.org/10.3905/jpm.2020.1.125). ### Added * [**IMPLIEDSCENARIO** ](https://excelhelp.windhamlabs.com/functions/scenario-analysis/impliedscenario)solve for the implied scenario estimates across economic variables to reconcile with your target probabilities. ## 1.0.0.11166 (2021-09-07) Small improvements to calculator logic and verification. ### Updated * Default marshalling between Microsoft Excel and Excel Lab's engine for missing values. This will impact [**MLERISK**](https://excelhelp.windhamlabs.com/functions/risk-models/mlerisk) and [**MLERETURNS**](https://excelhelp.windhamlabs.com/functions/return-models/mlereturns) where users will have to explicitly specify missing values in their workbook's cells as $$=\text{NA()}$$ in the formula bar. ## 1.0.0.10882 (2021-01-15) It has been an exciting week working with early adopters, we have had very constructive feedback. ### Added * [**BOOTSTRAP** ](https://excelhelp.windhamlabs.com/functions/simulation/bootstrap)sample from a dataset with replacement with equal or custom probability weights across sample periods. Draw from a univariate or multivariate sample with the option to apply a set of portfolio weights to the multivariate sample. ### Updated * Wrapper fix for **VERIFYLICENSE**. ## 1.0.0.10874 (2021-01-11) It has been an exciting week working with early adopters, we have had very constructive feedback. ### Updated * [**XLABINFO**](https://excelhelp.windhamlabs.com/functions/general/xlabinfo) now also returns general information in cell in addition to a UI dialog. * [**MAHALANOBIS** ](https://excelhelp.windhamlabs.com/functions/scenario-analysis/mahalanobis#syntax)new optional input arguments, giving you more control. * [**QUIETRISK**](https://excelhelp.windhamlabs.com/functions/risk-models/quietrisk) the threshold parameter is now based from an inliers perspective. * [**PSR** ](https://excelhelp.windhamlabs.com/functions/regression-analysis/psr)minor refinements to code elegance and speed. ## 1.0.0.10855 (2021-01-01) Happy new year :tada: ### Added * [**MATRIX** ](https://excelhelp.windhamlabs.com/functions/general/matrix)concatenate disjointed vectors (or matrices) quickly and intuitively within Excel. ### Updated * Security enhancements in offline license manager. ## 1.0.0.10853 prerelease (2020-12-30) Ready for prime time! ### Added * [**SCENARIOPR** ](https://excelhelp.windhamlabs.com/functions/scenario-analysis/scenariopr#syntax)added an optional free parameter to model fatter tails for calculating scenario probabilities. ### Updated * Improved licensing verification. * Revised matrix orientation and dimensional fixes for iso-curve functions. ## 1.0.0.10752 prerelease (2020-11-13) Feature-creep is getting intense! ### Added * [**MVFRONTIER** ](https://excelhelp.windhamlabs.com/functions/optimization/mvfrontier)solve for multiple optimal portfolios on the efficient frontier. * [**MTFRONTIER** ](https://excelhelp.windhamlabs.com/functions/optimization/mtfrontier)solve for multiple optimal portfolios to evaluate relative risk. ## 1.0.0.10746 prerelease (2020-11-11) Sometimes, we have to regress in order to progress :sweat\_smile: ### Added * [**MAXDD** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/maxdd)maximum drawdown in Excel - forget your VBA code upkeep! * **COVMATRIX** an much easier and direct way to compute covariance matrix, with the ability to treat missing data as well. * **CORRMATRIX** you can't have the covariance matrix without some correlation coefficients. * [**PORTFOLIORISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/portfoliorisk)forget nested MMULT and SUMPRODUCT formulas! Vector math simplified! ### Updated * [**PSR** ](https://excelhelp.windhamlabs.com/functions/regression-analysis/psr#syntax)added argument to allow the specification for the predictor values for the partial sample regression model. This allows the analyst to specify any set of predictor values to evaluate a response for the dependent variable forecast based. If not specified, as previously implicitly assumed, the most recent observations of the dependent variables are used with the model parameters for forecasting. ## 1.0.0.10720 prerelease (2020-11-03) Hello world! Lots of coffee and rock music in the background at [Windham Labs](https://www.windhamlabs.com/). The Excel Lab quant library is being tested and worked on extensively by the team. We are getting things ready to bring this exciting tool to your desk. ### Added * [**CAPM** ](https://excelhelp.windhamlabs.com/functions/return-models/capm)calculate equilibrium returns * [**IMPLIEDRETURNS** ](https://excelhelp.windhamlabs.com/functions/return-models/impliedreturns)run a reverse optimization * [**MLERETURNS** ](https://excelhelp.windhamlabs.com/functions/return-models/mlereturns)maximum-likelihood return estimates * [**ANNUALIZERISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/annualizerisk)annualize risk to account for compounding and log-normality * [**EWMA** ](https://excelhelp.windhamlabs.com/functions/risk-models/ewma)exponential moving average risk model * [**HISTORICALRISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/historicalrisk)estimate expected risk from historical data * [**MAHALANOBIS** ](https://excelhelp.windhamlabs.com/functions/scenario-analysis/mahalanobis)compute the Mahalanobis distance statistic * [**MLERISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/mlerisk)maximum-likelihood risk estimates * [**TURBULENTRISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/turbulentrisk)estimate risk based on statistical outliers * [**QUIETRISK** ](https://excelhelp.windhamlabs.com/functions/risk-models/quietrisk)estimate risk based on statistical inliers * [**MVT** ](https://excelhelp.windhamlabs.com/functions/optimization/mvt)multi-goal optimization (mean-variance tracking error) * [**MVO** ](https://excelhelp.windhamlabs.com/functions/optimization/mvo)mean-variance optimization * [**MTO** ](https://excelhelp.windhamlabs.com/functions/optimization/mto)mean-tracking error optimization * [**ISORETURN** ](https://excelhelp.windhamlabs.com/functions/optimization/isoreturn)solve for an iso-return efficient frontier (risk vs. tracking error) * [**FACTORANALYSIS** ](https://excelhelp.windhamlabs.com/functions/regression-analysis/factoranalysis)run multi-factor OLS and stepwise regression analysis * [**LOSSPR** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/losspr)estimate probability of loss continuously and conventionally * [**OMEGARATIO** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/omegaratio)calculate the omega ratio * [**PSR** ](https://excelhelp.windhamlabs.com/functions/regression-analysis/psr)run partial-sample regressions, a new novel approach to regression analysis * [**SORTINORATIO** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/sortinoratio)calculate the Sortino ratio * [**TAILRATIO** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/tailratio)estimate tail ratio from empirical data * [**VALUEATRISK** ](https://excelhelp.windhamlabs.com/functions/exposure-to-loss/valueatrisk)estimate value at risk measures continuously and conventionally * [**ISMATRIXPSD** ](https://excelhelp.windhamlabs.com/functions/general/ismatrixpsd)check matrix for positive semi-definite (PSD) properties / solve to nearest PSD values * [**MCNORM** ](https://excelhelp.windhamlabs.com/functions/simulation/mcnorm)simulate multi-variate normal random values using Monte-Carlo * [**SCENARIOPR** ](https://excelhelp.windhamlabs.com/functions/scenario-analysis/scenariopr)calculate scenario probabilities implied from empirical data