Derivatives D:\Dropbox\_\work\Fin_Deriv Fin_Deriv_Analytical_Cont_Graphs_vsX_vsSigma
Featured Products
This Excel spreadsheet contains Visual Basic (VBA) functions that calculate option price and risk (Greeks), namely:
Delta, Gamma, Speed, Vega, Volga, Vanna, Theta, Rho(=ppmu+ppr), ppmu (Sensitivity to Drift), ppr (Sensitivity to Risk-Free-Rate)
Black-Scholes Option Pricing Framework
Underlying Returns Distributions Assumptions: Log-Normal
Exercise Types: European
Product Types: Puts, Calls
Payoff Types: Digital (Binary), Analog (Vanilla)
The functions are exposed and usable within the spreadsheet cells.
A sample sheet is provided to demonstrate how the functions are used.
Please contact us if you have requests to customize the spreadsheet.
Requirements: Microsoft Excel 2016, 2013
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv.xlsm
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Cont_Graphs
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Cont_Graphs\20200423_Fin_Deriv_20200423_150211_Lenovo_wc001.xlsm
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Cont_Graphs\20200423_Fin_Deriv_20200423_150211_Lenovo_wc001.zip
Black-Scholes-Merton European Option Pricing Excel VBA Spreadsheet
Description:
A simple option pricer and payoff diagram.
Pricing model is the well-known Black-Scholes-Merton.
Implementation interface is in Excel.
Implementation of functional code is in VBA.
Green cells are input cells for parameters.
Yellow cells are output cells that display the result.
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Option_Pricer\Opt_Euro_V.xlsm
Black-Scholes-Merton European Option Pricing Excel VBA Spreadsheet
Description:
A simple option pricer and payoff diagram.
Pricing model is the well-known Black-Scholes-Merton.
Implementation interface is in Excel.
Implementation of functional code is in VBA.
Green cells are input cells for parameters.
Yellow cells are output cells that display the result.
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Option_Pricer\Opt_Euro_V_D.xlsm
Black-Scholes-Merton European Option Pricing Excel VBA Spreadsheet
Description:
A simple option pricer and payoff diagram.
Pricing model is the well-known Black-Scholes-Merton.
Implementation interface is in Excel.
Implementation of functional code is in VBA.
Green cells are input cells for parameters.
Yellow cells are output cells that display the result.
D:\Dropbox\_\work\Fin_Deriv\_Theory\Fin_Deriv_Analytical_Option_Pricer\Opt_Euro_V_DG.xlsm