Opt Vanna Volga Theta
Calculates Theta using Vanna-Volga model
Syntax
=mxls.opt_VannaVolga_Theta(spot, expiryDate, optionType, strike, domesticRate, foreignRate, atmVol, rr25, bf25, [deltaConvention])Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?