Portfolio historical value at risk · Calculation guide

Find the empirical historical loss quantile at a chosen confidence level.

Calculation guide

Use equally weighted returns at the desired risk horizon. Convert returns to losses (positive means loss). A negative estimate indicates gains even at this tail level. Sort losses ascending and take rank ceiling(confidence × sample size), without interpolation.

VaR = loss at rank ceil(c × N) in ascending order.

Inputs

Current portfolio value

Example entry 100000 (in the selected currency).

Confidence level

Example entry 75 %. Allowed range 0 to 100.

Portfolio return (%)

Example entry -10. Allowed range -100 to 10000.

Worked example

InputValue
Current portfolio value100,000
Confidence level75%

Consecutive period returns

Portfolio return (%)
-10
-5
0
4
ResultValue
Tail loss in currency units5,000
Tail loss as percentage of value5%
Historical observations4

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Current portfolio value100,000110,000Tail loss in currency units5,0005,500
Confidence level75%83%Tail loss in currency units5,00010,000
Portfolio return (%) (row 1)-100Tail loss in currency units5,0000
Portfolio historical value at risk →

Sources