Open Access. Powered by Scholars. Published by Universities.®
Physical Sciences and Mathematics Commons™
Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 1 of 1
Full-Text Articles in Physical Sciences and Mathematics
Visualizing The Stochastic Calculus Of Option Pricing With Excel And Vba, Tom Arnold, Stephen C. Henry
Visualizing The Stochastic Calculus Of Option Pricing With Excel And Vba, Tom Arnold, Stephen C. Henry
Finance Faculty Publications
Stochastic calculus, part calculus and part statistics, is an integral part of option pricing that can be intimidating. By developing the statistical nature of stochastic processes and introducing Monte Carlo simulation using Microsoft Excel, this paper develops a visualization of how stochastic processes are evaluated using Ito's lemma and integral calculus. Ultimately, the Black-Scholes (1973) option pricing equation is the natural result.