• Debasree Goswami

This research delves into the application of stochastic processes, specifically the Geometric Brownian Motion (GBM) and the Cox-Ingersoll-Ross (CIR) process, in the realm of quantitative finance. Recognizing the ubiquity of Microsoft Excel in the finance sector, we introduce a hands-on approach to simulate these processes using Visual Basic for Applications (VBA). Our paper highlights the implementation details, ensuring the adaptability of the developed code for various financial stochastic processes. By bridging theoretical finance with practical Excel-based solutions, this research aims to provide a valuable tool for financial analysts and researchers.

Stochastic Processes, Geometric Brownian Motion (GBM), Cox-Ingersoll-Ross (CIR) Process, Visual Basic for Applications (VBA), Financial Modeling in Excel, Numerical Simulation, Milstein Scheme.

"Harnessing Excel's VBA for Simulating Fundamental Stochastic Processes: A Deep Dive into GBM and CIR Implementations", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.10, Issue 8, page no.g542-g547, August-2023, Available :http://www.jetir.org/papers/JETIR2308658.pdf

"Harnessing Excel's VBA for Simulating Fundamental Stochastic Processes: A Deep Dive into GBM and CIR Implementations", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.10, Issue 8, page no. ppg542-g547, August-2023, Available at : http://www.jetir.org/papers/JETIR2308658.pdf