Re: QuantLibXL function in Excel, limit in number of arguments?

Posted by willshaw on Jul 23, 2008; 1:14am
URL: http://quantlib.414.s1.nabble.com/QuantLibXL-function-in-Excel-limit-in-number-of-arguments-tp12171p12173.html

Hi, to expose a function to Excel, I first define the function interface in project "QuantLibObjects" under namespace QuantLibAddin, it should call the real function in QuantLib, then edit the xml in project "qlgensrc", then compile. No edit of autogenerated files. I use Excel 2003.

Regards,

Eric Ehlers-2 wrote

Hello,

There is a limit of 20 arguments to QuantLibXL functions.  I
have added a new item in the FAQ to document this issue:

http://quantlib.org/quantlibaddin/faq.html#faq_item_numparams

I cannot explain why you are hitting a limit of 15.  How are
you going about adding the additional arguments?  Are you
editing the XML function metadata for gensrc?  Or are you
manually editing the C++ source files that were autogenerated
by gensrc?

Regards,
Eric

On Tue, July 15, 2008 13:59, willshaw wrote:
>
> Hi,
>
> It seems that the function exposed to Excel by QuantLibXL has
a
> limit in
> number of arguments, 15. If I have more than 15 arguments in
> function,
> although I can compile xll successfully, when I click the
> function in Excel,
> nothing happens. But if I reduced the arguments to less than
15
> without
> doing anything else, it works.
>
> Any idea?
>
> Thanks.
> --
> View this message in context:
> http://www.nabble.com/QuantLibXL-function-in-Excel%2C-limit-in-number-of-arguments--tp18464649p18464649.html
Sent from the quantlib-dev mailing list archive at
Nabble.com.
>
>
> -------------------------------------------------------------------------
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-dev mailing list
> [e-mail]
> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>


-------------------------
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-dev mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev