The Black-Scholes Model in VBA

The aim of this article is to walk the reader through the implementation of the Black-Scholes model for option pricing in VBA. Firstly, we’ll recap the theoretical framework. Secondly, we’ll provide the code to put the theory into practice and show some basic (but hopefully relevant) applications. The Theory – Pricing The classical Black-Scholes model […]

Trading Volatility Using Options: a French Case

Introduction Volatility is a key feature of financial markets. It is commonly used as a measure for risk and is a common an indicator of the investors’ fear and concern about the future. While higher volatility means bigger profits and losses in a directional strategy (one which bets on a future movement of the price […]