Black & Scholes for Puts/Calls in a Single Excel Cell
Sometimes an online option calculator isn’t enough and you’d like to implement the Black & Scholes (B&S) option pricing equations in Excel. If you’re just playing around it doesn’t matter how you structure the calculation. In fact, for clarity’s sake, it’s probably a good idea to spread out the calculation across multiple cells. However, if you’re planning to do some serious work with multiple B&S …
