Re: Some questions about forcing recalculation

Posted by Andrew Kolesnikov on
URL: http://quantlib.414.s1.nabble.com/Some-questions-about-forcing-recalculation-tp12208p12212.html

Hello Eric,
thank you for participation

"Please review the documentation below:

    http://www.objecthandler.org/references.html
    http://www.quantlibaddin.org/observer.html"

I could say, that i'm a big fan of QL, so of course i've already read all useful articles :)

About your example:

"the object can be identified by the raw (literal) string "my_obj" - not "my_obj#001" and not a reference to the range in the closed Book1.xls from which the object was constructed"

- that's the way i work with QLXL functions, but when the object is updated (by user or by external data), how could we force recalculation of dependency functions (such as qlYieldTSZeroRate, etc.)?! You see, Excel recalculates UDF only in case of arguments change, but all arguments are still the same (so if you hit F9 nothing will be changed)! One way to solve this problem - to use trigger parameter, but itsn't convinient (see my previous topic). So, are there another decisions?