IDEAS home Printed from https://ideas.repec.org/h/wsi/wschap/9789811202391_0084.html
   My bibliography  Save this book chapter

Decision Tree and Microsoft Excel Approach for Option Pricing Model

In: HANDBOOK OF FINANCIAL ECONOMETRICS, MATHEMATICS, STATISTICS, AND MACHINE LEARNING

Author

Listed:
  • Jow-Ran Chang
  • John Lee

Abstract

In this chapter, we (i) use the decision-tree approach to derive binomial option pricing model (OPM) in terms of the method used by Rendleman and Barter (RB, 1979) and Cox et al. (CRR, 1979) and (ii) use Microsoft Excel to show how decision-tree model can be converted to Black–Scholes model when the number period increases to infinity. In addition, we develop binomial tree model for American option and trinomial tree model. The efficiency of binomial and trinomial tree methods is also compared. In sum, this chapter shows how binomial OPM can be converted step by step to Black–Scholes OPM.

Suggested Citation

  • Jow-Ran Chang & John Lee, 2020. "Decision Tree and Microsoft Excel Approach for Option Pricing Model," World Scientific Book Chapters, in: Cheng Few Lee & John C Lee (ed.), HANDBOOK OF FINANCIAL ECONOMETRICS, MATHEMATICS, STATISTICS, AND MACHINE LEARNING, chapter 84, pages 2885-2927, World Scientific Publishing Co. Pte. Ltd..
    • Handle: RePEc:wsi:wschap:9789811202391_0084
    as

    Download full text from publisher

    File URL: https://www.worldscientific.com/doi/pdf/10.1142/9789811202391_0084
    Download Restriction: Ebook Access is available upon purchase.
    File URL: https://www.worldscientific.com/doi/abs/10.1142/9789811202391_0084
    Download Restriction: Ebook Access is available upon purchase.
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    More about this item

    Keywords

    Financial Econometrics; Financial Mathematics; Financial Statistics; Financial Technology; Machine Learning; Covariance Regression; Cluster Effect; Option Bound; Dynamic Capital Budgeting; Big Data;
    All these keywords.

    JEL classification:

    • C01 - Mathematical and Quantitative Methods - - General - - - Econometrics
    • C1 - Mathematical and Quantitative Methods - - Econometric and Statistical Methods and Methodology: General
    • G32 - Financial Economics - - Corporate Finance and Governance - - - Financing Policy; Financial Risk and Risk Management; Capital and Ownership Structure; Value of Firms; Goodwill

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:wsi:wschap:9789811202391_0084. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Tai Tone Lim (email available below). General contact details of provider: http://www.worldscientific.com/page/worldscibooks .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.