MTO
Mean-tracking-error optimization, maximize your return in excess of a benchmark while minimizing tracking-error.
Last updated
Mean-tracking-error optimization, maximize your return in excess of a benchmark while minimizing tracking-error.
Last updated
Maximize expected returns relative to a benchmark and minimize expected tracking-error. Solve for the mean-tracking-error optimal portfolio (MTO). This is a quadratic programming optimizer in active space. The function allow you to specify both linear and non-linear constraints and is able to account for friction penalties such as transaction costs across assets.
The following describes the function signature for use in Microsoft Excel's formula bar.
Argument | Description |
---|---|
The output matrix follows the vector orientation of mu (column / row). If you have specified your inputs as column-vectors, the corresponding output matrix will be transpose of the above.
The function returns a vector of optimal weights across assets and appends the corresponding optimization's exit flag.
exitFlag | Description |
---|---|
mu
Required. Vector of expected returns.
sigma
Required. Vector of expected risk.
rho
Required. Correlation matrix.
aversion
Optional. Scalar value for tracking aversion. If the argument is not specified, it defaults to 1.
wBenchmark
Optional. Vector of benchmark weights. This is used to evaluate the utility function in excess return space. If not specified, the function assumes a vector of zeros.
wInitial
Optional. Vector of initial weights (or your current weights). This is used to measure the friction penalties when solving for an optimal transition. If not specified, the function assumes a vector of zeros.
tc
Optional. Vector of transaction costs. If the argument is not specified, it defaults to a vector of zeros.
lb
Optional. Vector of lower bound limits. If the argument is not specified, it defaults to a vector of zeros.
ub
Optional. Vector of upper bound limits. If the argument is not specified, it defaults to a vector of ones.
constraints
Optional. Matrix of constraints, operator enumeration, and values:
The operator enumeration is represented by
If the argument is not specified, it will default to a fully-funded constraint. i.e.
nonlincons
Optional. Matrix to specify nonlinear constraint enumeration, operator enumeration, and values:
The nonlinType enumeration is
-2
No feasible solution found. Check your constraints and problem definition.
-1
Unexpected interruption.
0
Number of iterations exceeded.
1
First-order optimality measure is less than tolerance threshold and the constraints were satisfied.
2
Delta in optimal weights is less than the configured numerical step size.
3
Change in the expected utility value is less than the tolerance threshold.
4
Magnitude of search direction was less than the configured threshold.
5
Magnitude of directional derivative in the search direction was less than the configured threshold.