Author: Fabrice D. Rouah,Gregory Vainberg

Publisher: John Wiley & Sons

ISBN: 1118429206

Category: Business & Economics

Page: 441

View: 1633

This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. 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, and 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
Read More

Author: Fabrice D. Rouah,Gregory Vainberg

Publisher: John Wiley & Sons

ISBN: 0471794643

Category: Business & Economics

Page: 441

View: 3433

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
Read More

Author: Espen Gaardner Haug

Publisher: McGraw Hill Professional

ISBN: 9780071395892

Category: Business & Economics

Page: 232

View: 7624

When pricing options in todayÕs fast-action markets, you need quick access to precise facts and market-tested information. The Complete Guide to Options Pricing Formulas is the only authoritative, comprehensive reference to make the necessary set of option pricing tools available in one place. This invaluable reference work, which includes valuable software and ready-to-use programming code to enhance your understanding of the options pricing models discussed and their practical implementations, also gives you a complete listing of key options formulas, all in a dictionary format for ease of use; commentary from derivatives expert and author Espen Gaarder Haug that explains key points in the most important and useful formulas; practitioner-oriented formulas, and highlights of the latest options pricing research from major institutions worldwide; and much more! Invaluable for both experienced users and those learning how to use the tools of valuation, The Complete Guide to Options Pricing Formulas is the first and only book to place all of the research and information you need at your fingertips with precise directions on maximizing its real-world value.
Read More

Author: Mary Jackson,Mike Staunton

Publisher: John Wiley & Sons

ISBN: 0470061669

Category: Business & Economics

Page: 276

View: 4698

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.
Read More

Object Oriented Applications with VBA

Author: Nick Webber

Publisher: John Wiley & Sons

ISBN: 0470661844

Category: Business & Economics

Page: 692

View: 6349

Implementing Models of Financial Derivatives is a comprehensive treatment of advanced implementation techniques in VBA for models of financial derivatives. Aimed at readers who are already familiar with the basics of VBA it emphasizes a fully object oriented approach to valuation applications, chiefly in the context of Monte Carlo simulation but also more broadly for lattice and PDE methods. Its unique approach to valuation, emphasizing effective implementation from both the numerical and the computational perspectives makes it an invaluable resource. The book comes with a library of almost a hundred Excel spreadsheets containing implementations of all the methods and models it investigates, including a large number of useful utility procedures. Exercises structured around four application streams supplement the exposition in each chapter, taking the reader from basic procedural level programming up to high level object oriented implementations. Written in eight parts, parts 1-4 emphasize application design in VBA, focused around the development of a plain Monte Carlo application. Part 5 assesses the performance of VBA for this application, and the final 3 emphasize the implementation of a fast and accurate Monte Carlo method for option valuation. Key topics include: ?Fully polymorphic factories in VBA; ?Polymorphic input and output using the TextStream and FileSystemObject objects; ?Valuing a book of options; ?Detailed assessment of the performance of VBA data structures; ?Theory, implementation, and comparison of the main Monte Carlo variance reduction methods; ?Assessment of discretization methods and their application to option valuation in models like CIR and Heston; ?Fast valuation of Bermudan options by Monte Carlo. Fundamental theory and implementations of lattice and PDE methods are presented in appendices and developed through the book in the exercise streams. Spanning the two worlds of academic theory and industrial practice, this book is not only suitable as a classroom text in VBA, in simulation methods, and as an introduction to object oriented design, it is also a reference for model implementers and quants working alongside derivatives groups. Its implementations are a valuable resource for students, teachers and developers alike. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Read More

A Guide to Structuring, Pricing and Trading

Author: Mohamed Bouzoubaa,Adel Osseiran

Publisher: John Wiley & Sons

ISBN: 9780470710081

Category: Business & Economics

Page: 392

View: 6937

