Excel implementation of finite difference methods for option pricing

Research output: Contribution to journalArticle

963 Downloads (Pure)

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 languageEnglish
Article number2
Pages (from-to)2-1-2-33
Number of pages33
JournalSpreadsheets in education
Volume9
Issue number3
Publication statusPublished - 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