QLXL

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

QLXL

petercaspers

Hi,

I want to use QuantLibXL to export my own quantlib extensions to excel. I
can imitate the existing code, but honestly I do not really understand what
I am doing and why. From time to time errors occur and I have to try
several things until it works, but then I do not have the feeling that I
learned anything from this.

Is there something like a 'cookbook' how to do these exports correctly and
'in line' with the existing quantlib XL project without having to read to
much technicalities about the object handler and gensrc frameworks?

Right now, I get linker errors like (using version 0.9.7 with msvc 2005)

register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl registerSimplesvmodel(struct xloper const &)"
(?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
registerQlFunctions(struct xloper const &)"
(?registerQlFunctions@@YAXABUxloper@@@Z)".
register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper const &)"
(?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
unregisterQlFunctions(struct xloper const &)"
(?unregisterQlFunctions@@YAXABUxloper@@@Z)".
..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
aufgelöste externe Verweise.

(my class is named SimpleSVModel, so the spelling is in fact different than
in the error message, but I do not see where this spelling comes from).

Has anyone a hint for me (for the linker errors and concerning the
cookbook)?

Thank you , best regards
Peter

------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QLXL

Pomarico Francesco Ivan
Hi Peter,

I can bring in my own experience. I did my own extensions to Quantlib and interfaced them to Excel through XLW (http://xlw.sourceforge.net/index.shtml). This is very easy and straightforward. OK, that way you don't have objects on the worksheets, so what?

I simply gave up trying to interface customized Quantlib stuff with object handler and QuantlibXL. Maybe I am wrong but in my view the effort is not worth of.

Regards,
Ivan

-----Original Message-----
From: Peter Caspers [mailto:[hidden email]]
Sent: Wednesday, September 23, 2009 9:13 AM
To: [hidden email]
Subject: [Quantlib-users] QLXL


Hi,

I want to use QuantLibXL to export my own quantlib extensions to excel. I
can imitate the existing code, but honestly I do not really understand what
I am doing and why. From time to time errors occur and I have to try
several things until it works, but then I do not have the feeling that I
learned anything from this.

Is there something like a 'cookbook' how to do these exports correctly and
'in line' with the existing quantlib XL project without having to read to
much technicalities about the object handler and gensrc frameworks?

Right now, I get linker errors like (using version 0.9.7 with msvc 2005)

register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl registerSimplesvmodel(struct xloper const &)"
(?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
registerQlFunctions(struct xloper const &)"
(?registerQlFunctions@@YAXABUxloper@@@Z)".
register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper const &)"
(?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
unregisterQlFunctions(struct xloper const &)"
(?unregisterQlFunctions@@YAXABUxloper@@@Z)".
..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
aufgelöste externe Verweise.

(my class is named SimpleSVModel, so the spelling is in fact different than
in the error message, but I do not see where this spelling comes from).

Has anyone a hint for me (for the linker errors and concerning the
cookbook)?

Thank you , best regards
Peter

------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users


Le informazioni contenute nella comunicazione che precede possono essere riservate e sono, comunque, destinate esclusivamente alla persona o all'ente sopraindicati. La diffusione, distribuzione e/o copia delle informazioni trasmesse, salvo specifica autorizzazione, è da intendersi proibita. Tali informazioni vengono inoltre fornite per fini di informazione ed illustrazione, non costituendo le stesse una sollecitazione all'investimento o un'offerta all'acquisto o alla vendita di strumenti finanziari.
Le informazioni qui contenute non rappresentano una posizione ufficiale di Abaxbank.
La sicurezza e la correttezza dei messaggi di posta elettronica non possono essere garantite. Se avete ricevuto questo messaggio per errore, Vi preghiamo di contattarci immediatamente.
******
The information in this message may be confidential and are intended for personal use of the designated recipient(s) named above. Any review, dissemination, distribution or copying of this message is strictly prohibited unless authorized. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, or as an official statement of Abaxbank.
Email transmission cannot be guaranteed to be secure or error-free. If you have received this email by mistake, please notify us immediately.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Antwort: RE: QLXL

petercaspers
Thank you, Ivan, for mentioning this alternative (also for making me feel,
that I am not the only one having problems with QLXL  ;-) ).

I will surely have a look at XLW. However, no objects on the worksheet seem
a major disadvantage for me. My whole C++ code relies on object orientation
and packaging all the functionality into stand alone functions seems
tedious, at least at first sight.

All I would need is something like "you want to export a class / member
function / stand alone function => you have to make entries here and there,
write these classes, should use these types in the interfaces, add these
generated files to the project and so on and so on", and what each step is
good for.



                                                                           
             "Pomarico                                                    
             Francesco Ivan"                                              
             <francesco.pomari                                          An
             [hidden email]>           "Peter Caspers"                    
                                        <[hidden email]>,        
             23.09.2009 12:57           <[hidden email].
                                        net>                              
                                                                     Kopie
                                                                           
                                                                     Thema
                                        RE: [Quantlib-users] QLXL          
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hi Peter,

I can bring in my own experience. I did my own extensions to Quantlib and
interfaced them to Excel through XLW (
http://xlw.sourceforge.net/index.shtml). This is very easy and
straightforward. OK, that way you don't have objects on the worksheets, so
what?

I simply gave up trying to interface customized Quantlib stuff with object
handler and QuantlibXL. Maybe I am wrong but in my view the effort is not
worth of.

Regards,
Ivan

-----Original Message-----
From: Peter Caspers [mailto:[hidden email]]
Sent: Wednesday, September 23, 2009 9:13 AM
To: [hidden email]
Subject: [Quantlib-users] QLXL


Hi,

I want to use QuantLibXL to export my own quantlib extensions to excel. I
can imitate the existing code, but honestly I do not really understand what
I am doing and why. From time to time errors occur and I have to try
several things until it works, but then I do not have the feeling that I
learned anything from this.

Is there something like a 'cookbook' how to do these exports correctly and
'in line' with the existing quantlib XL project without having to read to
much technicalities about the object handler and gensrc frameworks?

Right now, I get linker errors like (using version 0.9.7 with msvc 2005)

register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl registerSimplesvmodel(struct xloper const &)"
(?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
registerQlFunctions(struct xloper const &)"
(?registerQlFunctions@@YAXABUxloper@@@Z)".
register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper const &)"
(?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
unregisterQlFunctions(struct xloper const &)"
(?unregisterQlFunctions@@YAXABUxloper@@@Z)".
..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
aufgelöste externe Verweise.

(my class is named SimpleSVModel, so the spelling is in fact different than
in the error message, but I do not see where this spelling comes from).

Has anyone a hint for me (for the linker errors and concerning the
cookbook)?

Thank you , best regards
Peter




------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: Antwort: RE: QLXL

Luigi Ballabio
On Wed, 2009-09-23 at 15:00 +0200, Peter Caspers wrote:
> All I would need is something like "you want to export a class / member
> function / stand alone function => you have to make entries here and there,
> write these classes, should use these types in the interfaces, add these
> generated files to the project and so on and so on", and what each step is
> good for.

Anybody wanting to have a try at writing this? I'm sure Eric would be
happy to put it on the QLXL site.

Luigi


--

Barker's Proof:
Proofreading is more effective after publication.



------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QLXL

Kim Kuen Tang
In reply to this post by petercaspers
Hi Peter,

this link should help you.

http://quantlib.org/quantlibaddin/extend_tutorial.html

Best regards,
Kim

Peter Caspers schrieb:

> Hi,
>
> I want to use QuantLibXL to export my own quantlib extensions to excel. I
> can imitate the existing code, but honestly I do not really understand what
> I am doing and why. From time to time errors occur and I have to try
> several things until it works, but then I do not have the feeling that I
> learned anything from this.
>
> Is there something like a 'cookbook' how to do these exports correctly and
> 'in line' with the existing quantlib XL project without having to read to
> much technicalities about the object handler and gensrc frameworks?
>
> Right now, I get linker errors like (using version 0.9.7 with msvc 2005)
>
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
> Symbol ""void __cdecl registerSimplesvmodel(struct xloper const &)"
> (?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
> registerQlFunctions(struct xloper const &)"
> (?registerQlFunctions@@YAXABUxloper@@@Z)".
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes externes
> Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper const &)"
> (?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
> unregisterQlFunctions(struct xloper const &)"
> (?unregisterQlFunctions@@YAXABUxloper@@@Z)".
> ..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
> aufgelöste externe Verweise.
>
> (my class is named SimpleSVModel, so the spelling is in fact different than
> in the error message, but I do not see where this spelling comes from).
>
> Has anyone a hint for me (for the linker errors and concerning the
> cookbook)?
>
> Thank you , best regards
> Peter
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------
> WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
> Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
> Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
> Hans-Bernd Wolberg
> Vorsitzender des Aufsichtsrats: Dieter Philipp
>
> Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
> oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
> verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
> Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
> U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
> Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
> sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.
>
> Messages sent by e-mail can be manipulated by third parties. For this
> reason our e-mail messages are generally not legally binding. This
> electronic message (including any attachments) contains confidential
> information and may be privileged or otherwise protected from disclosure.
> The information is intended to be for the use of the intended addressee
> only. Please be aware that any copy, distribution or use of the contents of
> this message by any other person than the intended addressee is prohibited.
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>
>  


------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QLXL

Andrew Downes
Yes, in particular have a look at the last part of step 3 (adding files to the projects). I had similar error messages when I'd forgotten to add a couple of the auto generated files.

Regards,

Andrew

-----Original Message-----
From: Kim Kuen Tang [mailto:[hidden email]]
Sent: Thursday, 24 September 2009 4:44 AM
To: Peter Caspers
Cc: [hidden email]
Subject: Re: [Quantlib-users] QLXL

Hi Peter,

this link should help you.

http://quantlib.org/quantlibaddin/extend_tutorial.html

Best regards,
Kim

Peter Caspers schrieb:

> Hi,
>
> I want to use QuantLibXL to export my own quantlib extensions to
> excel. I can imitate the existing code, but honestly I do not really
> understand what I am doing and why. From time to time errors occur and
> I have to try several things until it works, but then I do not have
> the feeling that I learned anything from this.
>
> Is there something like a 'cookbook' how to do these exports correctly
> and 'in line' with the existing quantlib XL project without having to
> read to much technicalities about the object handler and gensrc frameworks?
>
> Right now, I get linker errors like (using version 0.9.7 with msvc
> 2005)
>
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes
> externes Symbol ""void __cdecl registerSimplesvmodel(struct xloper const &)"
> (?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
> registerQlFunctions(struct xloper const &)"
> (?registerQlFunctions@@YAXABUxloper@@@Z)".
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes
> externes Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper const &)"
> (?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void
> __cdecl unregisterQlFunctions(struct xloper const &)"
> (?unregisterQlFunctions@@YAXABUxloper@@@Z)".
> ..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
> aufgelöste externe Verweise.
>
> (my class is named SimpleSVModel, so the spelling is in fact different
> than in the error message, but I do not see where this spelling comes from).
>
> Has anyone a hint for me (for the linker errors and concerning the
> cookbook)?
>
> Thank you , best regards
> Peter
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> ---------- WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
> Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
> Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
> Hans-Bernd Wolberg Vorsitzender des Aufsichtsrats: Dieter Philipp
>
> Ueber das Internet versandte E-Mails koennen unter fremdem Namen
> erstellt oder inhaltlich veraendert werden. Aus diesem Grund sind
> unsere als E-Mail verschickten Nachrichten grundsaetzlich keine
> rechtsverbindlichen Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
> U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen
> bestimmten Empfaenger gerichtet. Eine Weitergabe, die Herstellung von
> Kopien oder der sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.
>
> Messages sent by e-mail can be manipulated by third parties. For this
> reason our e-mail messages are generally not legally binding. This
> electronic message (including any attachments) contains confidential
> information and may be privileged or otherwise protected from disclosure.
> The information is intended to be for the use of the intended
> addressee only. Please be aware that any copy, distribution or use of
> the contents of this message by any other person than the intended addressee is prohibited.
>
> ----------------------------------------------------------------------
> -------- Come build with us! The BlackBerry&reg; Developer Conference
> in SF, CA is the only developer event you need to attend this year.
> Jumpstart your developing skills, take BlackBerry mobile applications
> to market and stay ahead of the curve. Join us from November 9&#45;12,
> 2009. Register now&#33; http://p.sf.net/sfu/devconf 
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>
>  




"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Antwort: RE: QLXL

petercaspers
Thanks a lot. I forgot two files of step 3. Now it works. Also, this
tutorial is sufficient for me. It is what I have been looking for.
Best regards
Peter



                                                                           
             "Downes, Andrew"                                              
             <Andrew.Downes@an                                            
             z.com>                                                     An
                                        "Kim Kuen Tang"                    
             24.09.2009 00:46           <[hidden email]>, "Peter    
                                        Caspers"                          
                                        <[hidden email]>        
                                                                     Kopie
                                        <[hidden email].
                                        net>                              
                                                                     Thema
                                        RE: [Quantlib-users] QLXL          
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Yes, in particular have a look at the last part of step 3 (adding files to
the projects). I had similar error messages when I'd forgotten to add a
couple of the auto generated files.

Regards,

Andrew

-----Original Message-----
From: Kim Kuen Tang [mailto:[hidden email]]
Sent: Thursday, 24 September 2009 4:44 AM
To: Peter Caspers
Cc: [hidden email]
Subject: Re: [Quantlib-users] QLXL

Hi Peter,

this link should help you.

http://quantlib.org/quantlibaddin/extend_tutorial.html

Best regards,
Kim

Peter Caspers schrieb:

> Hi,
>
> I want to use QuantLibXL to export my own quantlib extensions to
> excel. I can imitate the existing code, but honestly I do not really
> understand what I am doing and why. From time to time errors occur and
> I have to try several things until it works, but then I do not have
> the feeling that I learned anything from this.
>
> Is there something like a 'cookbook' how to do these exports correctly
> and 'in line' with the existing quantlib XL project without having to
> read to much technicalities about the object handler and gensrc
frameworks?
>
> Right now, I get linker errors like (using version 0.9.7 with msvc
> 2005)
>
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes
> externes Symbol ""void __cdecl registerSimplesvmodel(struct xloper const
&)"
> (?registerSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void __cdecl
> registerQlFunctions(struct xloper const &)"
> (?registerQlFunctions@@YAXABUxloper@@@Z)".
> register_all.obj : error LNK2019: Verweis auf nicht aufgelöstes
> externes Symbol ""void __cdecl unregisterSimplesvmodel(struct xloper
const &)"
> (?unregisterSimplesvmodel@@YAXABUxloper@@@Z)" in Funktion ""void
> __cdecl unregisterQlFunctions(struct xloper const &)"
> (?unregisterQlFunctions@@YAXABUxloper@@@Z)".
> ..\xll\QuantLibXL-vc80-mt-0_9_7.xll : fatal error LNK1120: 2 nicht
> aufgelöste externe Verweise.
>
> (my class is named SimpleSVModel, so the spelling is in fact different
> than in the error message, but I do not see where this spelling comes
from).

>
> Has anyone a hint for me (for the linker errors and concerning the
> cookbook)?
>
> Thank you , best regards
> Peter
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> ---------- WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
> Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
> Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
> Hans-Bernd Wolberg Vorsitzender des Aufsichtsrats: Dieter Philipp
>
> Ueber das Internet versandte E-Mails koennen unter fremdem Namen
> erstellt oder inhaltlich veraendert werden. Aus diesem Grund sind
> unsere als E-Mail verschickten Nachrichten grundsaetzlich keine
> rechtsverbindlichen Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen
ist vertraulich und u.
> U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen
> bestimmten Empfaenger gerichtet. Eine Weitergabe, die Herstellung von
> Kopien oder der sonstige Gebrauch durch Nichtadressaten ist nicht
erlaubt.
>
> Messages sent by e-mail can be manipulated by third parties. For this
> reason our e-mail messages are generally not legally binding. This
> electronic message (including any attachments) contains confidential
> information and may be privileged or otherwise protected from disclosure.
> The information is intended to be for the use of the intended
> addressee only. Please be aware that any copy, distribution or use of
> the contents of this message by any other person than the intended
addressee is prohibited.

>
> ----------------------------------------------------------------------
> -------- Come build with us! The BlackBerry&reg; Developer Conference
> in SF, CA is the only developer event you need to attend this year.
> Jumpstart your developing skills, take BlackBerry mobile applications
> to market and stay ahead of the curve. Join us from November 9&#45;12,
> 2009. Register now&#33; http://p.sf.net/sfu/devconf
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>
>




"This e-mail and any attachments to it (the "Communication") is, unless
otherwise stated, confidential,  may contain copyright material and is for
the use only of the intended recipient. If you receive the Communication in
error, please notify the sender immediately by return e-mail, delete the
Communication and the return e-mail, and do not read, copy, retransmit or
otherwise deal with it. Any views expressed in the Communication are those
of the individual sender only, unless expressly stated to be those of
Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any
of its related entities including ANZ National Bank Limited (together
"ANZ"). ANZ does not accept liability in connection with the integrity of
or errors in the Communication, computer virus, data corruption,
interference or delay arising from or in respect of the Communication."


------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

QLXL

Piter Dias-4

> Thanks a lot. I forgot two files of step 3. Now it works. Also, this
> tutorial is sufficient for me. It is what I have been looking for.

This tutorial is available in http://www.quantlibaddin.org but not in
http://www.quantlibxl.org. How about including it in both?

Regards,

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

Piter Dias
[hidden email]

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users