Jonathan M. Godbey

Featured in:

Articles

Excel Functions for Option Prices and Greeks without VBA

Nov 21, 2024 | scholarship.richmond.edu | Tom Arnold |Joseph Farizo |Jonathan M. Godbey

The =LAMBDA function within Excel provides a powerful new tool for investors and analysts. In this treatment, we demonstrate =LAMBDA functions that calculate an option’s intrinsic value, price, and Greeks based on the Black-Scholes model.
"Using Excel’s “LAMBDA” Feature to Produce Multi-Stage Stock Pricing Fu" by Tom Arnold, Joseph Farizo et al.

Sep 21, 2024 | scholarship.richmond.edu | Tom Arnold |Joseph Farizo |Jonathan M. Godbey

AbstractExcel’s new “=LAMBDA” function is applied to multi-stage stock pricing. This provides a context for implementing the =LAMBDA function, a greater understanding of the concept of the time value of money, and a reduction in the complexity of performing the calculation. The =LAMBDA functions lessens the need for using VBA and macros and only requires basic knowledge of Excel function syntax. Recommended CitationArnold, Tom, C., Joseph Farizo, Jonathan M. Goodbye.
Crypto Currency Exchange and Mining Excel Simulations

Aug 24, 2024 | scholarship.richmond.edu | Tom Arnold |Joseph Farizo |Jonathan M. Godbey

AbstractThe mathematics underlying blockchain-based cryptocurrencies is beyond the scope of most undergraduate finance programs. However, students should understand the intuition behind blockchain so that they might better understand how to apply this technology to future cases. In this paper, we develop a mathematically simple digital signature example and a mathematically simple proof-of-work simulation for classroom use. Recommended CitationArnold, Tom, C., Joseph Farizo, Jonathan M. Goodbye.
"Black-Scholes Option Pricing and Greeks Using Excel’s “LAMBDA” Functio" by Tom Arnold, Joseph Farizo et al.

Aug 21, 2024 | scholarship.richmond.edu | Tom Arnold |Joseph Farizo |Jonathan M. Godbey

AbstractThe =LAMBDA function within Excel provides a powerful new tool for investors and analysts. In this treatment, we show how to create a function that calculates an option’s intrinsic value, price, and delta based on the Black-Scholes model. Other option Greek functions and calculations are available in a downloadable file. The LAMBDA function is not limited to the Black-Scholes model and has important advantages over Excel’s previous solution of creating user-defined functions in VBA.