{"version":1,"pages":[{"id":"-MK66BCWIuG5yieMLz8K","title":"Excel Lab","pathname":"/","siteSpaceId":"sitesp_R2F2u","description":"Knowledge base to support Excel Lab, a quantitative modeling library for asset allocation and factor analysis - a Windham Labs technology solution."},{"id":"-MLDv2jlg97Ah5wNljnW","title":"Release Notes","pathname":"/release-notes","siteSpaceId":"sitesp_R2F2u","description":"Change log for communicating new features, fixes, and revisions of Excel Lab."},{"id":"-MMvCfeLtDHgm6xstEM4","title":"Installing Excel Lab","pathname":"/getting-started/installing-excel-lab","siteSpaceId":"sitesp_R2F2u","description":"Excel Lab is a powerful add-in that provides access to Windham's quant library spanning modern portfolio theory concepts including optimization, linear algebra, statistics, and probability theory.","breadcrumbs":[{"label":"Getting Started"}]},{"id":"-MQE6LVVl8CFno7AFDAC","title":"Step 1: Download Files","pathname":"/getting-started/installing-excel-lab/setup-files","siteSpaceId":"sitesp_R2F2u","description":"The following page contains all the necessary files required for installing Excel Lab.","breadcrumbs":[{"label":"Getting Started"},{"label":"Installing Excel Lab"}]},{"id":"-MQE6uo8wNWMV8JUELsq","title":"Step 2: Register Libraries","pathname":"/getting-started/installing-excel-lab/register-files","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Getting Started"},{"label":"Installing Excel Lab"}]},{"id":"-MQE79-fwQh_PfCiDATB","title":"Step 3: Activate Add-in","pathname":"/getting-started/installing-excel-lab/activate-add-in","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Getting Started"},{"label":"Installing Excel Lab"}]},{"id":"-MQE7ODSg02oYI30k1Px","title":"Step 4: Verify Installation","pathname":"/getting-started/installing-excel-lab/verify-installation","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Getting Started"},{"label":"Installing Excel Lab"}]},{"id":"-MPz_o9vZXAjuF02jP98","title":"General","pathname":"/functions/general","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MQNetRIo5cJB91eIdl8","title":"ISMATRIXPSD","pathname":"/functions/general/ismatrixpsd","siteSpaceId":"sitesp_R2F2u","description":"Verify if a matrix is positive semidefinite. Solve for the nearest positive semidefinite matrix if it is not.","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"-MPzaFJszAptCeuXdPWu","title":"MATRIX","pathname":"/functions/general/matrix","siteSpaceId":"sitesp_R2F2u","description":"Concatenate disjointed arrays in Excel column (or row)-wise into a matrix","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"-MLDsw0RiXVo8Mbj2Xio","title":"XLABHELP","pathname":"/functions/general/xlabhelp","siteSpaceId":"sitesp_R2F2u","description":"Getting help within Excel for the Excel Lab quant library.","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"-MLDuDLfYySIXClHQ52l","title":"XLABINFO","pathname":"/functions/general/xlabinfo","siteSpaceId":"sitesp_R2F2u","description":"Retrieve information about the Excel Lab quant library installed on your workstation.","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"-MPeB75Z3JdaptHK5jWl","title":"XLABLICENSE","pathname":"/functions/general/xlablicense","siteSpaceId":"sitesp_R2F2u","description":"Invoke authentication with licensing servers to enable or re-enable your use of Excel Lab.","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"Mzmg4vkjOCx79TgmuXEg","title":"RESETPASSWORD","pathname":"/functions/general/resetpassword","siteSpaceId":"sitesp_R2F2u","description":"Update and set a new password for your user account","breadcrumbs":[{"label":"Functions"},{"label":"General"}]},{"id":"-MLPpxZP5meV-Zmgpd7e","title":"Return Models","pathname":"/functions/return-models","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MKtlqQpsTx7v_K5sNy-","title":"CAPM","pathname":"/functions/return-models/capm","siteSpaceId":"sitesp_R2F2u","description":"Estimate expected returns using the Capital Asset Pricing Model. This is also known as the Equilibrium Returns.","breadcrumbs":[{"label":"Functions"},{"label":"Return Models"}]},{"id":"E9wczuls5NGYJq1ZtwRo","title":"DESMOOTHRETURNS","pathname":"/functions/return-models/desmoothreturns","siteSpaceId":"sitesp_R2F2u","description":"Desmooth time series returns using a first-order autoregressive model.","breadcrumbs":[{"label":"Functions"},{"label":"Return Models"}]},{"id":"-MKuKMfIGBON5wDo5jau","title":"IMPLIEDRETURNS","pathname":"/functions/return-models/impliedreturns","siteSpaceId":"sitesp_R2F2u","description":"Calculate implied expected returns of your assets / instruments.","breadcrumbs":[{"label":"Functions"},{"label":"Return Models"}]},{"id":"-MKuZSZxu6t9UAO-x--m","title":"MLERETURNS","pathname":"/functions/return-models/mlereturns","siteSpaceId":"sitesp_R2F2u","description":"Estimate expected returns for assets with incomplete historical data (unequal lengths) with a maximum likelihood estimator.","breadcrumbs":[{"label":"Functions"},{"label":"Return Models"}]},{"id":"-MLPq6FtgbfO8kLyZvD7","title":"Risk Models","pathname":"/functions/risk-models","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-ML8bbsy1j0JytWln5KY","title":"ANNUALIZERISK","pathname":"/functions/risk-models/annualizerisk","siteSpaceId":"sitesp_R2F2u","description":"Annualize discrete estimates of standard deviation to account for the compounding effects on assets.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-MKv9uI3EeyklE-_YByK","title":"EWMA","pathname":"/functions/risk-models/ewma","siteSpaceId":"sitesp_R2F2u","description":"Estimate expected risk, correlation matrix, or covariance matrix for assets using the exponential-weighted moving average risk model (EWMA).","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-ML8aY1A2WYgEyWMxjRR","title":"HISTORICALRISK","pathname":"/functions/risk-models/historicalrisk","siteSpaceId":"sitesp_R2F2u","description":"Estimate expected risk, correlation matrix, or covariance matrix for assets using historical data.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-MKuh_Trtb76SvQpyA7V","title":"MLERISK","pathname":"/functions/risk-models/mlerisk","siteSpaceId":"sitesp_R2F2u","description":"Estimate expected risk, correlation matrix, or covariance matrix for assets with incomplete historical data (unequal lengths) with a maximum likelihood estimator.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-MQNikU7GUpXeoN2z2Th","title":"PORTFOLIORISK","pathname":"/functions/risk-models/portfoliorisk","siteSpaceId":"sitesp_R2F2u","description":"Calculate portfolio risk from a vector of weights, risk, and correlation matrix.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-ML9_U9rXdSxZEsewtYV","title":"TURBULENTRISK","pathname":"/functions/risk-models/turbulentrisk","siteSpaceId":"sitesp_R2F2u","description":"A robust statistical risk model using the Mahalanobis distance.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-ML9pARiPC9FpIAjVcjc","title":"QUIETRISK","pathname":"/functions/risk-models/quietrisk","siteSpaceId":"sitesp_R2F2u","description":"A robust statistical risk model using the Mahalanobis distance.","breadcrumbs":[{"label":"Functions"},{"label":"Risk Models"}]},{"id":"-MLPqQ-Ss3d6lqCF0QFn","title":"Optimization","pathname":"/functions/optimization","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MLKANjKpfhbttyAimCv","title":"MVO","pathname":"/functions/optimization/mvo","siteSpaceId":"sitesp_R2F2u","description":"Mean-variance optimization, a quadratic programming optimizer.","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MLo7pmmMXjB_Z5VPELo","title":"MTO","pathname":"/functions/optimization/mto","siteSpaceId":"sitesp_R2F2u","description":"Mean-tracking-error optimization, maximize your return in excess of a benchmark while minimizing tracking-error.","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MLt3qOKjiYXjtuGdZyx","title":"MVT","pathname":"/functions/optimization/mvt","siteSpaceId":"sitesp_R2F2u","description":"Optimize portfolio allocations for absolute and relative performance with this multi-goal optimization function. Maximize return while minimizing risk and tracking-error (Mean-variance-tracking-error)","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MM1z7Sw4GOxiVflETLL","title":"MVFRONTIER","pathname":"/functions/optimization/mvfrontier","siteSpaceId":"sitesp_R2F2u","description":"Solve for the Mean-Variance efficient frontier. Optimize for multiple portfolios to evaluate trade-offs.","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MM27nl7Lqih7cE5q1uS","title":"MTFRONTIER","pathname":"/functions/optimization/mtfrontier","siteSpaceId":"sitesp_R2F2u","description":"Solve for the Mean-Tracking-Error efficient frontier. Optimize for multiple portfolios to evaluate return and risk trade-offs in relative return space (active management).","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MM2EmU6kSDedgVboaut","title":"ISORETURN","pathname":"/functions/optimization/isoreturn","siteSpaceId":"sitesp_R2F2u","description":"Solve for an iso-return efficient frontier. Construct an efficient frontier to evaluate the risk and tracking-error tradeoffs.","breadcrumbs":[{"label":"Functions"},{"label":"Optimization"}]},{"id":"-MMuo8iLySJLr7rEKEZN","title":"Simulation","pathname":"/functions/simulation","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MMuoCN9LXc4i0IcuWos","title":"MCNORM","pathname":"/functions/simulation/mcnorm","siteSpaceId":"sitesp_R2F2u","description":"Simulate a matrix of multivariate normal returns using Monte-Carlo with the option to preserve an expected correlation structure.","breadcrumbs":[{"label":"Functions"},{"label":"Simulation"}]},{"id":"-MR601-yiL4_cXyMnHI8","title":"BOOTSTRAP","pathname":"/functions/simulation/bootstrap","siteSpaceId":"sitesp_R2F2u","description":"Simulate values by bootstrap sampling from a dateset. The bootstrap method allows for a uniform random sampling, or a biased (probability-weighted) sampling method, useful for scenario analysis.","breadcrumbs":[{"label":"Functions"},{"label":"Simulation"}]},{"id":"-MLPqiktV4P4cvHGjW4v","title":"Exposure to Loss","pathname":"/functions/exposure-to-loss","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MLDYSRYAWShBn-tVPv2","title":"LOSSPR","pathname":"/functions/exposure-to-loss/losspr","siteSpaceId":"sitesp_R2F2u","description":"Measure the probability of loss at throughout an investment horizon (first-passage time) or at the end of horizon.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MLDhjoD581UZWzAJtJP","title":"OMEGARATIO","pathname":"/functions/exposure-to-loss/omegaratio","siteSpaceId":"sitesp_R2F2u","description":"Measure the probability weighted ratio of gains to losses for a given target return.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MLDjEliOBk7LIDTjfxO","title":"SORTINORATIO","pathname":"/functions/exposure-to-loss/sortinoratio","siteSpaceId":"sitesp_R2F2u","description":"Measure risk-adjusted returns relative to downside deviations.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MLDcX8t3eo_HBPWpwjQ","title":"TAILRATIO","pathname":"/functions/exposure-to-loss/tailratio","siteSpaceId":"sitesp_R2F2u","description":"Determine the relative magnitude of losses to gains within an empirical distribution.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MLABP4QdoREoSTDvvAn","title":"VALUEATRISK","pathname":"/functions/exposure-to-loss/valueatrisk","siteSpaceId":"sitesp_R2F2u","description":"Estimate exposure to loss of your portfolio with the Value at Risk framework.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MMubNUyXxzjg8JO0Vdk","title":"MAXDD","pathname":"/functions/exposure-to-loss/maxdd","siteSpaceId":"sitesp_R2F2u","description":"Calculate the maximum drawdown for time series returns.","breadcrumbs":[{"label":"Functions"},{"label":"Exposure to Loss"}]},{"id":"-MLPr3WkFSfpt5cJGxzW","title":"Regression Analysis","pathname":"/functions/regression-analysis","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-MLDqANwIBNc0y3GFjlY","title":"FACTORANALYSIS","pathname":"/functions/regression-analysis/factoranalysis","siteSpaceId":"sitesp_R2F2u","description":"Evaluate your assets, managers, and portfolios against factors (economic variables, signals, risk models). Decompose risk and return of your instruments using multi-factor or stepwise regressions.","breadcrumbs":[{"label":"Functions"},{"label":"Regression Analysis"}]},{"id":"-MLDraN9iMU3IDTbkXQU","title":"PSR","pathname":"/functions/regression-analysis/psr","siteSpaceId":"sitesp_R2F2u","description":"Partial-sample regression function to estimate the similarity, informativeness, and relevance of dependent variables.","breadcrumbs":[{"label":"Functions"},{"label":"Regression Analysis"}]},{"id":"-MM1yjcTT9V5ZON2Mvni","title":"Scenario Analysis","pathname":"/functions/scenario-analysis","siteSpaceId":"sitesp_R2F2u","description":"","breadcrumbs":[{"label":"Functions"}]},{"id":"-ML9sL6G26QSRBYS6fqi","title":"MAHALANOBIS","pathname":"/functions/scenario-analysis/mahalanobis","siteSpaceId":"sitesp_R2F2u","description":"Compute the Mahalanobis Distance on your empirical data set.","breadcrumbs":[{"label":"Functions"},{"label":"Scenario Analysis"}]},{"id":"-MMuTvuKYaW5rLQAk2sX","title":"SCENARIOPR","pathname":"/functions/scenario-analysis/scenariopr","siteSpaceId":"sitesp_R2F2u","description":"Calculate relative scenario probabilities across a set of economic outcomes.","breadcrumbs":[{"label":"Functions"},{"label":"Scenario Analysis"}]},{"id":"bLM1AtCjmW1AoLsYgSWY","title":"IMPLIEDSCENARIO","pathname":"/functions/scenario-analysis/impliedscenario","siteSpaceId":"sitesp_R2F2u","description":"Calculate the implied scenario estimates that reconciles with your target scenario probabilities.","breadcrumbs":[{"label":"Functions"},{"label":"Scenario Analysis"}]},{"id":"-MPq2anrX-xwHd22lOUF","title":"Common Issues","pathname":"/faq/common-issues","siteSpaceId":"sitesp_R2F2u","description":"With great power comes great responsibility!","breadcrumbs":[{"label":"Frequently Asked Questions"}]},{"id":"-MQV4Rj6SgLXapFoC-AP","title":"FAQ","pathname":"/faq/faq","siteSpaceId":"sitesp_R2F2u","description":"You have questions, we have answers!","breadcrumbs":[{"label":"Frequently Asked Questions"}]}]}