QuantLib › quantlib-users

XL Workbooks

Classic

List

Threaded

4 messages Options

Georgy Jikia

XL Workbooks

Hi,

I'm trying the Workbooks in Standalone Examples directory.

Already the simplest one produces the following error message:

ERROR - BlackFormula.xls!$E$7 - qlBlackFormula2 - Error retrieving object with id 'obj_0002d#0000' - unable to convert reference to type 'class QuantLibAddin::PlainVanillaPayoff'

Am I doing something wrong?

Georgy

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

eric ehlers

Re: XL Workbooks

Hi Georgy,

That book is broken and I thought I had excluded it from the release,
looks like it slipped through.

Please try MarketData.xls + VanillaSwap.xls / Swap.xls / Swaption.xls.
After opening you need to hit Ctrl-Alt-F9 to force a recalculation.

Regards,
Eric

On 6/12/07, Georgy Jikia <[hidden email]> wrote:

> Hi,
>
> I'm trying the Workbooks in Standalone Examples directory.
> Already the simplest one produces the following error message:
>
> ERROR - BlackFormula.xls!$E$7 - qlBlackFormula2 - Error retrieving object
> with id 'obj_0002d#0000' - unable to convert reference to type 'class
> QuantLibAddin::PlainVanillaPayoff'
>
> Am I doing something wrong?
>
> Georgy
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>
>

Georgy Jikia

Re: XL Workbooks

Hi Eric,

thanks for the lightning fast answer!

In fact I see lots of errors, for example capfloors.xls produces the following one:

ERROR - [capfloors.xls]Instruments!$J$9 - qlVanillaSwap - ObjectHandler error: attempt to retrieve object with unknown ID 'EURYC'
ERROR - [capfloors.xls]Instruments!$M$9 - qlSwap - operToVector: error converting parameter 'legIDs' : Error in call to Excel: (xlSpecial | 2) callback failed: Command failed

Should I submit such errors to the mailing list?

And another question: there are lots of other examples, in addition to standalone ones. Is there any guide on how to use them? I did try to open these workbooks, but failed to produce any meaningful numbers different from #N/A...

Best regards,

Georgy

On 6/12/07, eric ehlers <[hidden email]> wrote:

Hi Georgy,

That book is broken and I thought I had excluded it from the release,
looks like it slipped through.

Please try MarketData.xls + VanillaSwap.xls / Swap.xls / Swaption.xls.
After opening you need to hit Ctrl-Alt-F9 to force a recalculation.

Regards,
Eric

On 6/12/07, Georgy Jikia <[hidden email]> wrote:

> Hi,
>
> I'm trying the Workbooks in Standalone Examples directory.
> Already the simplest one produces the following error message:
>
> ERROR - BlackFormula.xls!$E$7 - qlBlackFormula2 - Error retrieving object
> with id 'obj_0002d#0000' - unable to convert reference to type 'class
> QuantLibAddin::PlainVanillaPayoff'
>
> Am I doing something wrong?
>
> Georgy
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>
>

eric ehlers

Re: XL Workbooks

Hi Georgy,

> thanks for the lightning fast answer!

Any excuse to avoid work ;-)

> In fact I see lots of errors, for example capfloors.xls produces the

That book is also broken and should also have been excluded from the release.

I see what happened now, I messed up the installer. If on
installation the framework is not selected, then the broken workbooks
are correctly excluded from the StandaloneExamples directory. But if
you install the framework, as you have done, then the broken workbooks
are included.

> Should I submit such errors to the mailing list?

Thanks for offering to help but I wouldn't worry about it. The
development environment has moved on a lot since 0.8.0 was released.
I'll try to ensure no further errors of this kind in the next release.

> And another question: there are lots of other examples, in addition to
> standalone ones. Is there any guide on how to use them? I did try to open
> these workbooks, but failed to produce any meaningful numbers different from
> #N/A...

The books that can (more or less) be used with the XLL on its own are
found in directories DateCalendarsDayCounters, Math,
StandaloneExamples, Utilities. The remaining workbooks are owned by
the framework which is documented at
http://www.quantlibxl.org/framework.html.

Regards,
Eric

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users