For portfolio hedging, the add-in provides exact formulas for Delta, Gamma, Theta, Vega, and Rho, including Charm, Vanna, and Speed (3rd order Greeks).
Problem: A PhD student needs to compare implied volatility surfaces across 500 stocks. Solution: The add-in allows batch calculation directly in Excel without needing to learn Python. hoadley finance add in for excel.zip
You can price European and American options on stocks, indices, futures, and currencies. The add-in supports: For portfolio hedging, the add-in provides exact formulas
Example function: =BSOptionPrice("call", 100, 105, 0.05, 0.2, 0.5, 0.02) You can price European and American options on
If you are unzipping this file, here is the arsenal of tools you are unlocking: