simple question with Excel add in

Posted by Xavier.Abulker on
URL: http://quantlib.414.s1.nabble.com/simple-question-with-Excel-add-in-tp2813.html




Hello QuantLib,

One very simple question with the Excel Add-Ins,

I want to calculate the greeks (delta, vega) of a simple EuropeanOption.
In Excel, I go in "Insert" "Function", then I choose
"=qlEuropeanOption(E4;F4;G4;H4;I4;J4;K4;L4)" in a cell.
this only calculate the price of the European Option, how do you calculate
the delta for example?
I saw in the  sample file europeangreeks.xls that it's possible but I know
how.

thank you for your help

Xavier


*************************************************************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration.
La FIMAT et ses filiales declinent toute responsabilite au titre de ce
message s'il a ete altere, deforme ou falsifie.
                                          ********
This message and any attachments (the "message") are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
E-mails are susceptible to alteration.
Neither FIMATnor any of its subsidiaries or affiliates shall be liable for
the message if altered, changed or falsified.