Posted by
Joe Byers-2 on
URL: http://quantlib.414.s1.nabble.com/build-dll-from-QuantlibExcel-tp3303p3307.html
Eric and Xavier,
I am interested in a permanent excel or openoffice
link. I teach at the univeristy of tulsa and require
my students to purchase Espen Haug's book The complete
option guided because I converted the formulaes in
that book to an excel addin. Quantlib would be a nice
replacement. Also, FEA and Techhackers proprietary
financial functions that quantlib could replace in
many instances if there was an excel addin so people
could see what quantlib does and utilize quantlib
dll's in their production models.
Just a thought
Joe
--- eric <
[hidden email]> wrote:
> On Thu, 2004-09-23 at 11:06,
>
[hidden email] wrote:
> > Hi Eric,
> > thank you very much for your answer.
>
> Hi Xavier,
> Happy to help.
>
> > I did something different, I've redefined the
> class with something
> > like:
> >
> > double _stdcall vbainterpolate2D(double * x_tab,
> int sizex, double *
>
> Perfect. That gets around the problem of
> translating XLOPERs.
>
> > However your solution looks better, if it's just a
> replacement of
> > XlfFuncDesc with XlfCmdDescit won't be so long.
>
> As far as I can determine, this approach is viable.
> As I'm sure you
> know, you'd load the XLL as normal, and invoke it
> from VBA with
>
> retval = Application.Run("function_name", arg1,
> arg2, ..., argn)
>
> The arguments could be any VBA datatype and Excel
> would automatically
> convert them (where valid) to the corresponding
> XLOPERs.
>
> A limitation of this approach, it could only be used
> with Excel VBA, not
> pure VB.
>
> > I will study this solution in detail and thank you
> gain for your help
> > Xavier
>
> I'm very curious to hear how you get on - please
> keep us posted. If you
> and/or others have an ongoing requirement for
> invoking QuantLib from VB
> / Excel VBA then I think an argument could be made
> for implementing a
> permanent solution to this and I'd be happy to
> assist.
>
> Many Thanks,
> Eric
>
>
>
>
-------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE.
> Be one of 170
> Project Admins to receive an Apple iPod Mini FREE
> for your judgement on
> who ports your project to Linux PPC the best.
> Sponsored by IBM.
> Deadline: Sept. 24. Go here:
>
http://sf.net/ppc_contest.php> _______________________________________________
> Quantlib-users mailing list
>
[hidden email]
>
>
=====
A man is not the center of his universe, rather those he loves are. So his focus should always be on them for they will provide him with love and happiness all of his life - Anonymous
__________________________________
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.
http://messenger.yahoo.com