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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 14 Ratings

A Cookbook for Financial Modellers - 2005-10-19
Reviewer Rating:
Yes, the book won't teach you CAPM, Black-Scholes, or much financial theory. But there is NO shortage of those books. There is a shortage of books with real-world Excel solutions to applying financial theory to data. I've had this book for a couple of years and have probably only used 10% of it, only because I don't have time, real business need, to do the rest. I sometimes take it to bed to read and dream of having the time to try out some of their other models. That's the only thing I can add to the other reviews here, the amount of love and passion for the subject put into this book. There's not one extra padded word or graphic in this book. Yes, if there was one book I'd have to take to a desert island with Excel and some financial data this would be it.

Not worth buying, don't get fooled by the reviews - 2008-06-11
Reviewer Rating:
Have a look first before buying. I am surprised by the 5 stars reviews!
To summarize, it is like a very simple recipes book about some models in finance. It is not to teach you VBA, and definitely will not teach you anything about finance. It is a collection of VBA implementation of some algorithms used in finance.
The algorithms implemented are the simple ones, mostly of no practical use.
You better buy a VBA book and Hull. If you are however, more knowledgeable about the topic, buy Justin London book, modeling derivatives in C++.

This book will not teach you anything, and the code included will not help you. there is much better code available online for free.

A good book for beginners - 2009-09-09
Reviewer Rating:
I actually found this book very helpful. The explanations were incredibly accessible and thorough. I did not use the accompanying disc, but I'm sure it's helpful as well, given the examples that the book goes through appear fairly straight forward.

Advance Modelling in Finance purchase - 2009-05-25
Reviewer Rating:
right on hands ont he job, useful material, most of the book are applications so that is just what people looking for practical apps are looking for, no excess theorie alreasdy known to practicioners, excellent

Absolutely Great! - 2006-01-11
Reviewer Rating:
Advanced Modeling is a fantastic book, and pretty easy to follow with relatively few coding errors. There are some books out there that have errors in the code that they use, which makes it difficult or someone to learn the techniques. Even for those without a solid background in VBA, this book can benefit you to start learning how to code properly. Anyone who is relatively proficient with Excel can definitely gain a new trick or two from reading this book. All you really need to start using this book is a basic understanding of finance concepts (e.g. portolio theory, capital budgeting, binomial options pricing, Black-Scholes, etc.). The techniques that are taught are also useful in other modeling exercises, and not necessarily just for finance-related topics.

Browse Similar Topics

Top Level Categories:
Desktop Applications
Programming

Sub-Categories:
Desktop Applications > Excel
Programming > Visual Basic for Applications