Option Pricing Models and Volatility Using Excel-VBA

An A to Z options trading guide for the new millennium and the new economy Written by professional trader and quantitative analyst Euan Sinclair, Option Trading is a comprehensive guide to this discipline covering everything from historical background, contract types, and market structure to volatility measurement, forecasting, and hedging techniques. This comprehensive guide presents the detail and practical information that professional option traders need, whether they're using options to hedge, manage money, arbitrage, or engage in structured finance deals. It contains information essential to anyone in this field, including option pricing and price forecasting, the Greeks, implied volatility, volatility measurement and forecasting, and specific option strategies. Explains how to break down a typical position, and repair positions Other titles by Sinclair: Volatility Trading Addresses the various concerns of the professional options trader Option trading will continue to be an important part of the financial landscape. This book will show you how to make the most of these profitable products, no matter what the market does.

Comprehensive instruction on developing real-world financial models This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).

"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

In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how. They also call for quantitative expertise, including the ability to effectively apply mathematical modeling tools and techniques, in this case credit. Credit Risk Modeling using Excel and VBA with DVD provides practitioners with a hands on introduction to credit risk modeling. Instead of just presenting analytical methods it shows how to implement them using Excel and VBA, in addition to a detailed description in the text a DVD guides readers step by step through the implementation. The authors begin by showing how to use option theoretic and statistical models to estimate a borrowers default risk. The second half of the book is devoted to credit portfolio risk. The authors guide readers through the implementation of a credit risk model, show how portfolio models can be validated or used to access structured credit products like CDO’s. The final chapters address modeling issues associated with the new Basel Accord.

Presents inference and simulation of stochastic process in the field of model calibration for financial times series modelled by continuous time processes and numerical option pricing. Introduces the bases of probability theory and goes on to explain how to model financial times series with continuous models, how to calibrate them from discrete data and further covers option pricing with one or more underlying assets based on these models. Analysis and implementation of models goes beyond the standard Black and Scholes framework and includes Markov switching models, L?vy models and other models with jumps (e.g. the telegraph process); Topics other than option pricing include: volatility and covariation estimation, change point analysis, asymptotic expansion and classification of financial time series from a statistical viewpoint. The book features problems with solutions and examples. All the examples and R code are available as an additional R package, therefore all the examples can be reproduced.

Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you how to employ a range of the most commonly used analysis tools and techniques both in industry and academia, for understanding, identifying and managing risk as well as for quantifying return factors across several key investment strategies. The book is also suitable for use as a core textbook for specialised graduate level courses in hedge funds and alternative investments. The book provides hands-on coverage of the visual and theoretical methods for measuring and modelling hedge fund performance with an emphasis on risk-adjusted performance metrics and techniques. A range of sophisticated risk analysis models and risk management strategies are also described in detail. Throughout, coverage is supplemented with helpful skill building exercises and worked examples in Excel and VBA. The book's dedicated website, www.darbyshirehampton.com provides Excel spreadsheets and VBA source code which can be freely downloaded and also features links to other relevant and useful resources. A comprehensive course in hedge fund modelling and analysis, this book arms you with the knowledge and tools required to effectively manage your risks and to optimise the return profile of your investment style.

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.

Veteran options trader Dan Passarelli explains a new methodology for option trading and valuation. With an introduction to option basics as well as chapters on all types of spreads, put-call parity and synthetic options, trading volatility and studying volatility charts, and advanced option trading, Trading Option Greeks holds pertinent new information on how more accurate pricing can drive profit. Most options traders focus on strategies such as covered calls, vertical spreads, butterflies and condors, and so on. But traders often don't know how to use the «greeks»—the five factors that influence an option's price—to trade more effectively. The «greeks» (Delta, Gamma, Theta, Vega, Rho) are tools to measure minute changes in an option's price based on corresponding changes in: Interest rates Time to expiration Price changes in the underlying security Volatility Dividends Using the greeks can lead to more accurate pricing information that will alert an option trader to mispriced derivatives that can be exploited for profit. In straightforward language and making use of charts and examples, Passarelli explains how to use the greeks to be a better options trader.

The essential resource for the successful option trader High Performance Options Trading offers a fresh perspective on trading options from a seasoned options trader programmer/engineer, Leonard Yates. Drawing on twenty-five years of experience as an options trader and software programmer, Yates has written this straightforward guide. First he provides readers with a solid foundation to trading options, including an introduction to basic options terminology, a thorough explanation on how options are traded, and specific trading strategies. Accompanied by the OptionVue Educational website, this hands-on guide to the options market is a thorough and essential resource for any trader looking to increase his or her practical knowledge of options.

Commodity Option Pricing: A Practitioner’s Guide covers commodity option pricing for quantitative analysts, traders or structurers in banks, hedge funds and commodity trading companies. Based on the author’s industry experience with commodity derivatives, this book provides a thorough and mathematical introduction to the various market conventions and models used in commodity option pricing. It introduces the various derivative products typically traded for commodities and describes how these models can be calibrated and used for pricing and risk management. The book has been developed with input from traders and examples using real world data, together with relevant up to date academic research. The book includes practical descriptions of market conventions and quote codes used in commodity markets alongside typical products seen in broker quotes and used in calibration. Also discussed are commodity models and their mathematical derivation and volatility surface modelling for traded commodity derivatives. Gold, silver and other precious metals are addressed, including gold forward and gold lease rates, as well as copper, aluminium and other base metals, crude oil and natural gas, refined energy and electricity. There are also sections on the products encountered in commodities such as crack spread and spark spread options and alternative commodities such as carbon emissions, weather derivatives, bandwidth and telecommunications trading, plastics and freight. Commodity Option Pricing is ideal for anyone working in commodities or aiming to make the transition into the area, as well as academics needing to familiarize themselves with the industry conventions of the commodity markets.