QuantLibXL – A Curvy Way to fit a Yield Curve

QuantLib is a magnificent library for quantitative finance. But it is also like a gun, heavy enough to shoot your own foot. You might expect that QuantLibXL (a plug-in that provides a subset of QuantLib functionality in Excel) makes your life easier. Unfortunately, it hardly does, as we show in this case study. For an easy and straight way you should better have a look at Deriscope. Continue reading "QuantLibXL – A Curvy Way to fit a Yield Curve"

Building QuantLibXL in Visual Studio 2017

QuantLibXL (Excel QuantLibAddin) provides a [limited subset of] QuantLib functionality directly in Excel. However, its development follows the development of QuantLib with a lag, e.g. currently the last modified date in project repository is 2017-05-02. I tried to build QuantLibXL with currently latest version of the Visual Studio (success) and to bind it to the latest version of QuantLib (no way).
Continue reading "Building QuantLibXL in Visual Studio 2017"