The recent financial crisis brought to light many of the misunderstandings and misuses of exotic derivatives. With market participants on both the buy and sell-side having been found guilty of not understanding the products they were dealing with, never before has there been a greater need for clarification and explanation. Exotic Options and Hybrids is a practical guide to structuring, pricing and hedging complex exotic options and hybrid derivatives that will serve readers through the recent crisis, the road to recovery, the next bull market and beyond. Written by experienced practitioners, it focuses on the three main parts of a derivative’s life: the structuring of a product, its pricing and its hedging. Divided into four parts, the book covers a multitude of structures, encompassing many of the most up-to-date and promising products from exotic equity derivatives and structured notes to hybrid derivatives and dynamic strategies. Based on a realistic setting from the heart of the business, inside a derivatives operation, the practical and intuitive discussions of these aspects make these exotic concepts truly accessible. Adoptions of real trades are examined in detail, and all of the numerous examples are carefully selected so as to highlight interesting and significant aspects of the business. The introduction of payoff structures is accompanied by scenario analysis, diagrams and lifelike sample term sheets. Readers learn how to spot where the risks lie to pave the way for sound valuation and hedging of such products. There are also questions and accompanying discussions dispersed in the text, each exploited to illustrate one or more concepts from the context in which they are set. The applications, the strengths and the limitations of various models are highlighted, in relevance to the products and their risks, rather than the model implementations. Models are de-mystified in separately dedicated sections, but their implications are alluded to throughout the book in an intuitive and non-mathematical manner. By discussing exotic options and hybrids in a practical, non-mathematical and highly intuitive setting, this book will blast through the misunderstanding of exotic derivatives, enabling practitioners to fully understand and correctly structure, price and hedge theses products effectively, and stand strong as the only book in its class to make these “exotic” concepts truly accessible.
Read More

Author: Fabrice D. Rouah

Publisher: John Wiley & Sons

ISBN: 1119003326

Category: Business & Economics

Page: 352

View: 8999

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.
Read More

Author: Donny C. F. Lai,Humphrey K. K. Tung,Michael C. S. Wong

Publisher: John Wiley & Sons

ISBN: 1118179080

Category: Business & Economics

Page: 350

View: 6581

"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized 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 course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, 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 financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs
Read More

Author: Gunter Löeffler,Mr Peter N Posch

Publisher: John Wiley & Sons

ISBN: 0470660929

Category: Business & Economics

Page: 342

View: 1452

This book provides practitioners and students with an intuitive, hands-on introduction to modern credit risk modelling. Every chapter starts with an explanation of the methodology and then the authors take the reader step by step through the implementation of the methods in Excel and VBA.
Read More

Author: Fabrice D. Rouah

Publisher: John Wiley & Sons

ISBN: 1118695178

Category: Business & Economics

Page: 432

View: 3332

Tap into the power of the most popular stochastic volatility model for pricing equity derivatives Since its introduction in 1993, the Heston model has become a popular model for pricing equity derivatives, and the most popular stochastic volatility model in financial engineering. This vital resource provides a thorough derivation of the original model, and includes the most important extensions and refinements that have allowed the model to produce option prices that are more accurate and volatility surfaces that better reflect market conditions. The book's material is drawn from research papers and many of the models covered and the computer codes are unavailable from other sources. The book is light on theory and instead highlights the implementation of the models. All of the models found here have been coded in Matlab and C#. This reliable resource offers an understanding of how the original model was derived from Ricatti equations, and shows how to implement implied and local volatility, Fourier methods applied to the model, numerical integration schemes, parameter estimation, simulation schemes, American options, the Heston model with time-dependent parameters, finite difference methods for the Heston PDE, the Greeks, and the double Heston model. A groundbreaking book dedicated to the exploration of the Heston model—a popular model for pricing equity derivatives Includes a companion website, which explores the Heston model and its extensions all coded in Matlab and C# Written by Fabrice Douglas Rouah a quantitative analyst who specializes in financial modeling for derivatives for pricing and risk management Engaging and informative, this is the first book to deal exclusively with the Heston Model and includes code in Matlab and C# for pricing under the model, as well as code for parameter estimation, simulation, finite difference methods, American options, and more.
Read More

