Efficient frontier from a covariance matrix · Calculation guide

Find the least-volatile portfolio meeting your minimum expected return.

Calculation guide

Enter 2–12 assets and each covariance pair once. A volatility of 10% has variance 100 in squared percentage points. Use a positive-definite annual matrix. Weights sum to 100%; short positions are allowed. A target below the minimum-variance return selects the global minimum. Change the target to trace the efficient frontier.

Minimize wᵀΣw subject to Σwᵢ = 1 and wᵀμ ≥ target.

Inputs

Minimum expected annual return (%)

Example entry 8.

Expected annual return (%)

Example entry 5. Allowed range -100 to 10000.

First asset number

Example entry 1. Allowed range 1 to 12. Use whole numbers.

Second asset number

Example entry 1. Allowed range 1 to 12. Use whole numbers.

Covariance in percentage-points squared

Example entry 100. Allowed range -100000000.0 to 100000000.0.

Worked example

InputValue
Minimum expected annual return (%)8

Assets in numbered order

Expected annual return (%)
5
10

Annual covariance matrix entries (one row per unordered pair)

First asset numberSecond asset numberCovariance in percentage-points squared
11100
120
22400
ResultValue
Annual portfolio volatility12.649111%
Expected annual return8%
Return at global minimum variance6%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Minimum expected annual return (%)89Annual portfolio volatility12.649111%16.124515%
Expected annual return (%) (row 1)56Annual portfolio volatility12.649111%11.18034%
Covariance in percentage-points squared (row 1)100110Annual portfolio volatility12.649111%12.712199%
Efficient frontier from a covariance matrix →

Sources