Problem with qlBondYield2 Excel formula

[andrea.palermo]

Hi all,
we have a qlib installation in three workstations.
In two of them, a same Excel formula (qlBondYield2), with same data, give the right results, while for another workstation it gives wrong results:



The spreadsheet is shared: I mean, it's the same spreadsheet opened by the 3 users.

I tried to reinstall the qlib dll, unsuccessfully.

Can anyone help me?

Kind regards

Andrea

********************************************************************
Andrea Palermo
Financial Markets
mailto:[hidden email]

SoftSolutions!
Via S. Francesco d'Assisi, 3b, 24121 Bergamo (BG) Italia
Tel: [phone]
Mobile: [phone]
Fax: [phone]
http://www.softsolutions.it

********************************************************************

This document is strictly confidential and is intended for use by the addressee unless otherwise indicated. If you have received this e-mail in error we would be very grateful if you could please notify us immediately at mailto:[hidden email] and delete this e-mail from your system.

SoftSolutions! reserves the right to monitor all email communications through its internal and external networks.

Please don't print this e-mail unless you really need to.

SoftSolutions! s.r.l.

********************************************************************

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Eric Ehlers-2]

Hi Andrea,

> Hi all,
> we have a qlib installation in three workstations.

What version of QuantLibXL are you using?  Have you compiled it yourself
or are you using the binary installation?

> In two of them, a same Excel formula (qlBondYield2), with same data, give
> the right results, while for another workstation it gives wrong results:
>
> The spreadsheet is shared: I mean, it's the same spreadsheet opened by the
> 3 users.
>
> I tried to reinstall the qlib dll, unsuccessfully.
>
> Can anyone help me?

If the workbook dependencies are not set up correctly, maybe the sequence
of calculations is not controlled.  What happens if you hit Ctrl-Alt-F9 a
couple of times?

Does each environment return the same value for qlSettingsEvaluationDate()?

Is it just qlBondYield2() which behaves differently on the one machine, or
are there other intermediate calculations which return different results?
Try reducing the workbook to the smallest possible example which
reproduces the problem.

Try enabling logging and comparing the output in the log files.

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a
client to the Grid


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[andrea.palermo]

Hi Guys,
I noticed that the problem listed below (same qlBondYield2 formula giving a right value in a machine and a totally wrong value in another one) could be related to the different Excel versions.

- in Excel 2003 SP3 11.8169.8172 it doesn't work
- in Excel 2003 SP3 11.8237.8221 it works
- in Excel 2003 and Excel 2003 SP2 it works

Obviously, I cannot be sure that the problem is actually caused by the different Excel versions.

Do you have knowledge of this problem?

Thanks in advance

Andrea

----- Messaggio originale -----
Da: "andrea palermo" <[hidden email]>
A: [hidden email]
Cc: "support" <[hidden email]>
Inviato: Giovedì, 20 novembre 2008 11:53:32 GMT +01:00 Amsterdam/Berlino/Berna/Roma/Stoccolma/Vienna
Oggetto: Problem with qlBondYield2 Excel formula

Hi all,
we have a qlib installation in three workstations.
In two of them, a same Excel formula (qlBondYield2), with same data, give the right results, while for another workstation it gives wrong results:



The spreadsheet is shared: I mean, it's the same spreadsheet opened by the 3 users.

I tried to reinstall the qlib dll, unsuccessfully.

Can anyone help me?

Kind regards

Andrea

********************************************************************
Andrea Palermo
Financial Markets
mailto:[hidden email]

SoftSolutions!
Via S. Francesco d'Assisi, 3b, 24121 Bergamo (BG) Italia
Tel: [phone]
Mobile: [phone]
Fax: [phone]
http://www.softsolutions.it

********************************************************************

This document is strictly confidential and is intended for use by the addressee unless otherwise indicated. If you have received this e-mail in error we would be very grateful if you could please notify us immediately at mailto:[hidden email] and delete this e-mail from your system.

SoftSolutions! reserves the right to monitor all email communications through its internal and external networks.

Please don't print this e-mail unless you really need to.

SoftSolutions! s.r.l.

********************************************************************

--
********************************************************************
Andrea Palermo
Financial Markets
mailto:[hidden email]

SoftSolutions!
Via S. Francesco d'Assisi, 3b, 24121 Bergamo (BG) Italia
Tel: [phone]
Mobile: [phone]
Fax: [phone]
http://www.softsolutions.it

********************************************************************

This document is strictly confidential and is intended for use by the addressee unless otherwise indicated. If you have received this e-mail in error we would be very grateful if you could please notify us immediately at mailto:[hidden email] and delete this e-mail from your system.

SoftSolutions! reserves the right to monitor all email communications through its internal and external networks.

Please don't print this e-mail unless you really need to.

SoftSolutions! s.r.l.

********************************************************************

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users