Advanced Modelling in Finance using Excel and VBA

Advanced Modelling in Finance using Excel and VBA

Advanced modelling in finance using Excel and VBA Mary Jackson and Mike Staunton This book will appeal to both graduate students and practitioners.

Author: Mary Jackson

Publisher: John Wiley & Sons

ISBN: 9780470061664

Category: Business & Economics

Page: 276

View: 265

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.
Categories: Business & Economics

Financial Analysis and Modeling Using Excel and VBA

Financial Analysis and Modeling Using Excel and VBA

PRAISE FOR THE FIRST EDITION OF FINANCIAL ANALYSIS AND MODELING USING EXCEL AND VBA "Excel and VBA have vast capabilities, yet until this book, users were on their own to figure out just how to use these tools for both single and complex ...

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 9780470275603

Category: Business & Economics

Page: 793

View: 294

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.
Categories: Business & Economics

Risk Analysis

Risk Analysis

Modelling Extreme Events for Insurance and Finance. New York, NY: Springer. ... Financial risk Brealey, R. M. and Myers, S. C. (2000). Principles of Corporate Finance, 6th edition. ... Advanced Modelling in Finance Using Excel and VBA.

Author: David Vose

Publisher: John Wiley & Sons

ISBN: 9780470512845

Category: Business & Economics

Page: 752

View: 714

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.
Categories: Business & Economics

Financial Modeling

Financial Modeling

An Introductory Guide to Excel and VBA Applications in Finance Joachim Häcker, Dietmar Ernst ... Jackson, M., Staunton, M. (2001) Advanced Modelling in Finance Using Excel and VBA (Chichester: Wiley & Sons). Lynch, P. (2010) Financial ...

Author: Joachim Häcker

Publisher: Springer

ISBN: 9781137426581

Category: Business & Economics

Page: 956

View: 438

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.
Categories: Business & Economics

Frequently Asked Questions in Quantitative Finance

Frequently Asked Questions in Quantitative Finance

Advanced Modelling in Finance Using Excel and VBA by Mary Jackson and Mike Staunton Publisher John Wiley & Sons Ltd Publication date 2001 Format Hardback + CD ISBN 9780471499220 macros and VBA programming, showing how these programming ...

Author: Paul Wilmott

Publisher: John Wiley & Sons

ISBN: 9780470685143

Category: Business & Economics

Page: 624

View: 233

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.
Categories: Business & Economics

Financial Applications using Excel Add in Development in C C

Financial Applications using Excel Add in Development in C   C

Mineola, NY: Dover Publications, Inc. Bullen, S., Bovey, R. and Green, S. (2005) Professional Excel Development. Boston. ... Ltd. Jackson, M. and Staunton, M. (2001) Advanced Modelling in Finance Using Excel and VBA.

Author: Steve Dalton

Publisher: John Wiley & Sons

ISBN: 9780470027974

Category: Business & Economics

Page: 584

View: 108

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.
Categories: Business & Economics

Financial Products

Financial Products

An Introduction Using Mathematics and Excel Bill Dalton. further. • Schönbucher, Philipp J., Credit Derivatives ... subjectusing the differential equation approach. For Excel: Advanced Modelling in Finance using Excel and VBA, Mary Jackson.

Author: Bill Dalton

Publisher: Cambridge University Press

ISBN: 1139474057

Category: Business & Economics

Page: 408

View: 695

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.
Categories: Business & Economics

Credit Risk Modeling using Excel and VBA

Credit Risk Modeling using Excel and VBA

Credit risk modeling using Excel and VBA Second Edition Gunter Löffler and Peter N. Posch This book provides practitioners and students with a hands-on introduction to modern credit risk modeling.

Author: Gunter Löeffler

Publisher: John Wiley & Sons

ISBN: 9780470660928

Category: Business & Economics

Page: 358

View: 851

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.
Categories: Business & Economics

Copula Methods in Finance

Copula Methods in Finance

... and Using Dynamic Interest Rate Models Ken Kortanek and Vladimir Medvedev Structured Equity Derivatives: The Definitive Guide to Exotic Options and Structured Notes Harry Kat Advanced Modelling in Finance Using Excel and VBA Mary ...

Author: Umberto Cherubini

Publisher: John Wiley & Sons

ISBN: 9780470863459

Category: Business & Economics

Page: 310

View: 680

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.
Categories: Business & Economics

Applied C in Financial Markets

Applied C  in Financial Markets

... and Using Dynamic Interest Rate Models Ken Kortanek and Vladimir Medvedev Structured Equity Derivatives: The Definitive Guide to Exotic Options and Structured Notes Harry Kat Advanced Modelling in Finance Using Excel and VBA Mary ...

Author: Martin Worner

Publisher: John Wiley & Sons

ISBN: 9780470870624

Category: Business & Economics

Page: 138

View: 894

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.
Categories: Business & Economics