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
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.
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.
"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
A convenient reference for the scientist, student, or engineer whose work necessitates the use of the basic concepts in complex analysis, this is a book in which all the ideas and applications of complex analysis and differential equations are treated, as well as the applicable computational software.
Equity and index options expire on the third Friday of each month. As that moment approaches, unusual market forces create option price distortions, rarely understood by most investors. These distortions give rise to outstanding trading opportunities with enormous profit potential. In Trading Options at Expiration: Strategies and Models for Winning the Endgame, leading options trader Jeff Augen explores this extraordinary opportunity with never-before published statistical models, minute-by-minute pricing analysis, and optimized trading strategies that regularly deliver returns of 40%-300% per trade. You’ll learn how to structure positions that profit from end-of-contract price distortions with remarkably low risk. These strategies don’t rely on your ability to pick stocks or predict market direction and they only require one or two days of market exposure per month. Augen also discusses: · Three powerful end-of-cycle effects not comprehended by contemporary pricing models · Trading only one or two days each month and avoiding overnight exposure · Leveraging the surprising power of expiration-day pricing dynamics If you’re looking for an innovative new way to reignite your returns no matter where the markets move, you’ve found it in Trading Options at Expiration. “Learn and profit from Jeff Augen’s book: It clearly explains how to take advantage of market inefficiencies in collapsing implied volatility, effects of strike price, and time decay. A must-read for individuals who are options oriented.” --Ralph J. Acampora, CMT, Director of Technical Analysis Studies, New York Institute of Finance “A fantastic, insightful book full of meticulously compiled statistics about anomalies that surround option expiration. Not only does Augen present a set of effective trading strategies to capitalize on these anomalies, he walks through the performance of each across several expirations. His advice is practical and readily applicable: He outlines common pitfalls, gives guidance on timing your executions, and even includes code that can be used to perform the same calculations he does in the text. A thoroughly enjoyable read that will give you a true edge in your option trading.” --Alexis Goldstein, Vice President, Equity Derivatives Business Analyst “Mr. Augen makes a careful and systematic study of option prices at expiration. His translation of price behavior into trading strategy is intriguing work, and the level of detail is impressive.” --Dr. Robert Jennings, Professor of Finance, Indiana University Kelly School of Business “This book fills a gap in the vast amount of literature on derivatives trading and stands out for being extremely well written, clear, concise, and very low on jargon--perfect for traders looking to evolve their equity option strategies.” --Nazzaro Angelini, Principal, Spearpoint Capital “Instead of considering macro-time strategies that take weeks to unfold, Jeff Augen is thinking micro here--hours or days--specifically the days or hours right before expiration, and harnessing grinding, remorseless options decay for profit. He builds a compelling case for the strategy here. The concept of using ratio spreads plus risk management for as brief a period as one day--open to close--to capture expiring premium is worth the price of admission alone. A superb follow-up to his first book. Must-read for the serious options student.” --John A. Sarkett, Option Wizard software