Portfolio Parameters
$
%
Set 0 for conservative estimate
%
Ann. vol ÷ √252
days
%
Auto-fills daily σ
Confidence Levels
1-Day VaR (95% Confidence)
5% probability of losing more than this amount in one day
Daily Volatility
1σ Daily Range
10-Day VaR (95%)
Annual VaR (95%)
Normal Distribution — Return Distribution & VaR Thresholds

What each tab calculates

01

Parametric VaR

Calculates VaR and CVaR using the normal distribution with portfolio value, daily return and daily volatility. Scales to any holding period via the square-root-of-time rule. Shows a VaR table at 90%, 95%, 99% and 99.5% confidence with a normal distribution chart and VaR threshold markers.

02

Historical VaR

Computes VaR directly from a user-entered return series using empirical percentiles — no distributional assumption required. Supports equal weighting and exponential decay (EWMA with λ=0.94). Shows a histogram of the actual return distribution with VaR markers.

03

Monte Carlo VaR

Runs up to 10,000 simulated scenarios from the input distribution parameters with an optional fat-tail multiplier for t-distribution approximation. Computes VaR and CVaR from the simulation results and compares against the equivalent parametric estimate.

04

Multi-Asset VaR

Calculates portfolio VaR from the full covariance matrix across up to 6 assets using individual weights, daily volatilities, and pairwise correlation coefficients. Shows diversification benefit versus the weighted average standalone VaR and a VaR contribution bar chart.

05

Backtesting

Tests VaR model accuracy by comparing predicted VaR against actual realized returns. Counts breaches, calculates the breach rate, and applies the Kupiec likelihood ratio test. Classifies the model under the Basel III traffic light system (Green / Amber / Red zone) with a breach timeline chart.