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
  • Description
  • Syntax
  • Input(s)
  • Output(s)
  • Example
  1. Functions
  2. General

XLABINFO

Retrieve information about the Excel Lab quant library installed on your workstation.

Description

Review information about Windham's quant library installed on your workstation. You can use this to obtain version information and general information for support.

Invoking this function initializes the computation engine just like any other Excel Lab feature.

This function can also be used to test whether the add-in is initializing successfully.

Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

=XLABINFO(showDialog)

Input(s)

Argument

Description

showDialog

Optional. Logical to specify the display of a graphical dialog presenting information on the Excel Lab quant library installed, if FALSE the function will return text information into the corresponding Excel cell. If the argument is not specified, it defaults to TRUE.

Output(s)

Information on the product, version number, resource addresses, etc.

Example

PreviousXLABHELPNextXLABLICENSE

Last updated 3 years ago

=XLABINFO() in the formula bar