Programmes de volatilité stochastique et de volatilité implicite : applications Visual Basic (Excel) et Matlab
AbstractMarkets makers quote many option categories in terms of implicit volatility. In doing so, they can reactivate the Black and Scholes model which assumes that the volatility of an option underlying is constant while it is highly variable. First of all, this article, whose purpose is very empirical, presents a simulation of stochastic volatility programmed in Visual Basic (Excel) whose aim is to compute the price of an European option written on a zero coupon bond. We compare this computed price with this one resulting from Black analytical solution and we also show how to compute an interest rate forecast with the help of the simulation model. Then we write many Visual Basic and Matlab programs for the purpose of computing the implicit volatility surface, a three-dimensional surface which can be plotted by using graphical capacities of Excel and Matlab. It remains that the concept of implicit volatility is very criticised because it is computed with the exercise price of an option and not with the price of the underlying, as it should be. Therefore, there are biases in the estimation of the «greeks» computed with implicit volatility.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoPaper provided by Département des sciences administratives, UQO in its series RePAd Working Paper Series with number UQO-DSA-wp012007.
Length: 23 pages
Date of creation: 01 Jan 2007
Date of revision:
Contact details of provider:
Postal: Pavillon Lucien Brault, 101 rue Saint Jean-Bosco, Gatineau (Québec) J8Y 3G5
Phone: (819) 595-3900
Fax: (819) 773-1747
Web page: http://www.repad.org/
More information through EDIRC
Financial engineering; Monte Carlo simulation; stochastic volatility; implicit volatility.;
Find related papers by JEL classification:
- G12 - Financial Economics - - General Financial Markets - - - Asset Pricing; Trading Volume; Bond Interest Rates
- G13 - Financial Economics - - General Financial Markets - - - Contingent Pricing; Futures Pricing
- G33 - Financial Economics - - Corporate Finance and Governance - - - Bankruptcy; Liquidation
This paper has been announced in the following NEP Reports:
- NEP-ALL-2007-01-28 (All new papers)
- NEP-BEC-2007-01-28 (Business Economics)
- NEP-CMP-2007-01-28 (Computational Economics)
- NEP-FOR-2007-01-28 (Forecasting)
You can help add them by filling out this form.
reading list or among the top items on IDEAS.Access and download statisticsgeneral information about how to correct material in RePEc.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Christian Calmes).
If references are entirely missing, you can add them using this form.