Impromptu Video: Calculating the Implied Volatility of a Put Using Excel

This is a quick, impromptu video addressing a question on which fields to modify in our old spreadsheet to calculate the implied volatility of a put option rather than a call. Please see the videos below for an explanation of the math involved.

Original video calculating volatility with Excel: https://youtu.be/ljlqGWz1xDY
Video series on Newton’s Method: https://youtu.be/Q6COHive9CY
Calculating the Implied Volatility of a Option with Python: https://youtu.be/Jpy3iCsijIU
Calculating the IV of an Option with Excel: https://youtu.be/ljlqGWz1xDY

Tip Jar: https://paypal.me/kpmooney