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. Short positions are allowed. Forecast returns describe the solution and do not affect the minimum-variance weights.
w = Σ⁻¹1 / (1ᵀΣ⁻¹1).
Inputs
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
Assets in numbered order
| Expected annual return (%) |
|---|
| 5 |
| 10 |
Annual covariance matrix entries (one row per unordered pair)
| First asset number | Second asset number | Covariance in percentage-points squared |
|---|---|---|
| 1 | 1 | 100 |
| 1 | 2 | 0 |
| 2 | 2 | 400 |
| Result | Value |
|---|---|
| Annual portfolio volatility | 8.944272% |
| Expected annual return | 6% |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Expected annual return (%) (row 1) | 5 | 6 | Expected annual return | 6% | 6.8% |
| Covariance in percentage-points squared (row 1) | 100 | 110 | Annual portfolio volatility | 8.944272% | 9.288407% |
