Abstract
We show how to implement a Rubinstein (1994) implied binomial tree using an Excel spreadsheet, but without having to use visual basic in Excel (VBA). We demonstrate both the optimization needed to generate implied ending risk-neutral probabilities from a set of actual option prices and the backwards recursion needed to solve for the entire implied tree. By using only standard Excel functions, and not resorting to VBA, we make this option pricing technique immediately accessible to both practitioners and academics. With minimal preparation, this technique can also be introduced to the undergraduate classroom.
Full Text
Paper version not known (
Free)
Published Version
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call