Re: suggested improvement to the quantlib exceladdin <erfolgreich auf Virenfreiheit geprueft>

Posted by Simon Ibbotson on
URL: http://quantlib.414.s1.nabble.com/suggested-improvement-to-the-quantlib-excel-addin-tp8240p8245.html

Hi all,

A possible enhancement would be to be able to get a list of Excel references from QuantLib for objects that are uncalculated. Then a macro could overwrite the F9 function in Excel to
A) Calculate Excel.
B) Get a list of object cell references from QLXL for objects that are now uncalculated (using the QuantLib calculation tree of Observer / Observable).
C) Set those cells to "dirty" using Range.Dirty function.
D) Calculate Excel again.

Has anyone tried this?

Cheers,
Simon


Sent from my BlackBerry® wireless device

-----Original Message-----
From: P Nelnik <[hidden email]>
Date: Thu, 6 May 2010 16:08:58
To: Peter Caspers<[hidden email]>
Cc: Ferdinando Ametrano<[hidden email]>; <[hidden email]>
Subject: Re: [Quantlib-users] suggested improvement to the quantlib excel
        addin <erfolgreich auf Virenfreiheit geprueft>

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

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