Message-ID: <27236164.1075840579267.JavaMail.evans@thyme> Date: Thu, 10 May 2001 11:36:00 -0700 (PDT) From: kenneth.parkhill@enron.com To: john.griffith@enron.com Subject: updated skew file Cc: paulo.issler@enron.com, tom.barkley@enron.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bcc: paulo.issler@enron.com, tom.barkley@enron.com X-From: Kenneth Parkhill X-To: John Griffith X-cc: Paulo Issler , Tom Barkley X-bcc: X-Folder: \ExMerge - Griffith, John\Market X-Origin: GRIFFITH-J X-FileName: john griffith 6-25-02.PST John, This is the latest skew calculator file. It has a sheet for the vol skew table, and it calculates the ENA pdf using a linear interpolation between points on the table, not a polynomial. The file shows yesterday's settle data for Jun, and ENA data matches very well. (All the 2001 contracts agree closely with ENA data from yesterday, in fact.) I've added a macro that fetches the underlying price, volatility, and interest rate from our in-house EGSPROD32 database. Let me know if this doesn't work for you. Feel free to contact any of us if you have any questions or requests regarding this file. hope it is helpful. ken