Re: OhPack function

Posted by Ferdinando M. Ametrano-3 on
URL: http://quantlib.414.s1.nabble.com/OhPack-function-tp8215p8217.html

On Wed, May 12, 2010 at 2:51 PM, stefano sampietro
<[hidden email]> wrote:
> Hi, I've a question about filtering null values in a vector. OhPack funcion works if the null values are in the bottom part of the vector: can quantlibXL handle the more general case of null values in arbitrary positions? (e.g. [1,2,#N/A,4]?

The rational behind ohPack is that you might have an array formula
result which is smaller than the function's Excel range.
If you want that range to be an input to another function you have to
trim #N/A at the bottom and on the right.

What do you want is different, and it is not available yet

ciao -- Nando

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

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users