Excel Lab
Knowledge base to support Excel Lab, a quantitative modeling library for asset allocation and factor analysis - a Windham Labs technology solution.
Watch the introduction to Excel Lab
Leverage linear optimization, numerical methods, matrix mathematics, and regression models within your Microsoft Excel environment. Quickly prototype quantitative models without leaving Microsoft Excel!
Access the power of the Windham Labs' quant models via Microsoft Excel.

What is Excel Lab?

Windham's Excel Lab is a Microsoft Excel add-in. It is a library of functions available for direct use within Microsoft Excel's workbooks to calculate and analyze complex mathematics and models used in asset allocation and risk management.
These sets of functions are not natively available in Microsoft Excel. Some examples include:
    Mean-variance optimization (and various other objective functions)
    First-passage time probability models
    Partial sample regression model
    Mahalanobis distance
    Multi-variate simulations

Why use Excel Lab?

Asset owners and buy-side analysts may find Excel Lab a valuable as part of their daily workflow.
    Centralize your workflow
    Save time and mitigate errors
      Focus on sourcing data and building analytics in one place
      Track your models in one workbook instead of relying on a string of tools that risks disconnecting your data states and models.
    Communicate your work in a clear and transparent workbook
    Extend your workbooks to natively include responsive and dynamic analytics

"With Excel Lab, I am able to have my data and models displayed in one place, prototype my research ideas within the same workbook, and communicate all of this in a format accessible to decision makers. This has greatly improved my research process and productivity."

Anonymous buy-side analyst
Last modified 1mo ago