QuantLibXL Question: Picking Off or Displaying Individual Dates from Vector Produced by qlScheduleDates()

[Peter C. Stockman]

I want to display all the dates that returned from qlScheduleDates() but cannot figure out what sort of thing is returned by the QuantLibXL function

B39 contains the schedule object.

QlScheduleSize($B$39) returns 365, as expected

D39 contains = qlScheduleDates($B$39)

Excel function ISREF($D$39) returns a value of TRUE

Excel function COLUMSN($D$39) returns 1 and Excel function ROWS($D$) returns 1, as well.  What is the dimensionality of this vector?

INDEX($D$39, row, column) returns REF errors whenever row and column are not 1,1

How do I display or pick off individual values of the vector of dates which qlScheduleDates() returns?



Peter


--
Peter C. Stockman
[phone] (Office & Voicemail)
[phone] (Cell)
peter.c.stockman@...
www.deeprivergroup.com

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Ferdinando Ametrano-4]

On Mon, Mar 2, 2009 at 2:44 AM, Peter C. Stockman
<[hidden email]> wrote:
>
> I want to display all the dates that returned from qlScheduleDates() but cannot
> figure out what sort of thing is returned by the QuantLibXL function

qlScheduleDates returns a vector, so you should enter it as array
function using CTRL+SHIFT+ENTER over an array of cells.

ciao -- Nando

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Peter C. Stockman]

Nando:

Ah....yes.  Doing it over an array of cells works.

Thanks much.

Peter

On 3/2/09 4:25 AM, "Ferdinando Ametrano" <qf@...> wrote:

On Mon, Mar 2, 2009 at 2:44 AM, Peter C. Stockman
<peter.c.stockman@...> wrote:
>
> I want to display all the dates that returned from qlScheduleDates() but cannot
> figure out what sort of thing is returned by the QuantLibXL function

qlScheduleDates returns a vector, so you should enter it as array
function using CTRL+SHIFT+ENTER over an array of cells.

ciao -- Nando

--
Peter C. Stockman
[phone] (Office & Voicemail)
[phone] (Cell)
peter.c.stockman@...
www.deeprivergroup.com

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users