This comprehensive guide offers traders, quants, and studentsthe tools and techniques for using advanced models for pricingoptions. The accompanying website includes data files, such asoptions prices, stock prices, or index prices, as well as all ofthe codes needed to use the option and volatility models describedin the book. Praise for Option Pricing Models & Volatility UsingExcel-VBA "Excel is already a great pedagogical tool for teaching optionvaluation and risk management. But the VBA routines in this bookelevate Excel to an industrial-strength financial engineeringtoolbox. I have no doubt that it will become hugely successful as areference 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 toimplement option pricing and volatility models in VBA. The booktakes an in-depth look into how to implement the Heston and Hestonand Nandi models and includes an entire chapter on parameterestimation, but this is just the tip of the iceberg. Everyoneinterested in derivatives should have this book in their personallibrary." —Espen Gaarder Haug, option trader, philosopher, andauthor of Derivatives Models on Models "I am impressed. This is an important book because it is thefirst 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
Facts101 is your complete guide to Options Pricing Models and Volatility Using Excel-VBA. In this book, you will learn topics such as as those in your book plus much more. With key features such as key terms, people and places, Facts101 gives you all the information you need to prepare for your next exam. Our practice tests are specific to the textbook and we have designed tools to make the most of your limited study time.
Practical options pricing for better-informed investment decisions. The Heston Model and Its Extensions in VBA is the definitive guide to options pricing using two of the derivatives industry's most powerful modeling tools—the Heston model, and VBA. Light on theory, this extremely useful reference focuses on implementation, and can help investors more efficiently—and accurately—exploit market information to better inform investment decisions. Coverage includes a description of the Heston model, with specific emphasis on equity options pricing and variance modeling, The book focuses not only on the original Heston model, but also on the many enhancements and refinements that have been applied to the model, including methods that use the Fourier transform, numerical integration schemes, simulation, methods for pricing American options, and much more. The companion website offers pricing code in VBA that resides in an extensive set of Excel spreadsheets. The Heston model is the derivatives industry's most popular stochastic volatility model for pricing equity derivatives. This book provides complete guidance toward the successful implementation of this valuable model using the industry's ubiquitous financial modeling software, giving users the understanding—and VBA code—they need to produce option prices that are more accurate, and volatility surfaces that more closely reflect market conditions. Derivatives pricing is often the hinge on which profit is made or lost in financial institutions, making accuracy of utmost importance. This book will help risk managers, traders, portfolio managers, quants, academics and other professionals better understand the Heston model and its extensions, in a writing style that is clear, concise, transparent and easy to understand. For better pricing accuracy, The Heston Model and Its Extensions in VBA is a crucial resource for producing more accurate model outputs such as prices, hedge ratios, volatilities, and graphs.
Tap into the power of the most popular stochastic volatilitymodel for pricing equity derivatives Since its introduction in 1993, the Heston model has become apopular model for pricing equity derivatives, and the most popularstochastic volatility model in financial engineering. This vitalresource provides a thorough derivation of the original model, andincludes the most important extensions and refinements that haveallowed the model to produce option prices that are more accurateand volatility surfaces that better reflect market conditions. Thebook's material is drawn from research papers and many of themodels covered and the computer codes are unavailable from othersources. The book is light on theory and instead highlights theimplementation of the models. All of the models found here havebeen coded in Matlab and C#. This reliable resource offers anunderstanding of how the original model was derived from Ricattiequations, and shows how to implement implied and local volatility,Fourier methods applied to the model, numerical integrationschemes, parameter estimation, simulation schemes, Americanoptions, the Heston model with time-dependent parameters, finitedifference methods for the Heston PDE, the Greeks, and the doubleHeston model. A groundbreaking book dedicated to the exploration of theHeston model—a popular model for pricing equityderivatives Includes a companion website, which explores the Heston modeland its extensions all coded in Matlab and C# Written by Fabrice Douglas Rouah a quantitative analyst whospecializes in financial modeling for derivatives for pricing andrisk management Engaging and informative, this is the first book to dealexclusively with the Heston Model and includes code in Matlab andC# for pricing under the model, as well as code for parameterestimation, simulation, finite difference methods, Americanoptions, and more.
Mechatronics, as the integrating framework of mechanical engineering, electrical engineering, computer technology, control engineering and automation forms a crucial part in the design, manufacture and maintenance of a wide range of engineering products and processes. The mechatronics itself changes rapidly in last decade, from original mixture of subfields into original approach in engineering as a technical discipline. The book you are holding is aimed to help the reader to orient in this evolving field of science and technology. "Mechatronics 2013: Recent Technological and Scientific Advances" is the fourth volume following the previous editions in 2007, 2009 and 2011, providing the comprehensive and accessible coverage of advances in mechatronics presented on the 10th International Conference Mechatronics 2013, hosted this year at the Brno University of Technology, Czech Republic. The contributions, that passed the thorough review process, give an insight into current trends in research and development among Mechatronics 2013 contributing countries, with paper topics covering design and modeling of mechatronic systems, control and automation, signal processing, robotics and others, keeping in mind the innovation benefits of mechatronics design approach, leading to the development, production and daily use of machines and devices possessing a certain degree of computer based intelligence.
This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
[flap] For investors, risk is about the odds of losing money, and Value at Risk (VaR) is grounded in that common-sense fact. VAR modeling answers, “What is my worst-case scenario?” and “How much could I lose in a really bad month?” However, there has not been an effective guidebook available to help investors and financial managers make their own VaR calculations--until now. The VaR Implementation Handbook is a hands-on road map for professionals who have a solid background in VaR but need the critical strategies, models, and insights to apply their knowledge in the real world. Heralded as “the new science of risk management,” VaR has emerged as the dominant methodology used by financial institutions and corporate treasuries worldwide for estimating precisely how much money is at risk each day in the financial markets. The VaR Implementation Handbook picks up where other books on the subject leave off and demonstrates how, with proper implementation, VaR can be a valuable tool for assessing risk in a variety of areas-from equity to structured and operational products. This complete guide thoroughly covers the three major areas of VaR implementation--measuring, modeling risk, and managing--in three convenient sections. Savvy professionals will keep this handbook at their fingertips for its: Reliable advice from 40 recognized experts working in universities and financial institutions around the world Effective methods and measures to ensure that implemented VaR models maintain optimal performance Up-to-date coverage on newly exposed areas of volatility, including derivatives Real-world prosperity requires making informed financial decisions. The VaR Implementation Handbook is a step-by-step playbook to getting the most out of VaR modeling so you can successfully manage financial risk.
"This book will serve as a complete course in Hedge Fund Modeling and Analysis and will arm Hedge Funds with the full range of tools they need to manage their risks and capitalize on the return profiles of their investment styles"--
"Professional Financial Computing Using Excel and VBA is anadmirable exposition that bridges the theoretical underpinnings offinancial engineering and its application which usually appears asa "black-box" software application. The book opens the black-boxand reveals the architecture of risk-modeling and financialengineering based on industry-standard stochastic models byutilizing Excel and VBA functionality to create a robust andpractical modeling tool-kit. Financial engineering professionalswho purchase this book will have a jumpstart advantage for theircustomized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) "Spreadsheet modeling for finance has become a standard coursein the curriculum of many Quantitative Finance programs since theExcel-based Visual Basic programming is now widely used inconstructing optimal portfolios, pricing structured products andmanaging risks. Professional Financial Computing Using Excel andVBA is written by a unique team of finance, physics andcomputer academics and practitioners. It is a good reference forthose who are studying for a Masters degree in FinancialEngineering and Risk Management. It can also be useful forfinancial engineers to jump-start a project on designing structuredproducts, modeling interest term structure or credit risks." Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong "Excel has been one of the most powerful tools for financialplanning and computing over the last few years. Most users utilizea fraction of its capabilities. One of the reasons is the limitedavailability of books that cover the advanced features of Excel forFinance. Professional Financial Computing Using Excel andVBA goes the extra mile and deals with the Excel tools manyprofessionals call for. This book is a must for professionals orstudents dealing with financial engineering, financial riskmanagement, computational finance or mathematical finance. I lovedthe way the authors covered the material using real life, hands-onexamples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analystsand MBAs