I don't think there is a formula per se but rather a method of calculating. Here are the steps (anyone can create them as long as one understands the concept of ES and I assume that your 2000 observations are daily $P&L):
1. Order the losses from greatest to least (most profit).
2. Take the top 10% for 90% CI ES, which corresponds to the top 200 simulations of $P&L.
3. Take the average of these 200 simulations and that gives you the 1-day ES.
4. I am not exactly sure of this (but this can be applied to VaR), but you can scale the horizon of your 1-day ES by multiplying your 1-day ES value by the root of 21 to get your 21-day ES.
5. You can repeat steps 2 to 4 for 95% and 99% CI.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.