QuantLib › quantlib-users

Re: QuantlibXL: Automatically store objects whileopening a spreadsheet

classic Classic list List threaded Threaded
♦
♦
 3 messages Options
FORNAROLA CHIARA
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: QuantlibXL: Automatically store objects whileopening a spreadsheet

FORNAROLA CHIARA
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
Lapin
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: QuantlibXL: Automatically store objects whileopening a spreadsheet

Lapin
Thanks Chiara,

I will test this way.
I will update if there is any issue.

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: quantlib-users-bounces@lists.sourceforge.net
[mailto:quantlib-users-
>bounces@lists.sourceforge.net] On Behalf Of Yomi
>Sent: Monday, July 23, 2007 5:20 PM
>To: quantlib-users@lists.sourceforge.net
>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
>QuantLib-users@lists.sourceforge.net
>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
QuantLib-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Lapin
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: QuantlibXL: Automatically store objects whileopening a spreadsheet

Lapin
In reply to this post by FORNAROLA CHIARA
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: quantlib-users-bounces@lists.sourceforge.net
[mailto:quantlib-users-
>bounces@lists.sourceforge.net] On Behalf Of Yomi
>Sent: Monday, July 23, 2007 5:20 PM
>To: quantlib-users@lists.sourceforge.net
>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
>QuantLib-users@lists.sourceforge.net
>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
QuantLib-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Free forum by Nabble Edit this page