MLERETURNS

Estimate expected returns for assets with incomplete historical data (unequal lengths) with a maximum likelihood estimator.

Description

In an ideal world, analysts would have access to complete and clean data. In practice, the amount of historical time series data across asset classes differs. A common workaround is to discard observations that are incomplete across the panel, or to restrict the analysis with assets that have common histories. This forgoes the potential information embedded within asset classes with shorter or incomplete histories.

We can employ a Maximum Likelihood Estimation (MLE) method to use all available data to solve for parameters (means or covariances) that is most likely to have produced the observations.

Syntax

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

=MLERETURNS(assetReturns, dataPeriodicity)

Input(s)

Microsoft Excel defaults to marshalling empty cells as zeros in the background. Therefore, please explicitly specify missing values within your worksheet using $=\text{NA()}$in your formula bar for the relevant cells.

Argument	Description
assetReturns	Required. Time series or matrix of asset returns.
dataPeriodicity	Optional. Periodicity of the data, used for annualization. If you do not enter the argument, it defaults to 1. e.g. Daily = 255, Monthly = 12, Yearly = 1, Quarterly = 4.

Output(s)

Row vector of MLE expected returns.

Example

55KB

MLERETURNS.xlsx

Open

Example Workbook: MLERETURNS