Posted by
Ballabio Gerardo-4 on
URL: http://quantlib.414.s1.nabble.com/QuantLibXL-date-serial-number-error-in-Bonds-xls-qlFloatingRateBond-stand-alone-example-tp14509p14518.html
I got the same error since QuantLibXL 1.2. It used to work in version 1.1.
I suppose it's a regression in QuantLibXL code. Some time ago I made an attempt to fix it, but wasn't able to find the offending change. I intend to retry, but I don't know when I'll find the time.
Gerardo
-----Messaggio originale-----
Da: Lisa Ann [mailto:
[hidden email]]
Inviato: giovedì 5 settembre 2013 11.24
A:
[hidden email]
Oggetto: [Quantlib-users] QuantLibXL: date serial number error in Bonds.xls qlFloatingRateBond() stand alone example
If you have * <
http://quantlib.org/quantlibxl/> QuantLibXL* , please open the stand alone example workbook called *Bonds.xls* located in *...\QuantLibXL-1.2.0\Workbooks\StandaloneExamples*.
Go to *Bonds *spreadsheet.
I would like to know if the cell /H14/, whose content is the
*qlFloatingRateBond()* function with its arguments, does return you an error due to
*qlFloatingRateBond - Date's serial number (366) outside allowed range [367-109574], i.e. [January 1st, 1901-December 31st, 2199]*
If so, could you explain me what it depends on and how may I solve it?
--
View this message in context:
http://quantlib.10058.n7.nabble.com/QuantLibXL-date-serial-number-error-in-Bonds-xls-qlFloatingRateBond-stand-alone-example-tp14509.htmlSent from the quantlib-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT 2. Standardize and globalize service processes across IT 3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head></head>
<body>
<div style="font-family:Calibri;font-size:10px">
Banca Profilo S.p.A.
Via Cerva, 28 - 20122 Milano - Tel. 02 58408.1, Fax 02 5831 6057
Capitale Sociale Euro 136.794.106,00 i.v.
Iscrizione al Registro Imprese di Milano, C.F. e P.IVA 09108700155 -
[hidden email]
Iscritta all’Albo delle Banche e dei Gruppi bancari
Aderente al Fondo Interbancario di Tutela dei depositi
Aderente al Conciliatore Bancario Finanziario e all’Arbitro Bancario Finanziario
Appartenente al Gruppo bancario Banca Profilo e soggetta all’attività di direzione e coordinamento di Arepo BP S.p.A.
DISCLAIMER:
The information transmitted may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient is prohibited.
If you received this in error, please contact the sender and delete the material from any computer.
</div>
</body>
</html>
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users