Menu
▾
▴
quantlib-dev
|
From: Ferdinando A. <na...@am...> - 2005-02-09 19:55:22
|
Hi Adjriou >In my laptop , the xll works fine because I have Visual C++, but in my >desk, I just have Excel and >and when I open the xll, i Have a message error. which error message. what is you xll? is it QuantLibXL? >What libraries do I need to make it run without Visual C++ ? the error message might be telling you that. ciao -- nando |
|
From: eric e. <eri...@gm...> - 2005-02-09 22:41:43
|
> In my laptop , the xll works fine because I have Visual C++, but in my desk, > I just have Excel and > and when I open the xll, i Have a message error. > What libraries do I need to make it run without Visual C++ ? In the simplest case an xll has no external dependencies - you start Excel, load the xll, and away you go. If your xll stops working when you install it on a non-development machine, I'd suspect one of two problems 1) you've compiled the xll in such a way as to create a run-time dependency. For example, you linked the xll to some lib such that the xll depends on the corresponding dll at runtime 2) There's some other difference between your dev box and the box you installed to - for example different versions of Excel - xlls can be flaky about different versions of Excel and not all of the differences are documented, debugging is the only way. Regards Eric |
|
From: JOSHI, M. G. R. M. <Mar...@rb...> - 2005-02-10 10:07:15
|
We've come across this problem with xlls built under visual C++ .net . There are a couple of dlls that the xll requires and returns a library not recognized error if you don't have them.=20 =20 the relevant ones may be mscvp70.dll mscvi70.dll msvcr70.dll =20 regards Mark =20 -----Original Message----- From: qua...@li... [mailto:qua...@li...] On Behalf Of Adjriou Belak Sent: 09 February 2005 15:02 To: qua...@li...; qua...@li... Subject: [Quantlib-users] what do I need to make run an xll ? Hi, =20 In my laptop , the xll works fine because I have Visual C++, but in my desk, I just have Excel and=20 and when I open the xll, i Have a message error. What libraries do I need to make it run without Visual C++ ? =20 regards thanks for your help. _____ =20 D=E9couvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! Cr=E9ez <http://fr.rd.yahoo.com/mail/taglines/*http://fr.rd.yahoo.com/evt=3D25917/*= htt p://fr.rd.yahoo.com/mail_fr/mail_campaigns/splash/taglines_250/default/*http ://fr.promotions.yahoo.com/mail/creer28.html> votre Yahoo! Mail ***************************************************************************= ******** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registere= d Office: 36 St Andrew Square, Edinburgh EH2 2YB. = =20 Authorised and regulated by the Financial Services Authority =20 =20 This e-mail message is confidential and for use by the = addressee only. If the message is received by anyone other =20 than the addressee, please return the message to the sender =20 by replying to it and then delete the message from your = computer. Internet e-mails are not necessarily secure. The = Royal Bank of Scotland plc does not accept responsibility for =20 changes made to this message after it was sent. = =20 = =20 Whilst all reasonable care has been taken to avoid the =20 transmission of viruses, it is the responsibility of the recipient to = =20 ensure that the onward transmission, opening or use of this =20 message and any attachments will not adversely affect its =20 systems or data. No responsibility is accepted by The Royal =20 Bank of Scotland plc in this regard and the recipient should carry =20 out such virus and other checks as it considers appropriate. =20 = Visit our websites at: = =20 http://www.rbs.co.uk/CBFM = =20 http://www.rbsmarkets.com = =20 = ***********************************************= ********************************* |
|
From: Luigi B. <lui...@gm...> - 2005-02-11 08:45:55
|
On 02/10/05 10:20:51, JOSHI, Mark, Group Risk Mgmt wrote:
> We've come across this problem with xlls built under visual C++ .net .
> There are a couple of dlls that the xll requires and returns
> a library not recognized error if you don't have them.
Mark,
did you download the xll binaries, or did you build it yourself?
In the latter case, you might want to try changing some compilation =20
settings. I don't have .NET, but there should be a project setting (on VC6 =
=20
it used to be under 'C++/Code generation') letting you choose the run-time =
=20
library to use. You should have the alternative between depending on DLLs =20
or linking the run-time library statically.
Hope this helps,
Luigi
----------------------------------------
Weiler's Law:
Nothing is impossible for the man who doesn't have to
do it himself.
|
|
From: Daniele De F. <Dan...@br...> - 2005-02-10 13:28:33
|
I have had this kind of problems in a lot of situations, and then I found a tool that just shows you all the dependencies of a dll so that you quickly find out what you're missing. http://www.dependencywalker.com/ It's free and it works. :-) My guess is that you have a run-time dependency on a version of the C or C++ runtime library which versions are different on the two machines. But this is just speculation: start the dependency walker and you'll know exactly.. :-) -Daniele -----Original Message----- From: eric ehlers [mailto:eri...@gm...] Sent: Wednesday, February 09, 2005 5:41 PM To: Adjriou Belak Cc: qua...@li...; qua...@li... Subject: Re: [Quantlib-users] what do I need to make run an xll ? > In my laptop , the xll works fine because I have Visual C++, but in my > desk, I just have Excel and and when I open the xll, i Have a message > error. What libraries do I need to make it run without Visual C++ ? In the simplest case an xll has no external dependencies - you start Excel, load the xll, and away you go. If your xll stops working when you install it on a non-development machine, I'd suspect one of two problems 1) you've compiled the xll in such a way as to create a run-time dependency. For example, you linked the xll to some lib such that the xll depends on the corresponding dll at runtime 2) There's some other difference between your dev box and the box you installed to - for example different versions of Excel - xlls can be flaky about different versions of Excel and not all of the differences are documented, debugging is the only way. Regards Eric |
|
From: Marco M. <mar...@st...> - 2005-12-23 15:51:19
|
Hi,
I've used QuantLibAddin to build a couple of spreadsheet for training
purposes.
I've added a handful of functions:
+ a function qlXiborFixing to retrieve the fixing of an index
+ two functions qlRateHelperImpliedQuote, qlRateHelperQuoteError to
retrieve the implied quote and the error of a rate helper
+ a constructor qlForwardSpreadedTermStructure to build a curve with a
given spread
+ a constructor qlForwardCurve for a piecewise-constant forward curve
starting from
the given forward rates
Should I commit these additions?
Also, I would like to use the advance method of calendars and the
yearFraction method
of day counters. Is it possible, in the framework of QuantLibAddin, to use
these
as functions without having to export the Calendar/Day counter constructor?
If so, how do you do that?
Marco
Marco Marchioro
StatPro Italia
Phone: +39 02 4331 7497
Fax: +39 02 4391 1424
www.StatPro.com
|
|
From: eric e. <eri...@gm...> - 2005-12-23 19:28:01
|
Hi Marco, > I've used QuantLibAddin to build a couple of spreadsheet for training > purposes. > I've added a handful of functions: Fantastic. > Should I commit these additions? That would be much appreciated. I've just completed a large batch of enhancements to the srcgen script so unfortunately your code will probably need some updates to bring it in line with CVS. > of day counters. Is it possible, in the framework of QuantLibAddin, to us= e > these > as functions without having to export the Calendar/Day counter constructo= r? > If so, how do you do that? In a metadata file having headerOnly=3D'true' you define your functions with class Procedure. Then somewhere under qla you implement a wrapper for the QuantLib function. For examples of this please see srcgen/utilities.xml qla/utilites.cpp Regards, Eric |
|
From: Lars S. <sch...@ya...> - 2005-12-29 00:39:35
|
The add-in source code need to handle the xlAutoClose callback. added to the bug reporting tool http://sourceforge.net/tracker/index.php?func=detail&aid=1392393&group_id=12740&atid=112740 Regards Lars --------------------------------- Yahoo! for Good - Make a difference this year. |
|
From: eric e. <eri...@gm...> - 2005-12-29 09:44:51
|
Hi Lars, > The add-in source code need to handle the xlAutoClose > callback. In theory you would implement the xlAutoClose function and there call xlfUnregister for each of an XLL's functions. However xlfUnregister is broken so in practice Excel provides no mechanism to unregister functions. The only reason to implement xlAutoClose would be if there were other resources that needed to be released which is not the case for QuantLibAddin. Regards, Eric |
|
From: Marco M. <mar...@st...> - 2006-01-11 15:41:46
|
Hi,
I finished the development of the few additional functions under QuantLibAddin.
I've modified the dsp for Visual Studio 6 and the makefiles.
I've added a new category "basic" with the function necessary to advance
a calendar and to compute an year fraction.
I'll commit the code and wait for comments.
Ciao,
Marco
At 08:27 PM 2005-12-23, eric ehlers wrote:
>Hi Marco,
>
> > I've used QuantLibAddin to build a couple of spreadsheet for training
> > purposes.
> > I've added a handful of functions:
>
>Fantastic.
>
> > Should I commit these additions?
>
>That would be much appreciated. I've just completed a large batch of
>enhancements to the srcgen script so unfortunately your code will
>probably need some updates to bring it in line with CVS.
>
> > of day counters. Is it possible, in the framework of QuantLibAddin, to use
> > these
> > as functions without having to export the Calendar/Day counter constructor?
> > If so, how do you do that?
>
>In a metadata file having headerOnly='true' you define your functions
>with class Procedure. Then somewhere under qla you implement a
>wrapper for the QuantLib function. For examples of this please see
>srcgen/utilities.xml
>qla/utilites.cpp
>
>Regards,
>Eric
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
>for problems? Stop! Download the new AJAX search engine that makes
>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
>http://ads.osdn.com/?ad_idv37&alloc_id865&opick
>_______________________________________________
>Quantlib-dev mailing list
>Qua...@li...
>https://lists.sourceforge.net/lists/listinfo/quantlib-dev
Marco Marchioro
Head of Product Development
StatPro Italia
Phone: +39 02 4331 7497
Fax: +39 02 4391 1424
www.StatPro.com
|
|
From: eric e. <eri...@gm...> - 2006-01-12 16:18:06
|
Hi Marco > I'll commit the code and wait for comments. All looks good to me. Random thoughts - - I confirmed that it all works under Calc/Linux - Your "basic" stuff offers a new approach for direct access to general QuantLib functionality and I'm sure this feature will prove useful Many thanks for your contribution. Regards, Eric |
