QuantLib › quantlib-dev

Excel interface

Classic

List

Threaded

7 messages Options

Grześ Andruszkiewicz

Excel interface

Hi,

I would like to use the instrument I developed in QuantLib in Excel. I
was looking at the QuantLibXL project, but it is not obvious how to
use it nor extend it. Also, I haven't actually used the Excel add-in
even with the standard instruments...

1). Where can I find a tutorial to see how to use the existing add-in,
run the example workbooks, etc.?
2). Is there any documentation on how to add new stuff to the project?

I would be grateful for any other hints.

Regards,
Grzegorz

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

japari

Re: Excel interface

Hi,
did you look at these ones?
http://quantlib.org/quantlibaddin/extend_tutorial.html
http://quantlib.org/quantlibaddin/extend_template_tutorial.html

Also theres the QLXL-docs coming along the release.

I learned also by starting with simple classes and reverse eng/debugging the thing. Its not as bad as it sounds.

Best
pp

----- Original Message -----
From: "Grześ Andruszkiewicz" <[hidden email]>
To: [hidden email]
Cc: "Lorenzo Pitotti" <[hidden email]>
Sent: Friday, 12 April, 2013 5:08:41 PM
Subject: [Quantlib-dev] Excel interface

Hi,

I would like to use the instrument I developed in QuantLib in Excel. I
was looking at the QuantLibXL project, but it is not obvious how to
use it nor extend it. Also, I haven't actually used the Excel add-in
even with the standard instruments...

1). Where can I find a tutorial to see how to use the existing add-in,
run the example workbooks, etc.?
2). Is there any documentation on how to add new stuff to the project?

I would be grateful for any other hints.

Regards,
Grzegorz

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Grześ Andruszkiewicz

Re: Excel interface

Thanks! I haven't actually seen these before!

After having a quick look: is it possible to extend the Excel
interface by creating a new project rather than extending the main
one?

Regards,
Grzegorz

On 12 April 2013 16:28, <[hidden email]> wrote:

> Hi,
> did you look at these ones?
> http://quantlib.org/quantlibaddin/extend_tutorial.html
> http://quantlib.org/quantlibaddin/extend_template_tutorial.html
>
> Also theres the QLXL-docs coming along the release.
>
> I learned also by starting with simple classes and reverse eng/debugging the thing. Its not as bad as it sounds.
>
> Best
> pp
>
>
> ----- Original Message -----
> From: "Grześ Andruszkiewicz" <[hidden email]>
> To: [hidden email]
> Cc: "Lorenzo Pitotti" <[hidden email]>
> Sent: Friday, 12 April, 2013 5:08:41 PM
> Subject: [Quantlib-dev] Excel interface
>
> Hi,
>
> I would like to use the instrument I developed in QuantLib in Excel. I
> was looking at the QuantLibXL project, but it is not obvious how to
> use it nor extend it. Also, I haven't actually used the Excel add-in
> even with the standard instruments...
>
> 1). Where can I find a tutorial to see how to use the existing add-in,
> run the example workbooks, etc.?
> 2). Is there any documentation on how to add new stuff to the project?
>
> I would be grateful for any other hints.
>
> Regards,
> Grzegorz
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> QuantLib-dev mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-dev

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

japari

Re: Excel interface

At which level do you want to create a new project? It consist of several ones; one dependent on the previous (the log tools, the serialization, the excel objects, etc..) QLXL itself is already linked and ready to roll.
If what you want is a lighter add-in you might want to replicate another one with less interface, removing the generated functions, that is going to give you a bit of work and headaches (dependencies)....
If what you want is to separate your work put it into separate XML and qlo-project files. Then remember to add the generated files into the QLXL project. It is a complex project, I would recomend to start playing around with simple things and debugging the sample workbooks.

I am not sure this answers your question. And definitely I am not the local expert so take my waffle with a pinch of salt.

Best
pp

PS You guys are at IC?

----- Original Message -----
From: "Grześ Andruszkiewicz" <[hidden email]>
To: [hidden email]
Cc: "Lorenzo Pitotti" <[hidden email]>, [hidden email]
Sent: Friday, 12 April, 2013 5:47:05 PM
Subject: Re: [Quantlib-dev] Excel interface

