MakeSchedule2

High level graphic of MakeSchedule2() function with parameters. Blue square node is the actual function with the parameters ordered.

1. Key parameter
   
   
   Key value to use as a handle for the created object
2. Reload parameter
   
   
   When creating this object for the first time, set this parameter to a positive value. Within Excel, when re-computing a worksheet where you do not wish to recreate the object, set this parameter to zero (0).
3. StartDate parameter
   
   
   Initial Start Date.
4. EndDate parameter
   
   
   Final End Date.
5. IndexKey parameter
   
   
   Index Key in order to acquire all the Schedule generation parameters.
6. stubDate parameter
   
   
   Setting this value a 0 (or an empty date) imply that the date generation routine will define a first odd and/or last odd coupon periods if needed (based on the dates passed to the 'StartDate' and 'EndDate' parameters and the value of the 'startFromEnd' parameter). If you want to define a last odd coupon period set this parameter to the date of the last coupon prior to 'EndDate' parameter and set the 'startFromEnd' parameter to true. Dates will then roll backwards from this stub date. During this calculation you may also have an odd first period if the 'StartDate' does not fall on a full coupon period from this stub date. If you want to define a first odd coupon, set this parameter to the date of the first coupon after the 'StartDate' and set the 'startFromEnd' parameter to false. Dates will
   then roll forwards from this stub date. During this calculation you may also have an odd last period if the 'EndDate' does not fall on a full coupon period from this stub date. If you have a last odd coupon period but wish to merge this with the pervious, full, coupon period, set the 'longFinal' parameter to true.
7. startFromEnd parameter
   
   
   Setting this parameter to 'false' imply that date generation will start from the StartDate and then add whole coupon periods until the EndDate is reached. Setting this parameter to 'true' imply that date generation will start from the EndDate and roll backwards in time (by whole coupon periods) until the StartDate is reached.
8. longFinal parameter
   
   
   If during coupon date generation, there is a last odd coupon period but you wish to merge this with the pervious, full, coupon period, set the 'longFinal' parameter to true.

String CTCalendars.MakeSchedule2( _
String Key, _
Long Reload, _
Long StartDate, _
Long EndDate, _
String IndexKey, _
Long stubDate, _
Boolean startFromEnd, _
Boolean longFinal)

=CT.SCH.MakeSchedule2(
Excel String Cell Key,
Excel Numeric Cell Reload,
Excel Numeric Cell StartDate,
Excel Numeric Cell EndDate,
Excel String Cell IndexKey,
Excel Numeric Cell stubDate,
Excel Boolean Value Cell startFromEnd,
Excel Boolean Value Cell longFinal)

static std::string MakeSchedule2(
std::string Key,
long Reload,
long StartDate,
long EndDate,
std::string IndexKey,
long stubDate,
bool startFromEnd,
bool longFinal);

System.String CTCalendarsSA.MakeSchedule2(
System.String Key,
System.Int32 Reload,
System.Int32 StartDate,
System.Int32 EndDate,
System.String IndexKey,
System.Int32 stubDate,
System.Boolean startFromEnd,
System.Boolean longFinal);

• ValueDateObj() ( CT.QL.Utils20 )
• CALUKExchange() ( CT.QL.Curves20 )
• CALEURO() ( CT.QL.Curves20 )
• CreateDepoTemplate() ( CT.QL.Curves20 )
• CreateSwapTemplate() ( CT.QL.Curves20 )
• MKTYC_D() ( CT.QL.Curves20 )
• IDXEuribor() ( CT.QL.Curves20 )
• MakeSchedule2() ( CT.QL.Curves20 )

• Example VB.NET Driver function. Preparing the parameters and the final function call (the result).
• Example C# Driver function. Preparing the parameters, sub-function calls and the final function call (the result).
• Example C++.NET Driver function. Preparing the parameters and the final function call (the result).
• Example J# Driver function. Preparing the parameters and the final function call (the result).

• Example Visual Basic 6 Driver function. Preparing the parameters and the final function call (the result).
• Example Excel VBA Driver function. Preparing the parameters and the final function call (the result).
• Example C++ Driver function. Preparing the parameters and the final function call (the result).
• Example Java Driver function. Preparing the parameters and the final function call (the result).