Accessible VBA coding for complex financial modelling How to Implement Market Models Using VBA 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. Financial 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. How to Implement Market Models Using VBA makes this technical process understandable, with well-explained algorithms, VBA code, and accessible theoretical explanations. * Decide which numerical method to use in which scenario * Identify the necessary building blocks of an algorithm * Write clear, functional VBA code for a variety of problems * Apply algorithms to different instruments and models Designed 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, How to Implement Market Models Using VBA is an essential introductory guide.
Praise for How to Implement Market Models Using VBA
"This well-written book proposes a wide instructional use of Visual Basic in order to learn computational finance in more detail by covering issues and techniques useful for quant/trading jobs in investment companies.
All readers, students or financial engineers, will find much to improve their thinking of VBA when applied to finance thanks to the important resource of examples. I strongly recommend this new book to accompany each step toward successful programming."
—Sofiane Aboura Professor of finance, University of Paris Dauphine
"This book offers the reader a unique opportunity to obtain both introductory and advanced knowledge in Finance with direct implementations in VBA. It starts with a survival kit for VBA newcomers and covers classical techniques usually studied in MSc Finance programs. However, it also presents more sophisticated approaches to these topics (among others, the HJM and Heston models), qualifying the book for both professionals and advanced students in quantitative/computational Finance.
As such I would recommend this book to my students attending the Master 'Financial and Risk Engineering' or under my supervision in a PhD program, as well as to everyone willing to update or upgrade his knowledge in VBA for implementing market models in a professional environment."
—Olivier Brandouy Professor of finance, University of Bordeaux and IAE/Paris Sorbonne
"As financial markets have reached maturity and volumes of products have dramatically increased, the emphasis of financial research has shifted from model development to model implementation. Nowadays it is paramount to use models optimally in aspects such as development costs, transparency, controllability, etc. Their implementation is therefore as important as their all-encompassing-ness, which explains why VBA has become a tool of choice to test models and valuation tools.