Advanced Modelling in Finance using Excel and VBA and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 8.00 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Advanced Modelling in Finance using Excel and VBA on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Advanced Modelling in Finance Using Excel and VBA (The Wiley Finance Series) [Hardcover]

Mary Jackson , Mike Staunton
3.2 out of 5 stars  See all reviews (6 customer reviews)
RRP: 75.00
Price: 56.54 & FREE Delivery in the UK. Details
You Save: 18.46 (25%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 7 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 1 Sept.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 48.99  
Hardcover 56.54  
Paperback --  
Trade In this Item for up to 8.00
Trade in Advanced Modelling in Finance Using Excel and VBA (The Wiley Finance Series) for an Amazon Gift Card of up to 8.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

20 April 2001 The Wiley Finance Series (Book 254)
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.

Frequently Bought Together

Advanced Modelling in Finance Using Excel and VBA (The Wiley Finance Series) + Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Buy the selected items together

Product details

  • Hardcover: 276 pages
  • Publisher: John Wiley & Sons; Har/Cdr edition (20 April 2001)
  • Language: English
  • ISBN-10: 0471499226
  • ISBN-13: 978-0471499220
  • Product Dimensions: 26 x 17 x 2 cm
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: 55,461 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description


No. 4 bestseller in ′General Finance′ (, December 2001)

From the Author

We only use macros where VBA functions cannot be used (such as for charts and Solver). For everything else, the spreadsheets are complemented with scores of VBA user-defined functions that do everything up to and including solving for eigenvalues and option valuation using binomial trees with thousands of steps. In particular, chapter 12 uses simulation to value options and the asociated VBA user-defined functions include both antithetic-variate and quasi-random numbers (with not a macro in sight)

Inside This Book (Learn More)
First Sentence
The purpose of this chapter is to review certain Excel functions and procedures used in text. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.2 out of 5 stars
3.2 out of 5 stars
Most Helpful Customer Reviews
31 of 32 people found the following review helpful
2.0 out of 5 stars a reader from London 20 May 2004
There are two things this book won't teach you one is modelling and the other VBA. One would be far better off buying John Hull's book on derivatives or something of a sort and a book on VBA with Excel separately. To understand this book well you need a prior knowledge of both Financial math and VBA/Excel but if you have that already why would you need this book on the first place? I have to admit I was misled by the previous reviews - all were very good. Finally a lot of my colleagues have the book on their desks and how new these books look as if they've never been open before, draw your own conclusion.
Comment | 
Was this review helpful to you?
34 of 38 people found the following review helpful
5.0 out of 5 stars Superb 25 July 2001
A fantstic book on Excel modelling for Equities, Equity Options, and Bond Options that fills the lack of books on this topic nicely.
It's probably best to compare it to Beninga's „Financial Modelling". It differs in many ways though. It's more compact (250 pages instead of 600), with less detailed explanations, leaves Corporate Finance completely out, and covers fewer topics but to a more advanced step.
The book deserves definitely „advanced", since the equity section was developed for an MBA elective at London Business School. The parts on options and bonds compromise a course for the MSc in Mathematical Trading & Finance at City University Business School.
Standard material covered: porfolio theory and efficient frontiers / the CAPM, beta and covariance matrices / performance measurement / the Black & Scholes formula / binomial trees for equity and bond options / Monte Carlo simulation / bond yield-to-maturity, duration and convexity / term structure models from Vasicek and Cox, Ingersoll and Ross.
Advanced topics: value at risk / style analysis / an improved binomial tree (Leisen&Refmer) / quasi Monte Carlo simulation / volatility smiles / Black, Derman & Toy trees / normal interest rate trees.
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
5.0 out of 5 stars Very good indeed... 12 Sep 2002
Excellent for those interested on Excel/VBA modelling. It's compact, clear, easy to follow and to understand. It covers all you need to know from portfolio theory to more advanced topics such as VAR, volatilities smiles and normal interest rate trees. Good spreadsheets examples and VBA functions in the CD-ROM. It's probably not so good for advanced programmers but it's an excellent book for those who want to develop their knolewdge of modelling in finance. I liked it very much...well done !
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category