Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel is likely the most widespread instrument across all not-only-quants desks; in addition, we have to keep in mind that Bloomberg and Reuters allow to easily import real time data in Excel, and this is very handy.

Due to these features, I'm wondering what's the easiest and most reliable solution to use QuantLib in Excel.

So far, these are the ways I know:

Each one has its pros and con's, I must admit QuantLibXL is harder than I thought before; being quite able to code with R, so far my favorite solution is the second one.

If anyone knows any better solution and/or a good step-by-step tutorial for QuantLibXL (something which explains how to deal easily with "classes" in a spreadsheet), it would be really appreciated if he could write it here.

share|improve this question
From an abstract point of view, there is no definite answer to the question: the solution you should choose depends on your knowledge of the different programming languages and on other details of your personal situation. – SRKX Aug 29 '13 at 8:04

A free to use Excel Add-on providing QuantLib-backed derivatives pricing analytics directly in Excel is available at http://www.deriscope.com

Disclosure: answerer is author of the package.

share|improve this answer
Hi Yannis, welcome to quant.SE! Please disclose your involvement with deriscope.com and please provide some relevant information on why this add-on is a good choice. – Bob Jansen Jul 29 '14 at 15:23
Hi Bob. I have been developing Deriscope actually for my own needs, but I feel it may be of interest to others as well. – Yannis Jul 30 '14 at 3:46
It's an Excel add-in that aims to bring QuantLib closer to non-programmers. At its current version it only handles options (equity, index, fx), but it caters the full range of 34 modelling approaches available in QuantLib. Its main strength is algorithmic transparency and context-based help unseen in any other application. Its main drawback is it is still at its infancy in the sense it only covers options. I hope I will be able to supply the whole QuantLib capabilities soon. – Yannis Jul 30 '14 at 3:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.