简介
Praise for Option Pricing Models & Volatility Using Excel-VBA "Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers." --Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University "This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library." --Espen Gaarder Haug, option trader, philosopher, nd author of Derivatives Models on Models "I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH." --Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland
目录
Contents 9
Preface 11
ACKNOWLEDGMENTS 13
Chapter 1: Mathematical Preliminaries 15
INTRODUCTION 15
COMPLEX NUMBERS 15
FINDING ROOTS OF FUNCTIONS 21
OLS AND WLS 26
NELDER-MEAD ALGORITHM 34
MAXIMUM LIKELIHOOD ESTIMATION 41
CUBIC SPLINE INTERPOLATION 41
SUMMARY 45
EXERCISES 46
SOLUTIONS TO EXERCISES 47
Chapter 2: Numerical Integration 53
INTRODUCTION 53
NEWTON-COATES FORMULAS 54
IMPLEMENTING NEWTON-COTES FORMULAS IN VBA 63
GAUSSIAN QUADRATURES 71
SUMMARY 76
EXERCISES 77
SOLUTIONS TO EXERCISES 78
APPENDIX 79
Chapter 3: Tree-Based Methods 84
INTRODUCTION 84
CRR BINOMIAL TREE 85
LEISEN-REIMER BINOMIAL TREE 89
EDGEWORTH BINOMIAL TREE 91
FLEXIBLE BINOMIAL TREE 95
TRINOMIAL TREE 97
ADAPTIVE MESH METHOD 101
COMPARING TREES 105
IMPLIED VOLATILITY TREES 106
ALLOWING FOR DIVIDENDS AND THE COST-OF-CARRY 118
SUMMARY 122
EXERCISES 122
SOLUTIONS TO EXERCISES 123
Chapter 4: The Black-Scholes, Practitioner Black-Scholes, and Gram-Charlier Models 126
INTRODUCTION 126
THE BLACK-SCHOLES MODEL 126
IMPLIED VOLATILITY AND THE DVF 130
THE PRACTITIONER BLACK-SCHOLES MODEL 134
THE GRAM-CHARLIER MODEL 138
SUMMARY 143
EXERCISES 144
SOLUTIONS TO EXERCISES 145
Chapter 5: The Heston (1993) Stochastic Volatility Model 150
INTRODUCTION 150
THE HESTON (1993) MODEL 151
INCREASING INTEGRATION ACCURACY 160
THE FUNDAMENTAL TRANSFORM 163
SENSITIVITY ANALYSIS 165
SUMMARY 170
EXERCISES 171
SOLUTIONS TO EXERCISES 171
APPENDIX 174
Chapter 6: The Heston and Nandi (2000) GARCH Model 177
INTRODUCTION 177
PERSISTENT VOLATILITY IN ASSET RETURNS 177
GARCH VARIANCE MODELING 180
THE HESTON AND NANDI (2000) MODEL 188
SUMMARY 196
EXERCISES 196
SOLUTIONS TO EXERCISES 198
Chapter 7: The Greeks 201
INTRODUCTION 201
BLACK-SCHOLES GREEKS 202
GREEKS FROM THE TREES 206
GREEKS FROM THE GRAM-CHARLIER MODEL 211
GREEKS FROM THE HESTON (1993) MODEL 217
GREEKS FROM THE HESTON AND NANDI (2000) MODEL 224
GREEKS BY FINITE DIFFERENCES 231
SUMMARY 235
EXERCISES 236
SOLUTIONS TO EXERCISES 236
APPENDIX 240
Chapter 8: Exotic Options 244
INTRODUCTION 244
SINGLE-BARRIER OPTIONS 244
DIGITAL OPTIONS 270
ASIAN OPTIONS 275
FLOATING-STRIKE LOOKBACK OPTIONS 279
SUMMARY 282
EXERCISES 283
SOLUTIONS TO EXERCISES 284
Chapter 9: Parameter Estimation 289
INTRODUCTION 289
UNCONDITIONAL MOMENTS 289
MAXIMUM LIKELIHOOD FOR GARCH MODELS 292
ESTIMATION BY LOSS FUNCTIONS 297
OTHER ESTIMATION METHODS 307
SUMMARY 307
EXERCISES 307
SOLUTIONS TO EXERCISES 309
Chapter 10: Implied Volatility 318
INTRODUCTION 318
OBTAINING IMPLIED VOLATILITY 318
EXPLAINING SMILES AND SMIRKS 326
SUMMARY 330
EXERCISES 331
SOLUTIONS TO EXERCISES 331
Chapter 11: Model-Free Implied Volatility 336
INTRODUCTION 336
THEORETICAL FOUNDATION 336
IMPLEMENTATION 337
INTERPOLATION-EXTRAPOLATION METHOD 343
MODEL-FREE IMPLIED FORWARD VOLATILITY 350
THE VIX INDEX 353
SUMMARY 360
EXERCISES 361
SOLUTIONS TO EXERCISES 361
Chapter 12: Model-Free Higher Moments 364
INTRODUCTION 364
THEORETICAL FOUNDATION 364
IMPLEMENTATION 368
VERIFYING IMPLIED MOMENTS 377
GRAM-CHARLIER IMPLIED MOMENTS 379
SUMMARY 382
EXERCISES 384
SOLUTIONS TO EXERCISES 384
Chapter 13: Volatility Returns 388
INTRODUCTION 388
STRADDLE RETURNS 389
DELTA-HEDGED GAINS 400
VOLATILITY EXPOSURE 402
VARIANCE SWAPS 406
SUMMARY 411
EXERCISES 412
SOLUTIONS TO EXERCISES 413
Appendix A: A VBA Primer 418
References 423
About the CD-ROM 427
INTRODUCTION 427
SYSTEM REQUIREMENTS 427
USING THE CD WITH WINDOWS 427
WHAT\u2019S ON THE CD 428
TROUBLESHOOTING 429
CUSTOMER CARE 429
About the Authors 431
Index 433
Preface 11
ACKNOWLEDGMENTS 13
Chapter 1: Mathematical Preliminaries 15
INTRODUCTION 15
COMPLEX NUMBERS 15
FINDING ROOTS OF FUNCTIONS 21
OLS AND WLS 26
NELDER-MEAD ALGORITHM 34
MAXIMUM LIKELIHOOD ESTIMATION 41
CUBIC SPLINE INTERPOLATION 41
SUMMARY 45
EXERCISES 46
SOLUTIONS TO EXERCISES 47
Chapter 2: Numerical Integration 53
INTRODUCTION 53
NEWTON-COATES FORMULAS 54
IMPLEMENTING NEWTON-COTES FORMULAS IN VBA 63
GAUSSIAN QUADRATURES 71
SUMMARY 76
EXERCISES 77
SOLUTIONS TO EXERCISES 78
APPENDIX 79
Chapter 3: Tree-Based Methods 84
INTRODUCTION 84
CRR BINOMIAL TREE 85
LEISEN-REIMER BINOMIAL TREE 89
EDGEWORTH BINOMIAL TREE 91
FLEXIBLE BINOMIAL TREE 95
TRINOMIAL TREE 97
ADAPTIVE MESH METHOD 101
COMPARING TREES 105
IMPLIED VOLATILITY TREES 106
ALLOWING FOR DIVIDENDS AND THE COST-OF-CARRY 118
SUMMARY 122
EXERCISES 122
SOLUTIONS TO EXERCISES 123
Chapter 4: The Black-Scholes, Practitioner Black-Scholes, and Gram-Charlier Models 126
INTRODUCTION 126
THE BLACK-SCHOLES MODEL 126
IMPLIED VOLATILITY AND THE DVF 130
THE PRACTITIONER BLACK-SCHOLES MODEL 134
THE GRAM-CHARLIER MODEL 138
SUMMARY 143
EXERCISES 144
SOLUTIONS TO EXERCISES 145
Chapter 5: The Heston (1993) Stochastic Volatility Model 150
INTRODUCTION 150
THE HESTON (1993) MODEL 151
INCREASING INTEGRATION ACCURACY 160
THE FUNDAMENTAL TRANSFORM 163
SENSITIVITY ANALYSIS 165
SUMMARY 170
EXERCISES 171
SOLUTIONS TO EXERCISES 171
APPENDIX 174
Chapter 6: The Heston and Nandi (2000) GARCH Model 177
INTRODUCTION 177
PERSISTENT VOLATILITY IN ASSET RETURNS 177
GARCH VARIANCE MODELING 180
THE HESTON AND NANDI (2000) MODEL 188
SUMMARY 196
EXERCISES 196
SOLUTIONS TO EXERCISES 198
Chapter 7: The Greeks 201
INTRODUCTION 201
BLACK-SCHOLES GREEKS 202
GREEKS FROM THE TREES 206
GREEKS FROM THE GRAM-CHARLIER MODEL 211
GREEKS FROM THE HESTON (1993) MODEL 217
GREEKS FROM THE HESTON AND NANDI (2000) MODEL 224
GREEKS BY FINITE DIFFERENCES 231
SUMMARY 235
EXERCISES 236
SOLUTIONS TO EXERCISES 236
APPENDIX 240
Chapter 8: Exotic Options 244
INTRODUCTION 244
SINGLE-BARRIER OPTIONS 244
DIGITAL OPTIONS 270
ASIAN OPTIONS 275
FLOATING-STRIKE LOOKBACK OPTIONS 279
SUMMARY 282
EXERCISES 283
SOLUTIONS TO EXERCISES 284
Chapter 9: Parameter Estimation 289
INTRODUCTION 289
UNCONDITIONAL MOMENTS 289
MAXIMUM LIKELIHOOD FOR GARCH MODELS 292
ESTIMATION BY LOSS FUNCTIONS 297
OTHER ESTIMATION METHODS 307
SUMMARY 307
EXERCISES 307
SOLUTIONS TO EXERCISES 309
Chapter 10: Implied Volatility 318
INTRODUCTION 318
OBTAINING IMPLIED VOLATILITY 318
EXPLAINING SMILES AND SMIRKS 326
SUMMARY 330
EXERCISES 331
SOLUTIONS TO EXERCISES 331
Chapter 11: Model-Free Implied Volatility 336
INTRODUCTION 336
THEORETICAL FOUNDATION 336
IMPLEMENTATION 337
INTERPOLATION-EXTRAPOLATION METHOD 343
MODEL-FREE IMPLIED FORWARD VOLATILITY 350
THE VIX INDEX 353
SUMMARY 360
EXERCISES 361
SOLUTIONS TO EXERCISES 361
Chapter 12: Model-Free Higher Moments 364
INTRODUCTION 364
THEORETICAL FOUNDATION 364
IMPLEMENTATION 368
VERIFYING IMPLIED MOMENTS 377
GRAM-CHARLIER IMPLIED MOMENTS 379
SUMMARY 382
EXERCISES 384
SOLUTIONS TO EXERCISES 384
Chapter 13: Volatility Returns 388
INTRODUCTION 388
STRADDLE RETURNS 389
DELTA-HEDGED GAINS 400
VOLATILITY EXPOSURE 402
VARIANCE SWAPS 406
SUMMARY 411
EXERCISES 412
SOLUTIONS TO EXERCISES 413
Appendix A: A VBA Primer 418
References 423
About the CD-ROM 427
INTRODUCTION 427
SYSTEM REQUIREMENTS 427
USING THE CD WITH WINDOWS 427
WHAT\u2019S ON THE CD 428
TROUBLESHOOTING 429
CUSTOMER CARE 429
About the Authors 431
Index 433
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ:4006604884
云图客服:
用户发送的提问,这种方式就需要有位在线客服来回答用户的问题,这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
亲爱的云图用户,
光盘内的文件都可以直接点击浏览哦
无需下载,在线查阅资料!