Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
Introduction Read chapter Read first chapter

2016 | OriginalPaper | Chapter

25. Binomial Option Pricing Model Decision Tree Approach

Authors : Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai

Published in: Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses

Publisher: Springer International Publishing

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Microsoft Excel is one of the most powerful and valuable tools available to the business users. The financial industry in New York City has recognized this value. We can see this by going to one of the many job sites on the Internet. Two Internet sites that demonstrate the value of someone who knows Microsoft Excel very well are www.dice.com and www.indeed.com. For both of these Internet sites, search for New York City and VBA, which is Microsoft Excel’s programming language, and you will see many job postings requiring VBA.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

inform now
previous chapter Professional Techniques Used in Excel and Excel VBA Techniques
next chapter Microsoft Excel Approach to Estimating Alternative Option Pricing Models
Appendix
Available only for authorised users
Literature
Benninga S (2000) Financial modeling. MIT Press, Cambridge
Benninga S (2008) Financial modeling. MIT Press, Cambridge
Cox J, Ross SA, Rubinstein M (1979) Option pricing: a simplified approach. J Financ Econ 7:229–263CrossRefMATH
Daigler RT (1994) Financial futures and options markets concepts and strategies. Harper Collins, New York
Jarrow R, Rudd A (1983) Option pricing. Irwin, Chicago
Jarrow R, TurnBull S (1996) Derivative securities. South-Western College, Cincinnati
Kamrad B, Ritchken P (1991) Multinomial approximating models for options with k state variables. Manage Sci 37:1640–1652CrossRefMATH
Lee CF, Lee AC, Lee J (2010) Handbook of quantitative finance and risk management. Springer, New YorkCrossRef
Lee CF, Lee JC, Lee AC (2000) Statistics for business and financial economics, 3rd edn. Springer, New YorkMATH
Lee JC, Lee CF, Wang RS, Lin TI (2004) On the limit properties of binomial and multinomial option pricing models: review and integration. In: Advances in quantitative analysis of finance and accounting, vol 1. World Scientific, Singapore, pp 271–295CrossRef
Lee CF, Tsai CM, Lee AC (2013) Asset pricing with disequilibrium price adjustment: theory and empirical evidence. Quant Finance 13(2):227–240MathSciNetCrossRefMATH
Lee JC (2001) Using Microsoft excel and decision trees to demonstrate the binomial option pricing model. Adv Invest Anal Portfolio Manage 8:303–329
Leisen DPJ, Reimer M (1996) Binomial models for option valuation—examining and improving convergence. Appl Math Finance 3(4):319–346CrossRef
Lo AW, Wang J (2000) Trading volume: definition, data analysis, and implications of portfolio theory. Rev Financ Stud 13:257–300CrossRef
Rendleman RJ Jr, Barter BJ (1979) Two-state option pricing. J Finance 34(5):1093–1110CrossRef
Wells E, Harshbarger S (1997) Microsoft Excel 97 developer’s handbook. Microsoft Press, Redmond
Walkenbach J (2003) Excel 2003 power programming with VBA. Wiley, Indianapolis
Metadata
Title
Binomial Option Pricing Model Decision Tree Approach
Authors
Cheng-Few Lee
John Lee
Jow-Ran Chang
Tzu Tai
Copyright Year
2016
Book
Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses

Print ISBN: 978-3-319-38865-6

Electronic ISBN: 978-3-319-38867-0

Copyright Year: 2016

DOI
https://doi.org/10.1007/978-3-319-38867-0_25