Expected shortfall from a return series · Calculation guide

Estimate average loss across the worst historical probability mass.

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. Average the worst (1 − confidence) fraction of observations, including fractional weight on the boundary observation.

Average the largest N(1−c) losses, weighting the final observation fractionally.

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 units10,000
Tail loss as percentage of value10%
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 units10,00011,000
Confidence level75%67%Tail loss in currency units10,0008,787.878788
Portfolio return (%) (row 1)-10-9Tail loss in currency units10,0009,000
Expected shortfall from a return series →

Sources