# Release Notes ## 1.1.0.11887 (2025-08-14) ### Updated * [**LOSSPR**](/functions/exposure-to-loss/losspr.md) 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** ](/functions/general/ismatrixpsd.md)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** ](/functions/return-models/impliedreturns.md)added specification for covariance matrix as an optional parameter. * [**PSR** ](/functions/regression-analysis/psr.md)improved handling for machine epsilon. * [**ISMATRIXPSD** ](/functions/general/ismatrixpsd.md)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**](/functions/return-models/desmoothreturns.md) 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** ](/functions/scenario-analysis/impliedscenario.md)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**](/functions/risk-models/mlerisk.md) and [**MLERETURNS**](/functions/return-models/mlereturns.md) 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** ](/functions/simulation/bootstrap.md)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**](/functions/general/xlabinfo.md) now also returns general information in cell in addition to a UI dialog. * [**MAHALANOBIS** ](/functions/scenario-analysis/mahalanobis.md#syntax)new optional input arguments, giving you more control. * [**QUIETRISK**](/functions/risk-models/quietrisk.md) the threshold parameter is now based from an inliers perspective. * [**PSR** ](/functions/regression-analysis/psr.md)minor refinements to code elegance and speed. ## 1.0.0.10855 (2021-01-01) Happy new year :tada: ### Added * [**MATRIX** ](/functions/general/matrix.md)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** ](/functions/scenario-analysis/scenariopr.md#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** ](/functions/optimization/mvfrontier.md)solve for multiple optimal portfolios on the efficient frontier. * [**MTFRONTIER** ](/functions/optimization/mtfrontier.md)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** ](/functions/exposure-to-loss/maxdd.md)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** ](/functions/risk-models/portfoliorisk.md)forget nested MMULT and SUMPRODUCT formulas! Vector math simplified! ### Updated * [**PSR** ](/functions/regression-analysis/psr.md#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** ](/functions/return-models/capm.md)calculate equilibrium returns * [**IMPLIEDRETURNS** ](/functions/return-models/impliedreturns.md)run a reverse optimization * [**MLERETURNS** ](/functions/return-models/mlereturns.md)maximum-likelihood return estimates * [**ANNUALIZERISK** ](/functions/risk-models/annualizerisk.md)annualize risk to account for compounding and log-normality * [**EWMA** ](/functions/risk-models/ewma.md)exponential moving average risk model * [**HISTORICALRISK** ](/functions/risk-models/historicalrisk.md)estimate expected risk from historical data * [**MAHALANOBIS** ](/functions/scenario-analysis/mahalanobis.md)compute the Mahalanobis distance statistic * [**MLERISK** ](/functions/risk-models/mlerisk.md)maximum-likelihood risk estimates * [**TURBULENTRISK** ](/functions/risk-models/turbulentrisk.md)estimate risk based on statistical outliers * [**QUIETRISK** ](/functions/risk-models/quietrisk.md)estimate risk based on statistical inliers * [**MVT** ](/functions/optimization/mvt.md)multi-goal optimization (mean-variance tracking error) * [**MVO** ](/functions/optimization/mvo.md)mean-variance optimization * [**MTO** ](/functions/optimization/mto.md)mean-tracking error optimization * [**ISORETURN** ](/functions/optimization/isoreturn.md)solve for an iso-return efficient frontier (risk vs. tracking error) * [**FACTORANALYSIS** ](/functions/regression-analysis/factoranalysis.md)run multi-factor OLS and stepwise regression analysis * [**LOSSPR** ](/functions/exposure-to-loss/losspr.md)estimate probability of loss continuously and conventionally * [**OMEGARATIO** ](/functions/exposure-to-loss/omegaratio.md)calculate the omega ratio * [**PSR** ](/functions/regression-analysis/psr.md)run partial-sample regressions, a new novel approach to regression analysis * [**SORTINORATIO** ](/functions/exposure-to-loss/sortinoratio.md)calculate the Sortino ratio * [**TAILRATIO** ](/functions/exposure-to-loss/tailratio.md)estimate tail ratio from empirical data * [**VALUEATRISK** ](/functions/exposure-to-loss/valueatrisk.md)estimate value at risk measures continuously and conventionally * [**ISMATRIXPSD** ](/functions/general/ismatrixpsd.md)check matrix for positive semi-definite (PSD) properties / solve to nearest PSD values * [**MCNORM** ](/functions/simulation/mcnorm.md)simulate multi-variate normal random values using Monte-Carlo * [**SCENARIOPR** ](/functions/scenario-analysis/scenariopr.md)calculate scenario probabilities implied from empirical data --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://excelhelp.windhamlabs.com/release-notes.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.