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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Bibliography
Benninga S (2000) Financial modeling. MIT Press, Cambridge
Benninga S (2008) Financial modeling. MIT Press, Cambridge
Black F, Scholes M (1973) The pricing of options and corporate liabilities. J Polit Econ 31:637–659
Cox J, Ross SA, Rubinstein M (1979) Option pricing: a simplified approach. J Financ Econ 7:229–263
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–1652
Lee CF, Lee AC, Lee J (2010) Handbook of quantitative finance and risk management. Springer, New York
Lee CF, Lee AC (2013) Encyclopedia of finance, 2nd edn. Springer, New York
Lee CF, Lee JC, Lee AC (2000) Statistics for business and financial economics, 3rd edn. Springer, New York
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–295
Lee CF, Tsai CM, Lee AC (2013) Asset pricing with disequilibrium price adjustment: theory and empirical evidence. Quant Finance 13(2):227–240
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–346
Lo AW, Wang J (2000) Trading volume: definition, data analysis, and implications of portfolio theory. Rev Financ Stud 13:257–300
Rendleman RJ Jr, Barter BJ (1979) Two-state option pricing. J Finance 34(5):1093–1110
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
Author information
Authors and Affiliations
Appendix 25.1: Excel Code—Binomial Option Pricing Model
Appendix 25.1: Excel Code—Binomial Option Pricing Model
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Lee, CF., Lee, J., Chang, JR., Tai, T. (2016). Binomial Option Pricing Model Decision Tree Approach. In: Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses. Springer, Cham. https://doi.org/10.1007/978-3-319-38867-0_25
Download citation
DOI: https://doi.org/10.1007/978-3-319-38867-0_25
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-38865-6
Online ISBN: 978-3-319-38867-0
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)