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.
Provides a comprehensive guide for anyone who has to undertake financial analysis, or understand and implement financial models. Discusses a wide range of real-world financial problems and models using Excel 2007 and Visual Basic for Applications (VBA). Provides reference to earlier versions of Excel and VBA, and includes a CD-Rom with modelling tools and working versions of models discussed.
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.
It is common to blame the inadequacy of credit risk models for the fact that the financial crisis has caught many market participants by surprise. On closer inspection, though, it often appears that market participants failed to understand or to use the models correctly. The recent events therefore do not invalidate traditional credit risk modeling as described in the first edition of the book. A second edition is timely, however, because the first dealt relatively briefly with instruments featuring prominently in the crisis (CDSs and CDOs). In addition to expanding the coverage of these instruments, the book will focus on modeling aspects which were of particular relevance in the financial crisis (e.g. estimation error) and demonstrate the usefulness of credit risk modelling through case studies. 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. They focus specifically on risk management issues and cover default probability estimation (scoring, structural models, and transition matrices), correlation and portfolio analysis, validation, as well as credit default swaps and structured finance. The book has an accompanying website, http://loeffler-posch.com/, which has been specially updated for this Second Edition and contains slides and exercises for lecturers.
Risk Analysis concerns itself with the quantification of risk, the modeling of identified risks and how to make decisions from those models. Quantitative risk analysis (QRA) using Monte Carlo simulation offers a powerful and precise method for dealing with the uncertainty and variability of a problem. By providing the building blocks the author guides the reader through the necessary steps to produce an accurate risk analysis model and offers general and specific techniques to cope with most modeling problems. A wide range of solved problems is used to illustrate these techniques and how they can be used together to solve otherwise complex problems.
This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors of finance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.
Getting agreement between finance theory and finance practice is important like never before. In the last decade the derivatives business has grown to a staggering size, such that the outstanding notional of all contracts is now many multiples of the underlying world economy. No longer are derivatives for helping people control and manage their financial risks from other business and industries, no, it seems that the people are toiling away in the fields to keep the derivatives market afloat! (Apologies for the mixed metaphor!) If you work in derivatives, risk, development, trading, etc. you'd better know what you are doing, there's now a big responsibility on your shoulders. In this second edition of Frequently Asked Questions in Quantitative Finance I continue in my mission to pull quant finance up from the dumbed-down depths, and to drag it back down to earth from the super-sophisticated stratosphere. Readers of my work and blogs will know that I think both extremes are dangerous. Quant finance should inhabit the middle ground, the mathematics sweet spot, where the models are robust and understandable, and easy to mend. ...And that's what this book is about. This book contains important FAQs and answers that cover both theory and practice. There are sections on how to derive Black-Scholes (a dozen different ways!), the popular models, equations, formulae and probability distributions, critical essays, brainteasers, and the commonest quant mistakes. The quant mistakes section alone is worth trillions of dollars! I hope you enjoy this book, and that it shows you how interesting this important subject can be. And I hope you'll join me and others in this industry on the discussion forum on wilmott.com. See you there!” FAQQF2...including key models, important formulae, popular contracts, essays and opinions, a history of quantitative finance, sundry lists, the commonest mistakes in quant finance, brainteasers, plenty of straight-talking, the Modellers' Manifesto and lots more.
Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer.Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VBA and C/C++. This is the only complete how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It also covers the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD-ROM. The impact of Excel 2007’s multi-threaded workbook calculations and large grids on add-in development are fully explored. Financial Applications using Excel Add-in Development in C/C++ features: Extensive example codes in VBA, C and C++, explaining all the ways in which a developer can achieve their objectives. Example projects that demonstrate, from start to finish, the potential of Excel when powerful add-ins can be easily developed. Develops the readers understanding of the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++. A CD-ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.
Financial Products provides a step-by-step guide to some of the most important ideas in financial mathematics. It describes and explains interest rates, discounting, arbitrage, risk neutral probabilities, forward contracts, futures, bonds, FRA and swaps. It shows how to construct both elementary and complex (Libor) zero curves. Options are described, illustrated and then priced using the Black Scholes formula and binomial trees. Finally, there is a chapter describing default probabilities, credit ratings and credit derivatives (CDS, TRS, CSO and CDO). An important feature of the book is that it explains this range of concepts and techniques in a way that can be understood by those with only a basic understanding of algebra. Many of the calculations are illustrated using Excel spreadsheets, as are some of the more complex algebraic processes. This accessible approach makes it an ideal introduction to financial products for undergraduates and those studying for professional financial qualifications.
Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on). It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM. Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Copula Methods in Finance is the first book to address the mathematics of copula functions illustrated with finance applications. It explains copulas by means of applications to major topics in derivative pricing and credit risk analysis. Examples include pricing of the main exotic derivatives (barrier, basket, rainbow options) as well as risk management issues. Particular focus is given to the pricing of asset-backed securities and basket credit derivative products and the evaluation of counterparty risk in derivative transactions.
Applied C# in Financial Markets covers all the aspects of C# relevant to practitioners working in financial sector. It contains a practical workshop which builds on the material in the book, guiding you through all the stages of building a multiple model options calculator. An accompanying website features examples, illustrations and solutions to the workshops and a downloadable application to complement the book. Features examples and illustrations taken from a sample trading application, making the book relevant to those working in the financial markets. Provides a quick start to C# for financial professionals to hit the ground running in building financial applications. Workshops illustrate building an options calculator, exploring the various elements in C# as they progress.
Volume 3 of the Encyclopedia of FinancialModels The need for serious coverage of financial modeling has neverbeen greater, especially with the size, diversity, and efficiencyof modern capital markets. With this in mind, the Encyclopediaof Financial Models has been created to help a broad spectrumof individuals—ranging from finance professionals toacademics and students—understand financial modeling and makeuse of the various models currently available. Incorporating timely research and in-depth analysis, Volume3 of the Encyclopedia of Financial Models covers bothestablished and cutting-edge models and discusses their real-worldapplications. Edited by Frank Fabozzi, this volume includescontributions from global financial experts as well as academicswith extensive consulting experience in this field. Organizedalphabetically by category, this reliable resource consists offorty-four informative entries and provides readers with a balancedunderstanding of today’s dynamic world of financialmodeling. Volume 3 covers Mortgage-Backed Securities Analysisand Valuation, Operational Risk, Optimization Tools, ProbabilityTheory, Risk Measures, Software for Financial Modeling, StochasticProcesses and Tools, Term Structure Modeling, Trading CostModels, and Volatility Emphasizes both technical and implementation issues, providingresearchers, educators, students, and practitioners with thenecessary background to deal with issues related to financialmodeling The 3-Volume Set contains coverage of the fundamentals andadvances in financial modeling and provides the mathematical andstatistical techniques needed to develop and test financialmodels Financial models have become increasingly commonplace, as wellas complex. They are essential in a wide range of financialendeavors, and the Encyclopedia of Financial Models willhelp put them in perspective.
In order to operate their lending business profitably, banks must know all the costs involved in granting loans. In particular, all the expenses they incur in covering losses must be included. Provided loan risks can be calculated, it is possible in each case to charge a price that is appropriately adjusted for risk, thus making it possible to make high-risk loans. In "Risk-adjusted Lending Conditions" the author presents a model, to measure and calculate loan risks, showing how it functions and how it may be applied. His approach has its origins in the ideas put forward by Black/Scholes in 1973, and thus owes much to option price theory. From this the author has succeeded in developing a solution such that, whatever a company's debt position and however its balance sheet may be structured, any situation can be individually assessed. Building on this, he demonstrates how combinations of loans with the lowest possible interest costs can be tailor-made for any company. The book contains numerous examples, making it easy for practising bankers to see how the model may be applied
Active Investment Management looks at where active management has come from, where it is today, what problems it faces and where the answers to these questions are leading it. The book addresses the major issues concerning the key groups within the industry. Charles Jackson's wonderfully readable book will be essential reading for the practitioner and is broken down into five sections covering the whole spectrum of active investment management: * asset classes and products * balancing risk and return * active product selection * the nature of skill * the price of skill .
The most up-to-date resource on market risk methodologies Financial professionals in both the front and back office require an understanding of market risk and how to manage it. Measuring Market Risk provides this understanding with an overview of the most recent innovations in Value at Risk (VaR) and Expected Tail Loss (ETL) estimation. This book is filled with clear and accessible explanations of complex issues that arise in risk measuring-from parametric versus nonparametric estimation to incre-mental and component risks. Measuring Market Risk also includes accompanying software written in Matlab—allowing the reader to simulate and run the examples in the book.
This book provides a comprehensive introduction to the global capital markets, explaining the key instruments used in the markets and their practical applications. Containing numerous illustrations and examples it explains how each product or instrument is structured, how it is used in practice, what the principle risks are and how these are monitored and controlled. An Introduction to Capital Markets is an ideal resource for those wanting to understand how the global capital markets operate.
Expert advice and timely techniques for surviving and thriving within currency markets Rapid movements in currency markets have been a common occurrence in recent years, often to the detriment of traders and investors. The ability to manage these fluctuations is essential for safe and successful investment in these markets. Currency Strategy develops new techniques and explains classic tools available for predicting, managing, and optimizing fluctuations in the currency markets. Author Callum Henderson shows readers how traditional macroeconomic theory has repeatedly failed in the face of practical experience in these markets and develops a new approach based on experience. He draws on the technical expertise of his bank to develop mathematical models to assist in the prediction of crises and gives practical advice on how to use these and other tools successfully.
An Arbitrage Guide to Financial Markets is the first book to explicitly show the linkages of markets for equities, currencies, fixed income and commodities. Using a unique structural approach, it dissects all markets the same way: into spot, forward and contingent dimensions, bringing out the simplicity and the commonalities of all markets. The book shuns stochastic calculus in favor of cash flow details of arbitrage trades. All math is simple, but there is lots of it. The book reflects the relative value mentality of an institutional trader seeking profit from misalignments of various market segments. The book is aimed at entrants into investment banking and dealing businesses, existing personnel in non-trading jobs, and people outside of the financial services industry trying to gain a view into what drives dealers in today’s highly integrated marketplace. A committed reader is guaranteed to leave with a deep understanding of all current issues. "This is an excellent introduction to the financial markets by an author with a strong academic approach and practical insights from trading experience. At a time when the proliferation of financial instruments and the increased use of sophisticated mathematics in their analysis, makes an introduction to financial markets intimidating to most, this book is very useful. It provides an insight into the core concepts across markets and uses mathematics at an accessible level. It equips readers to understand the fundamentals of markets, valuation and trading. I would highly recommend it to anyone looking to understand the essentials of successfully trading, structuring or using the entire range of financial instruments available today." —Varun Gosain, Principal, Constellation Capital Management, New York "Robert Dubil, drawing from his extensive prior trading experience, has made a significant contribution by writing an easy to understand book about the complex world of today’s financial markets, using basic mathematical concepts. The book is filled with insights and real life examples about how traders approach the market and is required reading for anyone with an interest in understanding markets or a career in trading." —George Handjinicolaou, Partner, Etolian Capital, New York "This book provides an excellent guide to the current state of the financial markets. It combines academic rigour with the author’s practical experience of the financial sector, giving both students and practitioners an insight into the arbitrage pricing mechanism." —Zenji Nakamura, Managing Director, Europe Fixed Income Division, Nomura International plc, London