Extreme Value Theory in Risk Management

Multiple packages are available in R for extreme value analysis.If you are looking at extreme value theory in regards to stock prices there is full implementation of libraries in the rMetrics team's fExtremes library in the R statistical script language. This and others are covered in the book on R for finance by Gilleland, Ribatet, and Stephenson (2013). In chapter 8 of Introduction to Quantitative Finance by PACKT publishing, they present the evir package, and a complete working example of cash shortfall. Bernard Pfaff's Book Financial Risk Modeling and Portfolio Optimization in R covers the topic in depth also.

To answer part 1: For my MFE capstone project on EVT on interest rate swaps I used Practical Methods of Financial Engineering and Risk Management: Tools for Modern Financial Professionals by Rupak Chatterjee (my advisor). Chapter 8 gives a good step by step intro to Power Laws and EVT. It also includes some quick Excel demos.

EVT has pluses and minuses, but (under certain conditions) provides the best estimate of extreme quantile returns in a portfolio given the data available. Probably the simplest and easiest way to do this is to use the peak over threshold method and fit the Generalized Pareto Distribution (GPD). The GPD is very convenient for calculating VaR and ES. A good reference by an expert is this paper by McNeil. You should make sure to estimate the standard error around your estimate so that you know how reliable the result is.

In terms of a long/short portfolio of stock options, you should check whether the option strikes are such that the options are likely to have a material amount of gamma when your portfolio experiences very large moves. For example, if we only had a single stock option in the portfolio and the 99.9th percentile portfolio return happens just when the stock option starts to get in the money, it is likely that EVT will struggle to give a good estimate due to the option nonlinearity (the EVT doesn't get to know which instruments are in your portfolio, only the portfolio returns). But if the options are struck reasonably close to the money, then they will likely act in a linear way when the large returns from the time series are applied to them.

You can probably code something in Excel, but R has a lot of useful packages for EVT - I recommend RStudio (free) as an interface to R.