Thanks! I haven't actually seen these before!

After having a quick look: is it possible to extend the Excel
interface by creating a new project rather than extending the main
one?

Regards,
Grzegorz

On 12 April 2013 16:28, <[hidden email]> wrote:

Luigi Ballabio

Re: Excel interface

In reply to this post by Grześ Andruszkiewicz

Hi Grzegorz,
for the addin we use in-house, we ended up extending the existing
project. We tried creating a new project, but it caused us a lot of
headaches.

Luigi

On Fri, Apr 12, 2013 at 5:47 PM, Grześ Andruszkiewicz
<[hidden email]> wrote:

> Thanks! I haven't actually seen these before!
>
> After having a quick look: is it possible to extend the Excel
> interface by creating a new project rather than extending the main
> one?
>
> Regards,
> Grzegorz
>
> On 12 April 2013 16:28, <[hidden email]> wrote:
>> Hi,
>> did you look at these ones?
>> http://quantlib.org/quantlibaddin/extend_tutorial.html
>> http://quantlib.org/quantlibaddin/extend_template_tutorial.html
>>
>> Also theres the QLXL-docs coming along the release.
>>
>> I learned also by starting with simple classes and reverse eng/debugging the thing. Its not as bad as it sounds.
>>
>> Best
>> pp
>>
>>
>> ----- Original Message -----
>> From: "Grześ Andruszkiewicz" <[hidden email]>
>> To: [hidden email]
>> Cc: "Lorenzo Pitotti" <[hidden email]>
>> Sent: Friday, 12 April, 2013 5:08:41 PM
>> Subject: [Quantlib-dev] Excel interface
>>
>> Hi,
>>
>> I would like to use the instrument I developed in QuantLib in Excel. I
>> was looking at the QuantLibXL project, but it is not obvious how to
>> use it nor extend it. Also, I haven't actually used the Excel add-in
>> even with the standard instruments...
>>
>> 1). Where can I find a tutorial to see how to use the existing add-in,
>> run the example workbooks, etc.?
>> 2). Is there any documentation on how to add new stuff to the project?
>>
>> I would be grateful for any other hints.
>>
>> Regards,
>> Grzegorz
>>
>> ------------------------------------------------------------------------------
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> _______________________________________________
>> QuantLib-dev mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> QuantLib-dev mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-dev

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Grześ Andruszkiewicz

Re: Excel interface

Hi Luigi,

I am doing just that at this very moment :).

Also, I submitted a patch with the actual code to source forge earlier
today, I hope you received the notification.

Cheers,
Grzegorz

On 2 May 2013 15:15, Luigi Ballabio <[hidden email]> wrote:

> Hi Grzegorz,
> for the addin we use in-house, we ended up extending the existing
> project. We tried creating a new project, but it caused us a lot of
> headaches.
>
> Luigi
>
> On Fri, Apr 12, 2013 at 5:47 PM, Grześ Andruszkiewicz
> <[hidden email]> wrote:
>> Thanks! I haven't actually seen these before!
>>
>> After having a quick look: is it possible to extend the Excel
>> interface by creating a new project rather than extending the main
>> one?
>>
>> Regards,
>> Grzegorz
>>
>> On 12 April 2013 16:28, <[hidden email]> wrote:
>>> Hi,
>>> did you look at these ones?
>>> http://quantlib.org/quantlibaddin/extend_tutorial.html
>>> http://quantlib.org/quantlibaddin/extend_template_tutorial.html
>>>
>>> Also theres the QLXL-docs coming along the release.
>>>
>>> I learned also by starting with simple classes and reverse eng/debugging the thing. Its not as bad as it sounds.
>>>
>>> Best
>>> pp
>>>
>>>
>>> ----- Original Message -----
>>> From: "Grześ Andruszkiewicz" <[hidden email]>
>>> To: [hidden email]
>>> Cc: "Lorenzo Pitotti" <[hidden email]>
>>> Sent: Friday, 12 April, 2013 5:08:41 PM
>>> Subject: [Quantlib-dev] Excel interface
>>>
>>> Hi,
>>>
>>> I would like to use the instrument I developed in QuantLib in Excel. I
>>> was looking at the QuantLibXL project, but it is not obvious how to
>>> use it nor extend it. Also, I haven't actually used the Excel add-in
>>> even with the standard instruments...
>>>
>>> 1). Where can I find a tutorial to see how to use the existing add-in,
>>> run the example workbooks, etc.?
>>> 2). Is there any documentation on how to add new stuff to the project?
>>>
>>> I would be grateful for any other hints.
>>>
>>> Regards,
>>> Grzegorz
>>>
>>> ------------------------------------------------------------------------------
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> _______________________________________________
>>> QuantLib-dev mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>>
>> ------------------------------------------------------------------------------
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> _______________________________________________
>> QuantLib-dev mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Luigi Ballabio

