Enron email

Algorithmic Indexing

7 Mar 2001, 08:32 UTC

Re: "Expected Tail Loss" for Equity portfolio

From
Tanya Tamarchenko tanya.tamarchenko@enron.com
To
isaac.rodriguez@enron.com, Jason Sokolov, Rabi De, Jaesoo Lew
Cc
Vince J Kaminski
Bcc
Vince J Kaminski
Date
Wed, 7 Mar 2001 00:32:00 -0800 (PST)
Everybody,

I attached here the Equity Portfolio VAR spreadsheet model (Version X).
The improvement over the previous version (1X) is that it calculates
an additional measure of risk - Expected Tail Loss.  

Expected Tail Loss is the expectation of the loss under the condition that
losses exceed VAR . As you know Equity VAR model allows you to calculate VAR
for the percentile specified in the input sheet.

Now you have to click 2 more buttons on the "VarInput" sheet:
"Calculate Gamma and Delta" and "Fast VAR".

Isaac, please run the model to make sure it works for you.

Regards,

Tanya