Please Help Me With QuantlibXL
Locked
 
|
Dear all, I am trying to learn how to use QuantlibXL. But I cannot even get the VanillaSwap.xls to run. Here is where I am at: 1. Downloaded and installed everything. Included all of the xll and xla stuff that I can find. 2. Opened VanillaSwap.xls. Then immediately, my VBA editor complains about "autoOpenIRDerivatives". It cannot find the sub. 3. Played with VanillaSwap.xls but cannot get ride of the "#VALUE!"'s and "#NUM!"'s. Note: my Excel 2010 does recognize QuantlibXL functions. At least some of them, like "qlSettingsEvaluationDate" can return a meaningful result. Can you please help me to proceed? Thanks! - Alex ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: Please Help Me With QuantlibXL
|
|
Hi Alex,
If nothing is entered in the sheet, it requires Libor6M object to exist. The issue here is that "Libor6M" object doesn't exist. To take of the that, you would need to enter details for both the floating leg (Column B) and fixed leg (Column F). Hi All, Is there an excel function which displays what all objects are currently existing in the excel's memory. regards, Manas Date: Fri, 5 Aug 2011 08:45:48 -0700 From: [hidden email] To: [hidden email] Subject: [Quantlib-users] Please Help Me With QuantlibXL Dear all, I am trying to learn how to use QuantlibXL. But I cannot even get the VanillaSwap.xls to run. Here is where I am at: 1. Downloaded and installed everything. Included all of the xll and xla stuff that I can find. 2. Opened VanillaSwap.xls. Then immediately, my VBA editor complains about "autoOpenIRDerivatives". It cannot find the sub. 3. Played with VanillaSwap.xls but cannot get ride of the "#VALUE!"'s and "#NUM!"'s. Note: my Excel 2010 does recognize QuantlibXL functions. At least some of them, like "qlSettingsEvaluationDate" can return a meaningful result. Can you please help me to proceed? Thanks! - Alex ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: Please Help Me With QuantlibXL
|
|
ohRepositoryListObjectIDs
ohRangeRetrieveError applied to #NUM! cells may also give some hint what's wrong regards, Peter Am 07.08.2011 19:19, schrieb manas bhatt:
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: Please Help Me With QuantlibXL
|
|
Hey Guys, Thank you for the responses. I am still having trouble just to get started. I don't know if it has anything to do with the error I receive once I open the example swap sheet. The error message reads "Error initializing the QuantLibXL Framework. createCellMenu: getPasteSpecialIndex: Unable to access right click menu item'PasteSpecial': Object variable or With block variable not set". I tried to fill Column B and C as Schrieb suggested but still got a lot errors... The QuantlibXL 1.1.0 XLL is the only thing I included in my Excel 2010 options -> addin.
Is there a step by step guide that I can follow. Really hope I could use QuantlibXL. Thx, - Alex From: Peter Caspers <[hidden email]> To: [hidden email] Sent: Sunday, August 7, 2011 2:32 PM Subject: Re: [Quantlib-users] Please Help Me With QuantlibXL
ohRepositoryListObjectIDs ohRangeRetrieveError applied to #NUM! cells may also give some hint what's wrong regards, Peter Am 07.08.2011 19:19, schrieb manas bhatt:
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
|
|
Hi Alex,
I have the same error message that pops up as soon as I open the framework .xla file. Have you found a cure to that problem? I am under Excel 2010 32-bit and Windows 7 64-bit. My office language is german instead of english. I wonder if it has to do with that. In any case, whether you have solved or not solved the issue yet, it would be great to share our experiences and maybe work out a solution in the end. Best, Gavin
|
Re: Please Help Me With QuantlibXL
|
|
Hi,
Several of my colleagues had a similar problem - some QuantLibXL functions would return meaningful results (such as qlSettingsEvaluationDate) but others would return rubbish or error codes. Eventually I figured out they were missing some windows dlls - you could try using something like Dependency Walker (http://www.dependencywalker.com/) on the QuantLibXL .xll to see if you're missing any. Cheers, Andrew -----Original Message----- From: Gavin08 [mailto:[hidden email]] Sent: Monday, 24 October 2011 1:40 AM To: [hidden email] Subject: Re: [Quantlib-users] Please Help Me With QuantlibXL Hi Alex, I have the same error message that pops up as soon as I open the framework .xla file. Have you found a cure to that problem? I am under Excel 2010 32-bit and Windows 7 64-bit. My office language is german instead of english. I wonder if it has to do with that. In any case, whether you have solved or not solved the issue yet, it would be great to share our experiences and maybe work out a solution in the end. Best, Gavin Alex Zhang-9 wrote: > > Hey Guys, > > Thank you for the responses. > > I am still having trouble just to get started. I don't know if it has > anything to do with the error I receive once I open the example swap > sheet. > > The error message reads "Error initializing the QuantLibXL Framework. > createCellMenu: getPasteSpecialIndex: Unable to access right click > menu > item'PasteSpecial': Object variable or With block variable not set". > > I tried to fill Column B and C as Schrieb suggested but still got a > lot errors... > > The QuantlibXL 1.1.0 XLL is the only thing I included in my Excel 2010 > options -> addin. Is there a step by step guide that I can follow. > Really hope I could use QuantlibXL. > > Thx, > > - Alex > > > ________________________________ > From: Peter Caspers <[hidden email]> > To: [hidden email] > Sent: Sunday, August 7, 2011 2:32 PM > Subject: Re: [Quantlib-users] Please Help Me With QuantlibXL > > > ohRepositoryListObjectIDs > ohRangeRetrieveError applied to #NUM! cells may also give some hint > what's wrong > regards, Peter > > Am 07.08.2011 19:19, schrieb manas bhatt: > >> >>Hi Alex, >> If nothing is entered in the sheet, it requires Libor6M object to exist. >> >> >>Hi All, >> Is there an excel function which displays what all objects are >>currently existing in the excel's memory. >>regards, >>Manas >> >> >>________________________________ >>Date: Fri, 5 Aug 2011 08:45:48 -0700 >>From: [hidden email] >>To: [hidden email] >>Subject: [Quantlib-users] Please Help Me With QuantlibXL >> >> >>Dear all, >> >> >>I am trying to learn how to use QuantlibXL. But I cannot even get the >> >> >>Here is where I am at: >> >> >>1. Downloaded and installed everything. Included all of the xll and >>xla stuff that I can find.. >>2. Opened VanillaSwap.xls. Then immediately, my VBA editor complains >>about "autoOpenIRDerivatives". It cannot find the sub. >>3. Played with VanillaSwap.xls but cannot get ride of the "#VALUE!"'s >>and "#NUM!"'s. >> >> >>Note: my Excel 2010 does recognize QuantlibXL functions. At least some >>of them, like "qlSettingsEvaluationDate" can return a meaningful result. >> >> >>Can you please help me to proceed? Thanks! >> >> >>- Alex >>---------------------------------------------------------------------- >>-------- > BlackBerry® > DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with > experts. Get tools for creating Super Apps. See the latest > technologies. > Sessions, hands-on labs, demos & much more. Register > early & save! http://p.sf.net/sfu/rim-blackberry-1 >>_______________________________________________ > QuantLib-users mailing list > [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users >> > ---------------------------------------------------------------------- > -------- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, > CA The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 >> > _______________________________________________ > QuantLib-users mailing list [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users > > ---------------------------------------------------------------------- > -------- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, > CA The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > QuantLib-users mailing list > [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users > ---------------------------------------------------------------------- > -------- Get a FREE DOWNLOAD! and learn more about uberSVN rich > system, user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the tools > developers use with it. > http://p.sf.net/sfu/wandisco-dev2dev > _______________________________________________ > QuantLib-users mailing list > [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users > > -- View this message in context: http://old.nabble.com/Please-Help-Me-With-QuantlibXL-tp32203380p32705365.html Sent from the quantlib-users mailing list archive at Nabble.com. "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." ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
|
|
Hey again,
I think I understand now why the VBA FRAMEWORK keeps giving me an error pop-up on the start of Excel. From the reference page, http://quantlib.org/quantlibxl/framework.html, it is pretty clear that it has not been designed and tested for any Excel version beyond 2003. Hence, I carry on by just ignoring the vba framework (i.e. I uncheck it from Excel add-ins dialog) and just use the quantlibxl functions directly. They show up in the formula selection dialog ("fx" button under the corresponding tab), at the bottom of the list. Plus, I use the standalone workbook examples as well as the function reference supplied with quantlibxl to learn how things work (which is quite difficult to figure out in the beginning). That's basically it. Functions return meaningful results as far as I can tell. (No dll issues here) Best Gavin
|
Re: Please Help Me With QuantlibXL
|
|
Hi All,
I don't think the version number of Excel is the problem. I think the error may relate to using a non-English build of Excel. I think when inserting the right-click menu, maybe the code searches for an existing menu item based on its English name rather than its identifier, which is the wrong way to do it. In development the framework has been substantially revised and enhanced and I am in the process of packaging it up for the next release. I will try to recreate and fix this problem for the next release. Regards, Eric =================================================== Eric Ehlers nazcatech sprl | Brussels | http://www.nazcatech.be * Distributed computing for pricing analytics * Use Microsoft Excel as a client to the Grid Quoting Gavin08 <[hidden email]>: > > Hey again, > > I think I understand now why the VBA FRAMEWORK keeps giving me an error > pop-up on the start of Excel. From the reference page, > http://quantlib.org/quantlibxl/framework.html > http://quantlib.org/quantlibxl/framework.html , it is pretty clear that it > has not been designed and tested for any Excel version beyond 2003. > > Hence, I carry on by just ignoring the vba framework (i.e. I uncheck it from > Excel add-ins dialog) and just use the quantlibxl functions directly. They > show up in the formula selection dialog ("fx" button under the corresponding > tab), at the bottom of the list. Plus, I use the standalone workbook > examples as well as the function reference supplied with quantlibxl to learn > how things work (which is quite difficult to figure out in the beginning). > That's basically it. Functions return meaningful results as far as I can > tell. (No dll issues here) > > Best > Gavin > > > Andrew Downes wrote: >> >> Hi, >> >> Several of my colleagues had a similar problem - some QuantLibXL functions >> would return meaningful results (such as qlSettingsEvaluationDate) but >> others would return rubbish or error codes. Eventually I figured out they >> were missing some windows dlls - you could try using something like >> Dependency Walker (http://www.dependencywalker.com/) on the QuantLibXL >> .xll to see if you're missing any. >> >> Cheers, >> >> Andrew >> >> -----Original Message----- >> From: Gavin08 [mailto:[hidden email]] >> Sent: Monday, 24 October 2011 1:40 AM >> To: [hidden email] >> Subject: Re: [Quantlib-users] Please Help Me With QuantlibXL >> >> >> Hi Alex, >> I have the same error message that pops up as soon as I open the framework >> .xla file. Have you found a cure to that problem? >> I am under Excel 2010 32-bit and Windows 7 64-bit. My office language is >> german instead of english. I wonder if it has to do with that. >> In any case, whether you have solved or not solved the issue yet, it would >> be great to share our experiences and maybe work out a solution in the >> end. >> >> Best, >> Gavin >> >> >> >> Alex Zhang-9 wrote: >>> >>> Hey Guys, >>> >>> Thank you for the responses. >>> >>> I am still having trouble just to get started. I don't know if it has >>> anything to do with the error I receive once I open the example swap >>> sheet. >>> >>> The error message reads "Error initializing the QuantLibXL Framework. >>> createCellMenu: getPasteSpecialIndex: Unable to access right click >>> menu >>> item'PasteSpecial': Object variable or With block variable not set". >>> >>> I tried to fill Column B and C as Schrieb suggested but still got a >>> lot errors... >>> >>> The QuantlibXL 1.1.0 XLL is the only thing I included in my Excel 2010 >>> options -> addin. Is there a step by step guide that I can follow. >>> Really hope I could use QuantlibXL. >>> >>> Thx, >>> >>> - Alex >>> >>> >>> ________________________________ >>> From: Peter Caspers <[hidden email]> >>> To: [hidden email] >>> Sent: Sunday, August 7, 2011 2:32 PM >>> Subject: Re: [Quantlib-users] Please Help Me With QuantlibXL >>> >>> >>> ohRepositoryListObjectIDs >>> ohRangeRetrieveError applied to #NUM! cells may also give some hint >>> what's wrong >>> regards, Peter >>> >>> Am 07.08.2011 19:19, schrieb manas bhatt: >>> >>>> >>>> Hi Alex, >>>> If nothing is entered in the sheet, it requires Libor6M object to > exist. >> The issue here is that "Libor6M" object doesn't exist. To take of the >> that, you would need to enter details for both the floating leg (Column B) >> and fixed leg (Column F). >>>> >>>> >>>> Hi All, >>>> Is there an excel function which displays what all objects are >>>> currently >> existing in the excel's memory. >>>> regards, >>>> Manas >>>> >>>> >>>> ________________________________ >>>> Date: Fri, 5 Aug 2011 08:45:48 -0700 >>>> From: [hidden email] >>>> To: [hidden email] >>>> Subject: [Quantlib-users] Please Help Me With QuantlibXL >>>> >>>> >>>> Dear all, >>>> >>>> >>>> I am trying to learn how to use QuantlibXL. But I cannot even get the >> VanillaSwap.xls to run. >>>> >>>> >>>> Here is where I am at: >>>> >>>> >>>> 1. Downloaded and installed everything. Included all of the xll and >>>> xla >> stuff that I can find.. >>>> 2. Opened VanillaSwap.xls. Then immediately, my VBA editor complains >>>> about >> "autoOpenIRDerivatives". It cannot find the sub. >>>> 3. Played with VanillaSwap.xls but cannot get ride of the "#VALUE!"'s >>>> and >> "#NUM!"'s. >>>> >>>> >>>> Note: my Excel 2010 does recognize QuantlibXL functions. At least some >>>> of >> them, like "qlSettingsEvaluationDate" can return a meaningful result. >>>> >>>> >>>> Can you please help me to proceed? Thanks! >>>> >>>> >>>> - Alex >>>> ---------------------------------------------------------------------- >>>> -------- >>> BlackBerry® >>> DevCon Americas, Oct. 18-20, San Francisco, CA >>> The must-attend event for mobile developers. Connect with >>> experts. Get tools for creating Super Apps. See the latest >>> technologies. >>> Sessions, hands-on labs, demos & much more. Register >>> early & save! http://p.sf.net/sfu/rim-blackberry-1 >>>> _______________________________________________ >>> QuantLib-users mailing list >>> [hidden email] >>> https://lists.sourceforge.net/lists/listinfo/quantlib-users >>>> >>> ---------------------------------------------------------------------- >>> -------- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, >>> CA The must-attend event for mobile developers. Connect with experts. >>> Get tools for creating Super Apps. See the latest technologies. >>> Sessions, hands-on labs, demos & much more. Register early & save! >>> http://p.sf.net/sfu/rim-blackberry-1 >>>> >>> _______________________________________________ >>> QuantLib-users mailing list [hidden email] >>> https://lists.sourceforge.net/lists/listinfo/quantlib-users >>> >>> ---------------------------------------------------------------------- >>> -------- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, >>> CA The must-attend event for mobile developers. Connect with experts. >>> Get tools for creating Super Apps. See the latest technologies. >>> Sessions, hands-on labs, demos & much more. Register early & save! >>> http://p.sf.net/sfu/rim-blackberry-1 >>> _______________________________________________ >>> QuantLib-users mailing list >>> [hidden email] >>> https://lists.sourceforge.net/lists/listinfo/quantlib-users >>> ---------------------------------------------------------------------- >>> -------- Get a FREE DOWNLOAD! and learn more about uberSVN rich >>> system, user administration capabilities and model configuration. Take >>> the hassle out of deploying and managing Subversion and the tools >>> developers use with it. >>> http://p.sf.net/sfu/wandisco-dev2dev >>> _______________________________________________ >>> QuantLib-users mailing list >>> [hidden email] >>> https://lists.sourceforge.net/lists/listinfo/quantlib-users >>> >>> >> >> -- >> View this message in context: >> http://old.nabble.com/Please-Help-Me-With-QuantlibXL-tp32203380p32705365.html >> Sent from the quantlib-users mailing list archive at Nabble.com. >> >> >> >> >> "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." >> >> ------------------------------------------------------------------------------ >> The demand for IT networking professionals continues to grow, and the >> demand for specialized networking skills is growing even more rapidly. >> Take a complimentary Learning@Cisco Self-Assessment and learn >> about Cisco certifications, training, and career opportunities. >> http://p.sf.net/sfu/cisco-dev2dev >> _______________________________________________ >> QuantLib-users mailing list >> [hidden email] >> https://lists.sourceforge.net/lists/listinfo/quantlib-users >> >> > > -- > View this message in context: > http://old.nabble.com/Please-Help-Me-With-QuantlibXL-tp32203380p32726871.html > Sent from the quantlib-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > The demand for IT networking professionals continues to grow, and the > demand for specialized networking skills is growing even more rapidly. > Take a complimentary Learning@Cisco Self-Assessment and learn > about Cisco certifications, training, and career opportunities. > http://p.sf.net/sfu/cisco-dev2dev > _______________________________________________ > QuantLib-users mailing list > [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
«
Return to quantlib-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |