A practical demonstration of Ito's Lemma

One of the first things that you come across when reading any derivation of the Black-Scholes equation is the use of "Ito's Lemma". To me, it's even now quite an unintuitive thing to grasp... So I wrote up a spreadsheet that demonstrates that Ito's Lemma is true. It shows an example function of first a "normal" variable and of a stochastic "brownian motion" variable. It does not have any embedded macros and is safe to download. Try hitting F9 (recalc) on it a few times and you'll easily see that it works... so at least now I know what it means, even if I'm not sure how I would actually prove it yet...

This page last modified on