Excel Lab
  • Excel Lab
  • Release Notes
  • Getting Started
    • Installing Excel Lab
      • Step 1: Download Files
      • Step 2: Register Libraries
      • Step 3: Activate Add-in
      • Step 4: Verify Installation
  • Functions
    • General
      • ISMATRIXPSD
      • MATRIX
      • XLABHELP
      • XLABINFO
      • XLABLICENSE
      • RESETPASSWORD
    • Return Models
      • CAPM
      • DESMOOTHRETURNS
      • IMPLIEDRETURNS
      • MLERETURNS
    • Risk Models
      • ANNUALIZERISK
      • EWMA
      • HISTORICALRISK
      • MLERISK
      • PORTFOLIORISK
      • TURBULENTRISK
      • QUIETRISK
    • Optimization
      • MVO
      • MTO
      • MVT
      • MVFRONTIER
      • MTFRONTIER
      • ISORETURN
    • Simulation
      • MCNORM
      • BOOTSTRAP
    • Exposure to Loss
      • LOSSPR
      • OMEGARATIO
      • SORTINORATIO
      • TAILRATIO
      • VALUEATRISK
      • MAXDD
    • Regression Analysis
      • FACTORANALYSIS
      • PSR
    • Scenario Analysis
      • MAHALANOBIS
      • SCENARIOPR
      • IMPLIEDSCENARIO
  • Frequently Asked Questions
    • Common Issues
    • FAQ
  • Further Reading
  • Windham's Research Insights
  • Watch Our Educational Videos
Powered by GitBook
On this page
  • System Requirements
  • Setting Up Excel Lab
  1. Getting Started

Installing Excel Lab

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.

PreviousRelease NotesNextStep 1: Download Files

Last updated 2 years ago

System Requirements

Minimum
Recommended

Microsoft Windows 7

Microsoft Windows 10

Any Intel or AMD x86 - 64 processor

Intel x64 processor with more than two logical cores

8GB of HDD space

8GB SSD space

1GB RAM

8GB or more

Microsoft Excel 2019 or later

Older versions of Microsoft Excel are not officially supported by the Windham Labs team. We highly recommend Microsoft Excel 365 with dynamic arrays.

Setting Up Excel Lab

Windham's Excel Lab is powered by a combination of complex technologies to enable powerful calculators and analytics. It will be helpful to enlist your IT team/administrator for help when installing the tool.

There are 4 steps that are important to follow for a successful installation.

Microsoft Excel 365 (with enabled)

Step 1: Download Files
Step 2: Register Libraries
Step 3: Activate Add-in
Step 4: Verify Installation
dynamic arrays