Re: [Quantlib-users] what do I need to make run an xll ?

[Ferdinando M. Ametrano-3]

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

[eric ehlers]

> 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

[JOSHI, Mark, Group Risk Mgmt]

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.

 

the relevant ones may be mscvp70.dll

mscvi70.dll

msvcr70.dll

 

regards

Mark

 

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Adjriou Belak
Sent: 09 February 2005 15:02
To: [hidden email]; [hidden email]
Subject: [Quantlib-users] what do I need to make run an xll ?

Hi,

 

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++ ?

 

regards

thanks for your help.

---

Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails !
Créez votre Yahoo! Mail

***********************************************************************************
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB.
Authorised and regulated by the Financial Services Authority

This e-mail message is confidential and for use by the
addressee only. If the message is received by anyone other
than the addressee, please return the message to the sender
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
changes made to this message after it was sent.

Whilst all reasonable care has been taken to avoid the
transmission of viruses, it is the responsibility of the recipient to
ensure that the onward transmission, opening or use of this
message and any attachments will not adversely affect its
systems or data. No responsibility is accepted by The Royal
Bank of Scotland plc in this regard and the recipient should carry
out such virus and other checks as it considers appropriate.
Visit our websites at:
http://www.rbs.co.uk/CBFM
http://www.rbsmarkets.com
********************************************************************************

[Daniele De Francesco-2]

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:[hidden email]]
Sent: Wednesday, February 09, 2005 5:41 PM
To: Adjriou Belak
Cc: [hidden email]; [hidden email]
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

[Luigi Ballabio]

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  
settings. I don't have .NET, but there should be a project setting (on VC6  
it used to be under 'C++/Code generation') letting you choose the run-time  
library to use. You should have the alternative between depending on DLLs  
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.

[Marco Marchioro]

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: [phone]
Fax:   [phone]
www.StatPro.com

[eric ehlers]

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

[Lars Schouw]

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.

[eric ehlers]

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

[Marco Marchioro]

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
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Marco Marchioro
Head of Product Development
StatPro Italia

Phone: [phone]
Fax:   [phone]
www.StatPro.com

[eric ehlers]

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