Re: QuantlibXL: Automatically store objectswhileopening a spreadsheet

[FORNAROLA CHIARA]

Hi Yomi
If you create a yield curve object and let the Quotefeed file opened, so
that the market data is updated, also the yield curve is updated.

Chiara

>-----Original Message-----
>From: [hidden email]
[mailto:quantlib-users-

>[hidden email]] On Behalf Of Yomi
>Sent: Monday, July 23, 2007 7:38 PM
>To: [hidden email]
>Subject: Re: [Quantlib-users] QuantlibXL: Automatically store
>objectswhileopening a spreadsheet
>
>
>Chiara,
>
>It is working fine now.
>
>Just a quick question:
>
>When I update my quote feed, does it bootstrap automatically the Zero

curve

>in the memory (using qlPiecewiseYieldCurve)?
>As of now it is not updated in XL gui, so I am not sure of the
>functionality?
>
>Kind regards
>
>
>FORNAROLA CHIARA wrote:
>>
>> Hi Yomi,
>>
>> Are you using a trigger to generate the quote's object?
>> The way is to create an object ID for each of your quotes,which can

be

>> permanent, and triggered.
>> Then you can create a macro which open the workbooks "Quotes" and
>> trigger the Object IDs, and finally opens the workbook "Quotefeed".
>>
>> Hope this will help.
>>
>> Chiara
>>
>>
>>>-----Original Message-----
>>>From: [hidden email]
>> [mailto:quantlib-users-
>>>[hidden email]] On Behalf Of Yomi
>>>Sent: Monday, July 23, 2007 5:20 PM
>>>To: [hidden email]
>>>Subject: [Quantlib-users] QuantlibXL: Automatically store objects
>>>whileopening a spreadsheet
>>>
>>>
>>>Hi,
>>>
>>>I am trying to do the same this that has been done in the
>> framework.xla:
>>>
>>>1- open a workbook for the Quotes
>>>2- Close it (with or without calculate it does not sole the issue)
>>>3- open a workbook for the Quotefeed
>>>
>>>At this moment, the ObjectID that were supposed to be created in the
>> Quote
>>>workbook do not exist.
>>>To make it work, I have to open the Quote workbook and to do

F2-Return

>> on
>>>every cells that contain the ObjectID.
>>>
>>>Does anybody know how to do this step automatically?
>>>
>>>Thaks
>>>--
>>>View this message in context: http://www.nabble.com/QuantlibXL%3A-
>>>Automatically-store-objects-while-opening-a-spreadsheet-
>>>tf4130525.html#a11746660
>>>Sent from the quantlib-users mailing list archive at Nabble.com.
>>>
>>>
>>>---------------------------------------------------------------------

--
>> --
>>>This SF.net email is sponsored by: Splunk Inc.
>>>Still grepping through log files to find problems?  Stop.
>>>Now Search log events and configuration files using AJAX and a
browser.
>>>Download your FREE copy of Splunk now >>  http://get.splunk.com/
>>>_______________________________________________
>>>QuantLib-users mailing list
>>>[hidden email]
>>>https://lists.sourceforge.net/lists/listinfo/quantlib-users
>>
>>
------------------------------------------------------------------------
-
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a
browser.

>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> _______________________________________________
>> QuantLib-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>>
>>
>
>--
>View this message in context:

http://www.nabble.com/Re%3A-QuantlibXL%3A-
>Automatically-store-objects-whileopening-a-spreadsheet-
>tf4130873.html#a11749028
>Sent from the quantlib-users mailing list archive at Nabble.com.
>
>
>-----------------------------------------------------------------------
--
>This SF.net email is sponsored by: Splunk Inc.
>Still grepping through log files to find problems?  Stop.
>Now Search log events and configuration files using AJAX and a browser.
>Download your FREE copy of Splunk now >>  http://get.splunk.com/
>_______________________________________________
>QuantLib-users mailing list
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/quantlib-users

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users