Hedge Fund Modeling and Analysis Using Excel and VBA

The second book in Darbyshire and Hampton’s Hedge Fund Modelling and Analysis series, Hedge Fund Modelling and Analysis Using MATLAB® takes advantage of the huge library of built-in functions and suite of financial and analytic packages available to MATLAB®. This allows for a more detailed analysis of some of the more computationally intensive and advanced topics, such as hedge fund classification, performance measurement and mean-variance optimisation. Darbyshire and Hampton’s first book in the series, Hedge Fund Modelling and Analysis Using Excel & and VBA, is seen as a valuable supplementary text to this book. Starting with an overview of the hedge fund industry the book then looks at a variety of commercially available hedge fund data sources. After covering key statistical techniques and methods, the book discusses mean-variance optimisation, hedge fund classification and performance with an emphasis on risk-adjusted return metrics. Finally, common hedge fund market risk management techniques, such as traditional Value-at-Risk methods, modified extensions and expected shortfall are covered. The book’s dedicated website, www.darbyshirehampton.com provides free downloads of all the data and MATLAB® source code, as well as other useful resources. Hedge Fund Modelling and Analysis Using MATLAB® serves as a definitive introductory guide to hedge fund modelling and analysis and will provide investors, industry practitioners and students alike with a useful range of tools and techniques for analysing and estimating alpha and beta sources of return, performing manager ranking and market risk management.

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).

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.

Use powerful C++ algorithms and Object Oriented Programming (OOP) to aid in hedge fund decision making Low interest rates, overcrowded markets and greater regulatory oversight are just some of the many reasons it is close to impossible for hedge funds to draw competitive returns. The solution for many hedge fund managers, quantitative investment analysts and risk managers is to adopt new technologies, platforms and programming languages to better manage their risks and maximise the benefits of their return profiles. Hedge Fund Modelling and Analysis is a full course in the latest analytic strategies for hedge fund investing, complete with a one-of-a-kind primer on both C++ and object oriented programming (OOP). Covering both basic and risk-adjusted performance measures, this practitioner's guide enables you to manage risk easily and make the most of key statistics with simple and advanced analysis techniques. This highly anticipated third book in the widely used Hedge Fund Modelling and Analysis series is the only guide available for applying the powerful C++ language to revolutionise hedge fund trading. Even if you've never worked with code before, the focused overview of C++ gives you everything you need to navigate the technical aspects of object oriented programming, which enables you to build sophisticated analysis programs from small units of reusable code. This book is your breakthrough introduction to winning with hedge funds in the new reality of trading. Jumpstart your new approach to beating the markets with: All the guidance and hands-on support you need to use quantitative strategies to optimise hedge fund decision-making. Illustrative modelling exercises and worked-out problems demonstrating what to expect when assessing risk and return factors in the real world. A companion website offering additional C++ programs, algorithms and data to download. Make reading Hedge Fund Modelling and Analysis your new routine and gain all the insight and relevant information you need to beat the markets.

"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

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

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.

Introducing Data Envelopment Analysis (DEA) – a quantitative approach to assess the performance of hedge funds, funds of hedge funds, and commmodity trading advisors. Steep yourself in this approach with this important new book by Greg Gregoriou and Joe Zhu. «This book steps beyond the traditional trade-off between single variables for risk and return in the determination of investment portfolios. For the first time, a comprehensive procedure is presented to compose portfolios using multiple measures of risk and return simultaneously. This approach represents a watershed in portfolio construction techniques and is especially useful for hedge fund and CTA offerings.» – Richard E. Oberuc, CEO, Burlington Hall Asset Management, Inc. Chairman, Foundation for Managed Derivatives Research Order your copy today!

This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These applications will build on the knowledge of Excel and VBA gained, expand the use of Access for data management tasks, as well as PowerPoint and Outlook for reporting and presentation tasks.

There s a buzzword that has quickly captured the imagination of product providers and investors alike: «hedge fund replication». In the broadest sense, replicating hedge fund strategies means replicating their return sources and corresponding risk exposures. However, there still lacks a coherent picture on what hedge fund replication means in practice, what its premises are, how to distinguish di erent approaches, and where this can lead us to. Serving as a handbook for replicating the returns of hedge funds at considerably lower cost, Alternative Beta Strategies and Hedge Fund Replication provides a unique focus on replication, explaining along the way the return sources of hedge funds, and their systematic risks, that make replication possible. It explains the background to the new discussion on hedge fund replication and how to derive the returns of many hedge fund strategies at much lower cost, it differentiates the various underlying approaches and explains how hedge fund replication can improve your own investment process into hedge funds. Written by the well known Hedge Fund expert and author Lars Jaeger, the book is divided into three sections: Hedge Fund Background, Return Sources, and Replication Techniques. Section one provides a short course in what hedge funds actually are and how they operate, arming the reader with the background knowledge required for the rest of the book. Section two illuminates the sources from which hedge funds derive their returns and shows that the majority of hedge fund returns derive from systematic risk exposure rather than manager «Alpha». Section three presents various approaches to replicating hedge fund returns by presenting the first and second generation of hedge fund replication products, points out the pitfalls and strengths of the various approaches and illustrates the mathematical concepts that underlie them. With hedge fund replication going mainstream, this book provides clear guidance on the topic to maximise returns.