Compiling QuantLib for Calc

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Compiling QuantLib for Calc

Iain
I want a way to take data in a Calc spreadsheet, pass it to QuantLib and do some processing, and then pass the results back to Calc and display them in in graphical form

I visited the site -- http://quantlib.org/quantlibaddin/faq.html
Found: Installation - How do I compile and/or install QuantLibAddin/QuantLibXL?

Went here -> http://quantlib.org/quantlibaddin/build_calc.html
But where is the file: QuantLibAddinCalc_vc7.sln?
There is an AddinCalc_vc7.vcproj - can I build using this?
I tried but got messages about a missing Makefile.vc (which seems to reside in the QuantLibAddin\gensrc folder)

I will then need to do the following for Calc --> (4.2) How do I call QuantLibXL functions from Excel VBA?

Thanks - and thanks for the hints about the Include and Library Directories previously.

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: Compiling QuantLib for Calc

Eric Ehlers-2
Hi Iain,

Quoting Iain <[hidden email]>:

> I want a way to take data in a Calc spreadsheet, pass it to QuantLib and do
> some processing, and then pass the results back to Calc and display them in
> in graphical form
>
> I visited the site -- http://quantlib.org/quantlibaddin/faq.html
> Found: Installation - How do I compile and/or install
> QuantLibAddin/QuantLibXL?
>
> Went here -> http://quantlib.org/quantlibaddin/build_calc.html
> But where is the file: QuantLibAddinCalc_vc7.sln?
> There is an AddinCalc_vc7.vcproj - can I build using this?
> I tried but got messages about a missing Makefile.vc (which seems to reside
> in the QuantLibAddin\gensrc folder)
>
> I will then need to do the following for Calc --> (4.2) How do I call
> QuantLibXL functions from Excel VBA?
>
> Thanks - and thanks for the hints about the Include and Library Directories
> previously.

I am afraid that the Calc addin is way out of date, I will update the  
web page to make that more obvious.  I had the addin working at one  
time but did not maintain it.  Then there was a change to the Calc  
architecture which changed the way addins are built.  I seem to  
remember somebody updating our Calc addin for that but I cannot  
remember whether that change got in to version control.  So really if  
you want to work with the Calc addin you would pretty much need to  
start from scratch.

QuantLibAddinCalc_vc7.sln is in the QuantLibAddin directory:

https://github.com/eehlers/quantlib/tree/master/QuantLibAddin

However in the upcoming release of 1.4 we are dropping support for VC7  
so that file will disappear.

Sorry that I could not be more helpful.

Kind Regards,
Eric
===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid


------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users