{"product_id":"how-to-implement-market-models-using-vba-isbn-9781118962008","title":"How to Implement Market Models Using VBA","description":"\u003cb\u003eAccessible VBA coding for complex financial modelling\u003c\/b\u003e \u003cp\u003e\u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. With a focus on the clarity of code, this practical introductory guide includes chapters on VBA fundamentals and essential mathematical techniques, helping readers master the numerical methods to build an algorithm that can be used in a wide range of pricing problems. Coverage includes general algorithms, vanilla instruments, multi-asset instruments, yield curve models, interest rate exotics, and more, guiding readers thoroughly through pricing in the capital markets area. The companion website (http:\/\/implementmodinvba.com\/) features additional VBA code and algorithmic techniques, and the interactive blog provides a forum for discussion of code with programmers and financial engineers, giving readers insight into the different applications and customisations possible for even more advanced problem solving..\u003c\/p\u003e \u003cp\u003eFinancial engineers implement models from a mathematical representation of an asset's performance by building a program that performs a valuation of securities based on this asset. \u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e makes this technical process understandable, with well-explained algorithms, VBA code, and accessible theoretical explanations.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eDecide which numerical method to use in which scenario\u003c\/li\u003e \u003cli\u003eIdentify the necessary building blocks of an algorithm\u003c\/li\u003e \u003cli\u003eWrite clear, functional VBA code for a variety of problems\u003c\/li\u003e \u003cli\u003eApply algorithms to different instruments and models\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eDesigned for finance professionals, this book brings more accurate modelling within reach for anyone with interest in the market. For clearer code, patient explanation, and practical instruction, \u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e is an essential introductory guide.\u003c\/p\u003e \u003cp\u003ePreface ix\u003c\/p\u003e \u003cp\u003eAcknowledgements xi\u003c\/p\u003e \u003cp\u003eAbbreviations xiii\u003c\/p\u003e \u003cp\u003eAbout the Author xv\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 1 The Basics of VBA Programming 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Getting started 1\u003c\/p\u003e \u003cp\u003e1.2 VBA objects and syntax 2\u003c\/p\u003e \u003cp\u003e1.2.1 The object-oriented basic syntax 3\u003c\/p\u003e \u003cp\u003e1.2.2 Using objects 3\u003c\/p\u003e \u003cp\u003e1.3 Variables 5\u003c\/p\u003e \u003cp\u003e1.3.1 Variable declaration 5\u003c\/p\u003e \u003cp\u003e1.3.2 Some usual objects 7\u003c\/p\u003e \u003cp\u003e1.3.3 Arrays 9\u003c\/p\u003e \u003cp\u003e1.4 Arithmetic 10\u003c\/p\u003e \u003cp\u003e1.5 Subroutines and functions 13\u003c\/p\u003e \u003cp\u003e1.5.1 Subroutines 14\u003c\/p\u003e \u003cp\u003e1.5.2 Functions 15\u003c\/p\u003e \u003cp\u003e1.5.3 Operations on one-dimensional arrays 16\u003c\/p\u003e \u003cp\u003e1.5.4 Operations on two-dimensional arrays (matrices) 16\u003c\/p\u003e \u003cp\u003e1.5.5 Operations with dates 19\u003c\/p\u003e \u003cp\u003e1.6 Custom objects 21\u003c\/p\u003e \u003cp\u003e1.6.1 Types 21\u003c\/p\u003e \u003cp\u003e1.6.2 Classes 22\u003c\/p\u003e \u003cp\u003e1.7 Debugging 24\u003c\/p\u003e \u003cp\u003e1.7.1 Error handling 24\u003c\/p\u003e \u003cp\u003e1.7.2 Tracking the code execution 25\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 2 Mathematical Algorithms 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Introduction 29\u003c\/p\u003e \u003cp\u003e2.2 Sorting lists 29\u003c\/p\u003e \u003cp\u003e2.2.1 Shell sort 29\u003c\/p\u003e \u003cp\u003e2.2.2 Quick sort 32\u003c\/p\u003e \u003cp\u003e2.3 Implicit equations 34\u003c\/p\u003e \u003cp\u003e2.4 Search for extrema 36\u003c\/p\u003e \u003cp\u003e2.4.1 The Nelder-Mead algorithm 36\u003c\/p\u003e \u003cp\u003e2.4.2 The simulated annealing 40\u003c\/p\u003e \u003cp\u003e2.5 Linear algebra 43\u003c\/p\u003e \u003cp\u003e2.5.1 Matrix inversion 44\u003c\/p\u003e \u003cp\u003e2.5.2 Cholesky decomposition 46\u003c\/p\u003e \u003cp\u003e2.5.3 Interpolation 48\u003c\/p\u003e \u003cp\u003e2.5.4 Integration 57\u003c\/p\u003e \u003cp\u003e2.5.5 Principal Component Analysis 60\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 3 Vanilla Instruments 67\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Definitions 67\u003c\/p\u003e \u003cp\u003e3.2 Fixed income 67\u003c\/p\u003e \u003cp\u003e3.2.1 Bond market 68\u003c\/p\u003e \u003cp\u003e3.2.2 Interbank market 72\u003c\/p\u003e \u003cp\u003e3.3 Vanilla derivatives 75\u003c\/p\u003e \u003cp\u003e3.3.1 Forward contracts 75\u003c\/p\u003e \u003cp\u003e3.3.2 Swaps 77\u003c\/p\u003e \u003cp\u003e3.3.3 Bond futures 81\u003c\/p\u003e \u003cp\u003e3.4 Options basics 84\u003c\/p\u003e \u003cp\u003e3.4.1 Brownian motion 84\u003c\/p\u003e \u003cp\u003e3.4.2 Ito integral 85\u003c\/p\u003e \u003cp\u003e3.4.3 Ito formula 86\u003c\/p\u003e \u003cp\u003e3.4.4 Black–Scholes basic model 89\u003c\/p\u003e \u003cp\u003e3.4.5 Risk-neutral probability 90\u003c\/p\u003e \u003cp\u003e3.4.6 Change of probability 90\u003c\/p\u003e \u003cp\u003e3.4.7 Martingale and numeraires 92\u003c\/p\u003e \u003cp\u003e3.4.8 European-style options pricing 94\u003c\/p\u003e \u003cp\u003e3.5 First generation exotic options 95\u003c\/p\u003e \u003cp\u003e3.5.1 Barrier options 95\u003c\/p\u003e \u003cp\u003e3.5.2 Quanto options 102\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 4 Numerical Solutions 105\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Finite differences 105\u003c\/p\u003e \u003cp\u003e4.1.1 Generic equation 105\u003c\/p\u003e \u003cp\u003e4.1.2 Implementation 106\u003c\/p\u003e \u003cp\u003e4.2 Trees 112\u003c\/p\u003e \u003cp\u003e4.2.1 Binomial trees 112\u003c\/p\u003e \u003cp\u003e4.2.2 Trinomial trees 116\u003c\/p\u003e \u003cp\u003e4.3 Monte-Carlo scenarios 116\u003c\/p\u003e \u003cp\u003e4.3.1 Uniform number generator 117\u003c\/p\u003e \u003cp\u003e4.3.2 From uniform to Gaussian numbers 127\u003c\/p\u003e \u003cp\u003e4.4 Simulation and regression 129\u003c\/p\u003e \u003cp\u003e4.5 Double-barrier analytical approximation 134\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 5 Monte-Carlo Pricing Issues 139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Multi-asset simulation 139\u003c\/p\u003e \u003cp\u003e5.1.1 The correlations issue 139\u003c\/p\u003e \u003cp\u003e5.1.2 The Gaussian case 139\u003c\/p\u003e \u003cp\u003e5.1.3 Exotics 143\u003c\/p\u003e \u003cp\u003e5.2 Discretization schemes 146\u003c\/p\u003e \u003cp\u003e5.3 Variance reduction techniques 147\u003c\/p\u003e \u003cp\u003e5.3.1 Antithetic variates 147\u003c\/p\u003e \u003cp\u003e5.3.2 Importance sampling 148\u003c\/p\u003e \u003cp\u003e5.3.3 Control variates 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 6 Yield Curve Models 163\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Short rate models 163\u003c\/p\u003e \u003cp\u003e6.1.1 Introduction 163\u003c\/p\u003e \u003cp\u003e6.1.2 Hull and White one-factor model 164\u003c\/p\u003e \u003cp\u003e6.1.3 Gaussian two-factor model 180\u003c\/p\u003e \u003cp\u003e6.1.4 Hull and White two-factor model 203\u003c\/p\u003e \u003cp\u003e6.2 Forward rate models 204\u003c\/p\u003e \u003cp\u003e6.2.1 Generic Heath-Jarrow-Morton 205\u003c\/p\u003e \u003cp\u003e6.2.2 LMM (LIBOR market model) 216\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 7 Stochastic Volatilities 233\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 The Heston model 234\u003c\/p\u003e \u003cp\u003e7.1.1 Code 234\u003c\/p\u003e \u003cp\u003e7.1.2 A faster algorithm 239\u003c\/p\u003e \u003cp\u003e7.1.3 Calibration 248\u003c\/p\u003e \u003cp\u003e7.2 Barrier options 254\u003c\/p\u003e \u003cp\u003e7.2.1 Numerical results 257\u003c\/p\u003e \u003cp\u003e7.2.2 Code 257\u003c\/p\u003e \u003cp\u003e7.3 Asian-style options 260\u003c\/p\u003e \u003cp\u003e7.4 SABR model 264\u003c\/p\u003e \u003cp\u003e7.4.1 Caplets 264\u003c\/p\u003e \u003cp\u003e7.4.2 Code 265\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 8 Interest Rate Exotics 267\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 CMS swaps 267\u003c\/p\u003e \u003cp\u003e8.1.1 Code 269\u003c\/p\u003e \u003cp\u003e8.2 Cancelable swaps 272\u003c\/p\u003e \u003cp\u003e8.2.1 Code 272\u003c\/p\u003e \u003cp\u003e8.2.2 Tree approximation 276\u003c\/p\u003e \u003cp\u003e8.3 Target redemption note 281\u003c\/p\u003e \u003cp\u003e8.3.1 Code 282\u003c\/p\u003e \u003cp\u003eBibliography 287\u003c\/p\u003e \u003cp\u003eIndex 289\u003c\/p\u003e \u003cp\u003e\u003cb\u003eFRANÇOIS GOOSSENS\u003c\/b\u003e has 12 years’ experience of programming pricing algorithms in Java and VBA. As a consultant, he currently trains students and young practitioners in computational finance through VBA coding.  \u003c\/p\u003e\u003cp\u003e Prior to that, over a 15 year periodv he ran interest-rates and equity related trading desks with Credit Lyonnais and Ixis whilst strongly involved in exotic derivatives’ management. François graduated from Ecole Centrale in Paris.   \u003c\/p\u003e\u003cp\u003e\u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. Practitioners can gain hands-on expertise of complex valuation issues with an easy-to-learn programming language, whilst avoiding getting too deeply involved in the theory. Author and VBA trainer, François Goossens draws on VBA programming with its accessible code that connects with Excel’s easy-to-use spreadsheet format. VBA is an efficient tool to gain fast and in-depth understanding of complex derivatives. \u003c\/p\u003e \u003cp\u003eDesigned to be an approachable resource with no prior knowledge of VBA required, this practical introductory guide includes information on VBA fundamentals and essential mathematical techniques. The text helps to master the numerical methods to build an algorithm that can be used to solve a wide range of pricing problems.  \u003c\/p\u003e\u003cp\u003e\u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e contains information on general algorithms, vanilla instruments, multi-asset instruments, yield curve models, interest rate exotics, and more. The author offers practitioners the opportunity to check their knowledge of Capital Market fundamentals. For VBA novices, he provides training exercises to put VBA techniques, such as loops, into practice. The text deals with numerical solutions that are called for when no analytical solution is available: simply put, it fixes 99% of problems.  \u003c\/p\u003e\u003cp\u003eGoossens reviews classes of assets that are valued using Monte-Carlo simulation methods and covers multi-asset and path-dependent instruments. The text explores variance reduction techniques and addresses widely used yield curve models and critical calibration issues. The author also includes information on the Hull \u0026amp; White and Gaussian short rate models, Heath-Jarrow-Morton, and Libor Market forward rates curve models.  \u003c\/p\u003e\u003cp\u003eHeston’s popular standard stochastic volatility model is presented in detail and includes recipes to help tackle exotic pricings. Finally, the author outlines the curve modellings that are applied in order to implement numerical algorithms aimed at some standard interest rates’ exotics such as CMS Swaps, Cancelable Swaps and Target Redemption Notes. The solutions derived from different models or numerical methods are compared.  \u003c\/p\u003e\u003cp\u003eWritten for finance professionals, \u003ci\u003eHow to Implement Market Models Using VBA\u003c\/i\u003e brings more accurate modelling within reach of anyone with an interest in the market. For clearer code, patient explanation, and practical instruction, this important resource is an essential introductory guide.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989380120805,"sku":"NP9781118962008","price":100.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118962008.jpg?v=1761783885","url":"https:\/\/k12savings.com\/es\/products\/how-to-implement-market-models-using-vba-isbn-9781118962008","provider":"K12savings","version":"1.0","type":"link"}