Author: Simon Benninga,Benjamin Czaczkes

Publisher: MIT Press

ISBN: 0262027283

Category: Business & Economics

Page: 1144

View: 7677

A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners.
Read More

Modeling and Pricing for Agriculturals, Metals and Energy

Author: Helyette Geman

Publisher: John Wiley & Sons

ISBN: 9780470687734

Category: Business & Economics

Page: 416

View: 7378

The last few years have been a watershed for the commodities, cash and derivatives industry. New regulations and products have led to an explosion in the commodities markets, creating a new asset for investors that includes hedge funds as well as University endowments, and has resulted in a spectacular growth in spot and derivative trading. This book covers hard and soft commodities (energy, agriculture and metals) and analyses: Economic and geopolitical issues in commodities markets Commodity price and volume risk Stochastic modelling of commodity spot prices and forward curves Real options valuation and hedging of physical assets in the energy industry It is required reading for energy companies and utilities practitioners, commodity cash and derivatives traders in investment banks, the Agrifood business, Commodity Trading Advisors (CTAs) and Hedge Funds. In Commodities and Commodity Derivatives, Hélyette Geman shows her powerful command of the subject by combining a rigorous development of its mathematical modelling with a compact institutional presentation of the arcane characteristics of commodities that makes the complex analysis of commodities derivative securities accessible to both the academic and practitioner who wants a deep foundation and a breadth of different market applications. It is destined to be a "must have" on the subject.” —Robert Merton, Professor, Harvard Business School "A marvelously comprehensive book of interest to academics and practitioners alike, by one of the world's foremost experts in the field." —Oldrich Vasicek, founder, KMV
Read More

Build Your Own Analytical Tools for Higher Returns

Author: Jeff Augen

Publisher: Cisco Press

ISBN: 9780132619547

Category: Business & Economics

Page: 224

View: 403

Trade more profitably by exploiting Microsoft Excel’s powerful statistical and data mining tools: · Uncover subtle anomalies and distortions that signal profit opportunities · Create powerful new custom indicators, alerts, and trading models · Visualize and analyze huge amounts of trading data with just a few clicks · Powerful techniques for every active investor who can use Excel Now that high-speed traders dominate the market, yesterday’s slower-paced analysis strategies are virtually worthless. To outperform, individual traders must discover fleeting market trends and inefficiencies and act on them before they disappear. Five years ago, this required multimillion-dollar data mining and analytical infrastructures. Today, traders can use Excel with the help of world-class trader Jeff Augen’s Microsoft Excel for Stock and Option Traders: Build your Own Analytical Tools for Higher Returns. Augen shows how to use Excel 2007 or 2010 to uncover hidden correlations and reliable trade triggers based on subtle anomalies and price distortions, create and test new hypotheses others haven’t considered, and visualize data to reveal insights others can’t see! "Jeff Augen turns things inside out in his remarkable and challenging book Microsoft Excel for Stock and Option Traders." - John A. Sarkett, SFO Magazine, October 2011
Read More

Model Design and Best Practices Using Excel and VBA

Author: Michael Rees

Publisher: John Wiley & Sons

ISBN: 1118904001

Category: Business & Economics

Page: 544

View: 7480

The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling – Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking Sensitivity and scenario analysis, simulation, and optimisation Data manipulation and analysis The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds.
Read More

Business, Finance

Author: CTI Reviews

Publisher: Cram101 Textbook Reviews

ISBN: 1467228214

Category: Education

Page: 26

View: 544

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.
Read More

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 9780471267683

Category: Business & Economics

Page: 857

View: 6202

"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.
Read More

Author: Gordon F. Peery

Publisher: John Wiley & Sons

ISBN: 0470553715

Category: Business & Economics

Page: 362

View: 9743