Re: Excel interface

Not yet, but I think notifications might be sent out daily or
something. Thanks, I'll have a look.

Later,
Luigi

On Thu, May 2, 2013 at 4:18 PM, Grześ Andruszkiewicz <[hidden email]> wrote:

> Hi Luigi,
>
> I am doing just that at this very moment :).
>
> Also, I submitted a patch with the actual code to source forge earlier
> today, I hope you received the notification.
>
> Cheers,
> Grzegorz
>
> On 2 May 2013 15:15, Luigi Ballabio <[hidden email]> wrote:
>> Hi Grzegorz,
>> for the addin we use in-house, we ended up extending the existing
>> project. We tried creating a new project, but it caused us a lot of
>> headaches.
>>
>> Luigi
>>
>> On Fri, Apr 12, 2013 at 5:47 PM, Grześ Andruszkiewicz
>> <[hidden email]> wrote:
>>> Thanks! I haven't actually seen these before!
>>>
>>> After having a quick look: is it possible to extend the Excel
>>> interface by creating a new project rather than extending the main
>>> one?
>>>
>>> Regards,
>>> Grzegorz
>>>
>>> On 12 April 2013 16:28, <[hidden email]> wrote:
>>>> Hi,
>>>> did you look at these ones?
>>>> http://quantlib.org/quantlibaddin/extend_tutorial.html
>>>> http://quantlib.org/quantlibaddin/extend_template_tutorial.html
>>>>
>>>> Also theres the QLXL-docs coming along the release.
>>>>
>>>> I learned also by starting with simple classes and reverse eng/debugging the thing. Its not as bad as it sounds.
>>>>
>>>> Best
>>>> pp
>>>>
>>>>
>>>> ----- Original Message -----
>>>> From: "Grześ Andruszkiewicz" <[hidden email]>
>>>> To: [hidden email]
>>>> Cc: "Lorenzo Pitotti" <[hidden email]>
>>>> Sent: Friday, 12 April, 2013 5:08:41 PM
>>>> Subject: [Quantlib-dev] Excel interface
>>>>
>>>> Hi,
>>>>
>>>> I would like to use the instrument I developed in QuantLib in Excel. I
>>>> was looking at the QuantLibXL project, but it is not obvious how to
>>>> use it nor extend it. Also, I haven't actually used the Excel add-in
>>>> even with the standard instruments...
>>>>
>>>> 1). Where can I find a tutorial to see how to use the existing add-in,
>>>> run the example workbooks, etc.?
>>>> 2). Is there any documentation on how to add new stuff to the project?
>>>>
>>>> I would be grateful for any other hints.
>>>>
>>>> Regards,
>>>> Grzegorz
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Precog is a next-generation analytics platform capable of advanced
>>>> analytics on semi-structured data. The platform includes APIs for building
>>>> apps and a phenomenal toolset for data science. Developers can use
>>>> our toolset for easy data analysis & visualization. Get a free account!
>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>>> _______________________________________________
>>>> QuantLib-dev mailing list
>>>> [hidden email]
>>>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>>>
>>> ------------------------------------------------------------------------------
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> _______________________________________________
>>> QuantLib-dev mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev