Abstract
This paper presents and explains finite difference methods for pricing options and shows how these methods may be implemented in Excel. We cover both the explicit and the implicit finite difference methods. Each uses a numerical approximation to the partial differential equation and boundary condition to convert the differential equation to a difference equation. The difference equation can be solved using Excel and this solution is a numerical approximation to the option price. This paper explains how we obtain the difference equation from the differential equation and shows the reader how to implement and solve the difference equation using Excel.
| Original language | English |
|---|---|
| Article number | 2 |
| Pages (from-to) | 2-1-2-33 |
| Number of pages | 33 |
| Journal | Spreadsheets in education |
| Volume | 9 |
| Issue number | 3 |
| Publication status | Published - 2016 |
Fingerprint
Bibliographical note
Version archived for private and non-commercial use with the permission of the author/s and according to publisher conditions. For further rights please contact the publisher.Keywords
- Option pricing
- Numerical methods
- Finite difference method
- Implicit scheme
- Explicit scheme
- Excel implementation
Cite this
Kyng, T., Purcal, S., & Zhang, J. C. (2016). Excel implementation of finite difference methods for option pricing. Spreadsheets in education, 9(3), 2-1-2-33. [2].