An in-depth look at the best ways to navigate the post-reform world of derivatives and futures The derivatives market is one of the largest, and most important financial markets in the world. It's also one of the least understood. Today we are witnessing the unprecedented reform and reshaping of this market, and along with these events, the entire life cycle of a derivatives transaction has been affected. Accordingly, nearly all market participants in the modern economy need to view the handling of risk by derivatives in a very different way. Many aspects of financial services reform are based on a belief that derivatives caused the Great Recession of 2008. While the difficulties we now face cannot be blamed solely on derivatives, the need to understand this market, and the financial products that trade within it, has never been greater. The Post-Reform Guide to Derivatives and Futures provides straightforward descriptions of these important investment products, the market in which they trade, and the law that now, after July 16, 2011, governs their use in America and creates challenges for investors throughout the world. Author Gordon Peery is an attorney who works exclusively in the derivatives markets and specializes in derivatives and futures reform and market structure. Since representing clients in Congressional hearings involving Enron Corp., he has developed extensive experience in this field. With this guide, he reveals how derivatives law, and market practice throughout the world, began to change in historic ways beginning in 2011, and what you must do to keep up with these changes. Explains what derivatives and futures are, who trades them, and what must be done to manage risk in the post reform world Accurately reflects the futures and derivatives markets as they exist today and how they will be transformed by the Dodd-Frank Wall Street Reform and Consumer Protection Act Highlights the risks and common disputes regarding derivatives and futures, and offers recommendations for best practices in light of the evolving law governing derivatives The financial crisis has changed the rules of Wall Street, especially when it comes to derivatives and futures. The Post-Reform Guide to Derivatives and Futures will help you navigate this evolving field and put you in a better position to make the most informed decisions within it.
Read More

Author: Espen Gaarder Haug

Publisher: John Wiley & Sons

ISBN: 1118836820

Category: Business & Economics

Page: 384

View: 9846

Derivatives Models on Models takes a theoretical and practical look at some of the latest and most important ideas behind derivatives pricing models. In each chapter the author highlights the latest thinking and trends in the area. A wide range of topics are covered, including valuation methods on stocks paying discrete dividend, Asian options, American barrier options, Complex barrier options, reset options, and electricity derivatives. The book also discusses the latest ideas surrounding finance like the robustness of dynamic delta hedging, option hedging, negative probabilities and space-time finance. The accompanying CD-ROM with additional Excel sheets includes the mathematical models covered in the book. The book also includes interviews with some of the world’s top names in the industry, and an insight into the history behind some of the greatest discoveries in quantitative finance. Interviewees include: Clive Granger, Nobel Prize winner in Economics 2003, on Cointegration Nassim Taleb on Black Swans Stephen Ross on Arbitrage Pricing Theory Emanuel Derman the Wall Street Quant Edward Thorp on Gambling and Trading Peter Carr the Wall Street Wizard of Option Symmetry and Volatility Aaron Brown on Gambling, Poker and Trading David Bates on Crash and Jumps Andrei Khrennikov on Negative Probabilities Elie Ayache on Option Trading and Modeling Peter Jaeckel on Monte Carlo Simulation Alan Lewis on Stochastic Volatility and Jumps Paul Wilmott on Paul Wilmott Knut Aase on Catastrophes and Financial Economics Eduardo Schwartz the Yoga Master of Quantitative Finance Bruno Dupire on Local and Stochastic Volatility Models
Read More

Master the Market with Confidence, Discipline, and a Winning Attitude

Author: Mark Douglas

Publisher: Penguin

ISBN: 9781440625411

Category: Business & Economics

Page: 240

View: 1504

Douglas uncovers the underlying reasons for lack of consistency and helps traders overcome the ingrained mental habits that cost them money. He takes on the myths of the market and exposes them one by one teaching traders to look beyond random outcomes, to understand the true realities of risk, and to be comfortable with the "probabilities" of market movement that governs all market speculation.
Read More