金融工程史上最全面的的期权定价——VBA模板
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Contents
Option Pricing Models
Plain Vanilla Options
1 2 3 4 5 6 7
The generalized Black and Scholes option pricing formula Options on a stock with cash dividens The Black and Scholes model adjusted for trading day volatility The jump diffusion model American calls on stocks with known dividends American approximations, The Barone-Adesi and Whaley model, and The Bjerksund and Stensland mod The Miltersen and Schwartz commodity option model
Exotic Options
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Executive stock options Forward start options Time switch options Chooser options Options on options Writer extendible options Two asset correlation options Exchange one asset for another options Exchange options on exchange options Options on the maximum or the minimum of two risky assets Spread option approximation Floating strike lookback options Fixed strike lookback options Partial-time floating strike lookback options Partial-time fixed strike lookback Extreme spread options Standard barrier options Double barrier options Partial-time single asset barrier options Two asset barrier options Partial-time two asset barrier options Look-barrier options Soft-barrier options Gap options Cash-or-nothing options Two asset cash-or-nothing options Asset-or-nothing options Supershare options Binary barrier options Geometric average rate options Arithmetic average rate options: The Turnbull and Wakeman approximation Arithmetic average rate options: Levy's approximation Foreign equity options struck in domestic currency Fixed exchange rate foreign equity options Equity linked foreign exchange options Takeover foreign exchange options
Page 2
Contents
BjeBaidu Nhomakorabeaksund and Stensland model
Page 3
Interest Rate Options
44 Swaptions 45 The Vasicek model
Page 1
Contents
All manual input in blue on white All output in read on grey Information on yellow background used for drop-down menus
Option Pricing Models
Plain Vanilla Options
1 2 3 4 5 6 7
The generalized Black and Scholes option pricing formula Options on a stock with cash dividens The Black and Scholes model adjusted for trading day volatility The jump diffusion model American calls on stocks with known dividends American approximations, The Barone-Adesi and Whaley model, and The Bjerksund and Stensland mod The Miltersen and Schwartz commodity option model
Exotic Options
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Executive stock options Forward start options Time switch options Chooser options Options on options Writer extendible options Two asset correlation options Exchange one asset for another options Exchange options on exchange options Options on the maximum or the minimum of two risky assets Spread option approximation Floating strike lookback options Fixed strike lookback options Partial-time floating strike lookback options Partial-time fixed strike lookback Extreme spread options Standard barrier options Double barrier options Partial-time single asset barrier options Two asset barrier options Partial-time two asset barrier options Look-barrier options Soft-barrier options Gap options Cash-or-nothing options Two asset cash-or-nothing options Asset-or-nothing options Supershare options Binary barrier options Geometric average rate options Arithmetic average rate options: The Turnbull and Wakeman approximation Arithmetic average rate options: Levy's approximation Foreign equity options struck in domestic currency Fixed exchange rate foreign equity options Equity linked foreign exchange options Takeover foreign exchange options
Page 2
Contents
BjeBaidu Nhomakorabeaksund and Stensland model
Page 3
Interest Rate Options
44 Swaptions 45 The Vasicek model
Page 1
Contents
All manual input in blue on white All output in read on grey Information on yellow background used for drop-down menus