Error in qlCalendarBusinessDaysBetween

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Error in qlCalendarBusinessDaysBetween

MikeD
Hello,

I noticed this error in the function qlCalendarBusinessDaysBetween.  It seems as if QL is not recognizing the booleans for the "include first" and "include last" properly.  See attached spreadsheet.  Notice how all the outputs are 6, although they should be 6,5,5,4 respectively.

Does anyone know why this is happening?

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

qlCalendarBusinessDaysBetween.xlsm (11K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Error in qlCalendarBusinessDaysBetween

Luigi Ballabio
On Tue, 2011-09-06 at 11:43 -0500, Mike DelMedico wrote:
> I noticed this error in the function qlCalendarBusinessDaysBetween.
> It seems as if QL is not recognizing the booleans for the "include
> first" and "include last" properly.  See attached spreadsheet.  Notice
> how all the outputs are 6, although they should be 6,5,5,4
> respectively.
>
> Does anyone know why this is happening?

It works correctly from C++ or the Python wrappers.  A problem in the
Excel layer, maybe?  Eric, any insight?

Luigi


--

Every solution breeds new problems.
-- unknown



------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users