Advanced Modelling in Finance using Excel and VBA


Book Description

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.




Advanced Financial Modelling


Book Description

This book is a collection of state–of–the–art surveys on various topics in mathematical finance, with an emphasis on recent modelling and computational approaches. The volume is related to a 'Special Semester on Stochastics with Emphasis on Finance' that took place from September to December 2008 at the Johann Radon Institute for Computational and Applied Mathematics of the Austrian Academy of Sciences in Linz, Austria.




Financial Modelling in Practice


Book Description

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. --From publisher's description.




Financial Modelling


Book Description

Financial modelling Theory, Implementation and Practice with MATLAB Source Jörg Kienitz and Daniel Wetterau Financial Modelling - Theory, Implementation and Practice with MATLAB Source is a unique combination of quantitative techniques, the application to financial problems and programming using Matlab. The book enables the reader to model, design and implement a wide range of financial models for derivatives pricing and asset allocation, providing practitioners with complete financial modelling workflow, from model choice, deriving prices and Greeks using (semi-) analytic and simulation techniques, and calibration even for exotic options. The book is split into three parts. The first part considers financial markets in general and looks at the complex models needed to handle observed structures, reviewing models based on diffusions including stochastic-local volatility models and (pure) jump processes. It shows the possible risk-neutral densities, implied volatility surfaces, option pricing and typical paths for a variety of models including SABR, Heston, Bates, Bates-Hull-White, Displaced-Heston, or stochastic volatility versions of Variance Gamma, respectively Normal Inverse Gaussian models and finally, multi-dimensional models. The stochastic-local-volatility Libor market model with time-dependent parameters is considered and as an application how to price and risk-manage CMS spread products is demonstrated. The second part of the book deals with numerical methods which enables the reader to use the models of the first part for pricing and risk management, covering methods based on direct integration and Fourier transforms, and detailing the implementation of the COS, CONV, Carr-Madan method or Fourier-Space-Time Stepping. This is applied to pricing of European, Bermudan and exotic options as well as the calculation of the Greeks. The Monte Carlo simulation technique is outlined and bridge sampling is discussed in a Gaussian setting and for Lévy processes. Computation of Greeks is covered using likelihood ratio methods and adjoint techniques. A chapter on state-of-the-art optimization algorithms rounds up the toolkit for applying advanced mathematical models to financial problems and the last chapter in this section of the book also serves as an introduction to model risk. The third part is devoted to the usage of Matlab, introducing the software package by describing the basic functions applied for financial engineering. The programming is approached from an object-oriented perspective with examples to propose a framework for calibration, hedging and the adjoint method for calculating Greeks in a Libor market model. Source code used for producing the results and analysing the models is provided on the author's dedicated website, http://www.mathworks.de/matlabcentral/fileexchange/authors/246981.




Financial Modeling, fifth edition


Book Description

A substantially updated new edition of the essential text on financial modeling, with revised material, new data, and implementations shown in Excel, R, and Python. Financial Modeling has become the gold-standard text in its field, an essential guide for students, researchers, and practitioners that provides the computational tools needed for modeling finance fundamentals. This fifth edition has been substantially updated but maintains the straightforward, hands-on approach, with an optimal mix of explanation and implementation, that made the previous editions so popular. Using detailed Excel spreadsheets, it explains basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds. This new edition offers revised material on valuation, second-order and third-order Greeks for options, value at risk (VaR), Monte Carlo methods, and implementation in R. The examples and implementation use up-to-date and relevant data. Parts I to V cover corporate finance topics, bond and yield curve models, portfolio theory, options and derivatives, and Monte Carlo methods and their implementation in finance. Parts VI and VII treat technical topics, with part VI covering Excel and R issues and part VII (now on the book’s auxiliary website) covering Excel’s programming language, Visual Basic for Applications (VBA), and Python implementations. Knowledge of technical chapters on VBA and R is not necessary for understanding the material in the first five parts. The book is suitable for use in advanced finance classes that emphasize the need to combine modeling skills with a deeper knowledge of the underlying financial models.




Advanced Financial Modelling


Book Description

Annotation This book is a collection of state-of-the-art surveys on various topics in mathematical finance, with an emphasis on recent modelling and computational approaches. The volume is related to a a ~Special Semester on Stochastics with Emphasis on Financea (TM) that took place from September to December 2008 at the Johann Radon Institute for Computational and Applied Mathematics of the Austrian Academy of Sciences in Linz, Austria




Advanced Modelling in Mathematical Finance


Book Description

This Festschrift resulted from a workshop on “Advanced Modelling in Mathematical Finance” held in honour of Ernst Eberlein’s 70th birthday, from 20 to 22 May 2015 in Kiel, Germany. It includes contributions by several invited speakers at the workshop, including several of Ernst Eberlein’s long-standing collaborators and former students. Advanced mathematical techniques play an ever-increasing role in modern quantitative finance. Written by leading experts from academia and financial practice, this book offers state-of-the-art papers on the application of jump processes in mathematical finance, on term-structure modelling, and on statistical aspects of financial modelling. It is aimed at graduate students and researchers interested in mathematical finance, as well as practitioners wishing to learn about the latest developments.




Financial Econometrics


Book Description

A comprehensive guide to financial econometrics Financial econometrics is a quest for models that describe financial time series such as prices, returns, interest rates, and exchange rates. In Financial Econometrics, readers will be introduced to this growing discipline and the concepts and theories associated with it, including background material on probability theory and statistics. The experienced author team uses real-world data where possible and brings in the results of published research provided by investment banking firms and journals. Financial Econometrics clearly explains the techniques presented and provides illustrative examples for the topics discussed. Svetlozar T. Rachev, PhD (Karlsruhe, Germany) is currently Chair-Professor at the University of Karlsruhe. Stefan Mittnik, PhD (Munich, Germany) is Professor of Financial Econometrics at the University of Munich. Frank J. Fabozzi, PhD, CFA, CFP (New Hope, PA) is an adjunct professor of Finance at Yale University’s School of Management. Sergio M. Focardi (Paris, France) is a founding partner of the Paris-based consulting firm The Intertek Group. Teo Jasic, PhD, (Frankfurt, Germany) is a senior manager with a leading international management consultancy firm in Frankfurt.




Financial Modeling


Book Description

Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. "Financial Modeling" bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial problems with spreadsheets. The CD-ROM contains Excel* worksheets and solutions to end-of-chapter exercises. 634 illustrations.




Using Excel for Business and Financial Modelling


Book Description

A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. • Provides the perfect mix of practice and theory • Helps you become a DIY Excel modelling specialist • Includes updates for Excel 2019/365 and Excel for Mac • May be used as an accompaniment to the author’s online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.