GSwap_ParRate_Simple1() function

GSwap_ParRate_Simple1(argument list…)

This is a special version of the earlier GSwap_ParRate_Simple function, which takes an ARRAY of swap terms in months (with all other arguments common), and returns an array of par swap rates. It must be entered as an array formula (see Excel online help). This function will be faster when calculating tables of swap rates, compared to calling the earlier version of the function multiple times. The function uses the following arguments:

 Argument Description Restrictions Valuation_Date valuation date (e.g. today) valid Excel date number Swap_Start_Date start date of swap valid Excel date number >= Valuation_Date TIM_Array an array of the term of the swaps in months > 0 Freq number of fixed-side payments per annum 1, 2, 4, or 12 DCB day count basis 0 = 30/360 1 = act/360 2 = act/365 (fixed) 3 = Frequency based (for BONDS), equal coupons 360 = act/360 365 = act/365 (fixed) (if none of the above, the function defaults to frequency based) Date_Conv business date convention 0 = no adjustment 1 = Following business day 2 = Modified following 3 = Previous Holidays array of holiday dates valid Excel date numbers strictly ascending order Swap_Curve_Type defines how the Swap_Z_Rates array is to be interpreted 0 = continuously compounded riskless rates in, decimal form 1 = discount factors (first must be 1.0, and must be declining) Swap_Interp the interpolation method to employ for the Swap_Z_Rates array 0 = cubic-spline 1 = linear 2 = log-linear Swap_Z_Dates array of zero coupon curve dates strictly ascending order The first date of this array must be Valuation_Date Swap_Z_Rates an array of zero rates or discount factors corresponding to Swap_Z_Dates

© 1995-98 Leap of Faith Research Inc.