28 Dec 2000, 10:30 UTC
Seasonal factors and curve fitting
- From
- Alex Huang alex.huang@enron.com
- To
- Vince J Kaminski, Vasant Shanbhogue, Stinson Gibner, Zimin Lu, Tanya Tamarchenko, Amitava Dhar, Kevin Kindall, Naveen Andrews
- Cc
- Alex Huang
- Bcc
- Alex Huang
- Date
- Thu, 28 Dec 2000 02:30:00 -0800 (PST)
I have written a C++ code to do the following: For a given curve, the code will filter out the seasonal factor. It then fits the deseasoned curve to a smooth function of the form f(t)=a+A/(t+B)c, with 0<c<.5. ?The curve fitting is achieved by using Conjugate Gradient method. ??As Tanya pointed out, this form of function ensures that ?f(t)2*t - f(t-1)2*(t-1) >0, which is useful in calculating forward-forward ?vol. ?The outputs are season patterns (2 different patterns are allowed)?and the smoothed curve. One can then calculate forward-forward vol?from the smoothed curve and superimpose the seasonal factors back?onto the curve.??This procedure is not useful for VaR calcuation. However, I believe it ?is useful for other situations which require the knowledge of seasonal ?forward-forward vols. For example, in power plant valuation and?credit exposure simulations, it would reflect the reality more closely?if we add seasonality to our forward-forward vol in simulating the forward?prices. ??Attached are the spreadsheet and XLL file. I will forward the C code if?any of you is interested. ??Alex??