Posted by
Eric Ehlers-2 on
URL: http://quantlib.414.s1.nabble.com/question-regarding-ohObjectPropertyValues-tp8600p8601.html
Hello,
Quoting Kaifeng Chen <
[hidden email]>:
> Hi guys,
>
> This may sound stupid to you as I just started using QuantLibXL in excel. I
> created a range object using ohRange("test", 1), but how can I display the
> data in the test object? if I do
> ohObjectPropertyValues("test#0001","Values"), it only returns <VECTOR>
> instead of the actual value. Am I missing something here? Thank you very
> much.
You're not missing anything. ohObjectPropertyValues only supports
scalar values and simply returns "<VECTOR>" for a vector. That whole
"object property" feature is not used very much.
Instead, most specific types have dedicated functions which return
vector properties where necessary. For example, spreadsheet
Workbooks\StandaloneExamples\YieldTermStructures.xls, range
=[YieldTermStructures.xls]Sheet1!$I$8:$I$28, you can see that function
qlInterpolatedYieldCurveData is used to display a vector property from
the object of type InterpolatedYieldCurve constructed in cell
=[YieldTermStructures.xls]Sheet1!$D$5.
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats.
http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users