intro to quantlibxl

[paolo baroni]

Hi, I'm really newbie in quantlibxl and I'm trying to understand how it works...

So, first question:

when I use a function that needs a vector as input (vector<long>) I always have an error output (#NUM!
). For example I tried to pass a date (in different format) to the function qlDateEndOfMonth but it doesn't work.
I suppose that I give to the function a wrong input... Can someone help me?

thanks

Paolo

[Ferdinando M. Ametrano-3]

On Fri, Apr 16, 2010 at 5:36 PM, paolo baroni <[hidden email]> wrote:

> Hi, I'm really newbie in quantlibxl and I'm trying to understand how it
> works...
>
> So, first question:
>
> when I use a function that needs a vector as input (vector<long>) I always
> have an error output (#NUM!
> ). For example I tried to pass a date (in different format) to the function
> qlDateEndOfMonth but it doesn't work.
> I suppose that I give to the function a wrong input... Can someone help me?

mmm... hard to help you without knowing which QLXL version you are
using, without an attached spreadsheet reproducing an error, etc.

type "=qlDateEndOfMonth(TODAY())" in a cell and it should work

ciao -- Nando

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[paolo baroni]

Thank you!

now it works well!

Ciao

Paolo

2010/4/19 Ferdinando Ametrano <[hidden email]>

On Fri, Apr 16, 2010 at 5:36 PM, paolo baroni <[hidden email]> wrote:
> Hi, I'm really newbie in quantlibxl and I'm trying to understand how it
> works...
>
> So, first question:
>
> when I use a function that needs a vector as input (vector<long>) I always
> have an error output (#NUM!
> ). For example I tried to pass a date (in different format) to the function
> qlDateEndOfMonth but it doesn't work.
> I suppose that I give to the function a wrong input... Can someone help me?

mmm... hard to help you without knowing which QLXL version you are
using, without an attached spreadsheet reproducing an error, etc.

type "=qlDateEndOfMonth(TODAY())" in a cell and it should work

ciao -- Nando

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users