Re: QuantlibXL - qlSchedule Issue

Posted by Luigi Ballabio on
URL: http://quantlib.414.s1.nabble.com/QuantlibXL-qlSchedule-Issue-tp8620p8621.html

Hi Simone,
    from your output, I'd say that the schedule constructor first
generates all dates with the given frequency, adjusts them using the
Preceding convention (which moves Saturday and Sunday to Friday) but
doesn't check for duplicates.  You're probably the first to try
building a daily schedule, so the problem never surfaced before...

I'd say it's a bug.  How do you think this should work? Should we just
remove the duplicates?

Luigi


On Tue, Dec 6, 2011 at 4:54 PM, Simone <[hidden email]> wrote:

>
> Hi,
> I'm experiencing a behavior of the qlSchedule function I cannot say whether it's a bug or not.
>
> The excel formula { =qlScheduleDates(qlSchedule(;today();"7d";"1d";"Italy::Exchange";"Preceding")) } produces the following list of dates:
>
> tue 06/12/2011
> wed 07/12/2011
> thu 08/12/2011
> fri 09/12/2011
> fri 09/12/2011
> fri 09/12/2011
> mon 12/12/2011
> tue 13/12/2011
>
>
> so there are three Fridays rather than just one.
>
> Not sure why this happens: could it be that the qlSchedule function outputs the two extra Fridays to fill the Saturday and the Sunday that a calendar including holidays should dump instead?
>
> Regards,
>
> --
>
> Simone

------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users