Re: [Quantlib-dev] QuantLib Excel project

[Lassauzet <al...@la...>]

Hi Eric,

Thanks for your help. 

To keep you informed, I managed to compile the addin from your repository using the latest version of Quantlib, available on Luigi’s repository (I just had to fix minor pieces of code in some XML files to make it working). In addition, working exclusively with python 3.x, I also had to translate some files in the gensrc project (just the one that was needed for the compilation, not the whole project) and it worked...at least for the generation of the 32 bit xll (I managed to load it and run it on a colleague’s machine working with Excel O365 32 bit).

Indeed, when I tried to compile the addin in « release (static runtime) » mode + « x64 », the very last stage of the compilation routine (the compilation of QuantLibObjects project in fact) never stops and seems to generate a temporary xll file with an anormal size (~2MB vs 23MB in 32 bit). I even let it run overnight, but it did not reach the end...

FYI, I am working with Win 10 (64 bit), VS express 2013, Python 3.7.3 (32 bit), Excel for Office365 64 bit. I am using the solution « QuantLibXL_full_vc12.sln ». I also tried to compile the project using VS2019 but I am facing other issues (VS compatibility I think). Have you ever faced this kind of issues ?

Thanks,

Alix


Sent from my iPhone

> Le 23 mai 2019 à 11:19, Eric Ehlers <eri...@re...> a écrit :
> 
> Hi Alix,
> 
> With the new design I managed to implement ~80% of the ~1,000 functions that QuantLibXL supports.  I worked on it during a period of unemployment but unfortunately someone came along and gave me a job before I could finish it.  I don't know if or when I will ever get back to it.
> 
> Regards,
> Eric
> 
>> On 20/05/2019 09:35, ALIX LASSAUZET wrote:
>> Thanks a lot Eric, will try to use this starting point instead. Any plan for the use of this new design? Is it in the pipe?
>> Best regards,
>> Alix
>> Le dim. 19 mai 2019 à 14:09, Eric Ehlers <eri...@re... <mailto:eri...@re...>> a écrit :
>>    Hi Alix,
>>    I am still here, although I'm afraid I'm long overdue releasing
>>    QuantLibXL 1.15.
>>    There are two builds of QuantLibXL, the original design, which is in
>>    production (up until version 1.14), and a new design using SWIG.
>>    You are looking at the repos for the new build, which was never
>>    released.  The old build relies on just one repo:
>>    https://github.com/eehlers/QuantLibAddin-Old.git
>>    That corresponds to the zip files for the public release of 1.14.
>>    Kind Regards,
>>    Eric
>>    On 19/05/2019 13:05, ALIX LASSAUZET wrote:
>>     > Hi QL-community,
>>     >
>>     > I would like to know what is the best way to contribute to QuantLib
>>     > Excel project.
>>     > Until now, I managed to install QuantLibXL from the source code,
>>     > following instructions available on the official website
>>     > (https://www.quantlib.org/quantlibaddin/build_qlxl.html). But this
>>     > installation starts from the download of the associated zip
>>    files, and
>>     > not from git repositories. I saw that Eric Ehlers was actively
>>    working
>>     > on several repositories related to this (maybe a new way to
>>    compile the
>>     > xll using swig? - https://github.com/eehlers?tab=repositories),
>>    but I
>>     > have no idea which one could be used and if it is the right way to
>>     > compile it despite the fact there are many project dependencies
>>     > (reposit, ql addin, ql xl, gensrc, ...).
>>     >
>>     > Could you please advice?
>>     >
>>     > Thanks,
>>     > Alix
>>     >
>>     >
>>     >
>>     >
>>     > _______________________________________________
>>     > QuantLib-dev mailing list
>>     > Qua...@li...
>>    <mailto:Qua...@li...>
>>     > https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>>     >