Skip to content

Advanced Modelling in Finance Using Excel and VBA [With CDROM]
Stock Photo: Cover May Be Different

Advanced Modelling in Finance Using Excel and VBA [With CDROM] Hardcover - 2001

by Mary Jackson; Mike Staunton


From the publisher

Dieses neue und einzigartige Buch macht deutlich, da Excel und VBA (Visual Basic fr Applikationen) eine wichtige Rolle in der Finanzwelt spielen bei der Erluterung und Implementierung numerischer Methoden. "Advanced Modelling in Finance" behandelt detailliert Aktien, Aktienoptionen und Rentenoptionen der frhen 50er bis in die spten 90er Jahre. Dabei fhren die Autoren schrittweise ein die komplexeren Aspekte der Excel- und VBA-Programmierung und erlutern, wie diese Programmierungsverfahren bei Aktien, Renten und Optionen zur Modellierung oder Manipulierung von Finanzdaten eingesetzt werden knnen. In der modernen Finanzwelt gewinnen Analysen und die Entwicklung von immer komplexeren "was wre wenn"-Szenarios immer mehr an Bedeutung. Deshalb ist dieses Buch die ideale Lektre fr Finanzexperten, die ihre Fertigkeiten im Bereich finanzwirtschaftliche Modellbildung verbessern mssen. Es liefert das ntige Know-How und Praxiswissen. Die beigefgte CD-ROM, enthlt die komplette Software fr die besprochenen Beispiele.

First line

The purpose of this chapter is to review certain Excel functions and procedures used in text.

From the rear cover

Advanced modelling in finance using Excel and VBA

Mary Jackson and Mike Staunton

This book will appeal to both graduate students and practitioners. Students will value the Excel spreadsheets allowing them to develop their knowledge of modelling in finance, using a step-by-step approach accompanied by explanations using elementary mathematical statistics and probability. Practitioners will value the VBA functions as a source of up-to-date and efficient programs that can be easily used from Excel.

Standard material rovered includes:

  • portfolio theory and efficient frontiers
  • the Capital Asset Pricing Model, beta and variance-covariance matrices
  • performance measurement
  • the Black-Scholes option pricing formula
  • binomial trees for options on equities and bonds
  • Monte Carlo simulation
  • bond yield-to-maturity, duration and convexity
  • term structure models from Vasicek and Cox, Ingersoll and Ross

Advanced topics covered include:

  • Value-at-Risk
  • style analysis
  • an improved binomial tree (Leisen & Reimer)
  • quasi Monte Carlo simulation
  • volatility smiles
  • Black, Derman & Toy trees
  • normal interest rate trees

Details

  • Title Advanced Modelling in Finance Using Excel and VBA [With CDROM]
  • Author Mary Jackson; Mike Staunton
  • Binding Hardcover
  • Edition Har/Cdr
  • Pages 288
  • Volumes 1
  • Language ENG
  • Publisher Wiley, USA
  • Date 2001-06-08
  • Features Dust Cover, Index, Table of Contents
  • ISBN 9780471499220 / 0471499226
  • Weight 1.51 lbs (0.68 kg)
  • Dimensions 10.27 x 6.65 x 0.94 in (26.09 x 16.89 x 2.39 cm)
  • Library of Congress subjects Finance - Mathematical models
  • Library of Congress Catalog Number 00069327
  • Dewey Decimal Code 332.015

Media reviews

Citations

  • Reference and Research Bk News, 11/01/2001, Page 113

About the author

MARY JACKSON and MIKE STAUNTON have worked together teaching spreadsheet modelling to both graduate students and practitioners since 1985.

MARY JACKSON was Assistant Professor of Decision Sciences at London Business School. She is author of three previous books for John Wiley & Sons: Understanding Expert Systems (1992), Advanced Spreadsheet Modelling (1988) and Creative Modelling (1985).

MIKE STAUNTON is Visiting Lecturer in Numerical Methods at City University Business School and Director of the London Share Price Datbase at London Business School. He is coauthor, with Elroy Dimson and Paul Marsh, of Millennium Book II: 101 Years of Investment Returns (2001) and The Millennium Book: A Century of Investment Returns (2000).

Back to Top

More Copies for Sale

Advanced modelling in finance using Excel and VBA
Stock Photo: Cover May Be Different

Advanced modelling in finance using Excel and VBA

by Mary Jackson

  • Used
Condition
UsedGood
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Annandale, New Jersey, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$4.55
A$6.07 shipping to USA

Show Details

Description:
UsedGood. The dust jacket shows normal wear. Fast shipping and order satisfaction guaranteed. A portion of your purchase benefits Non-Profit Organizations, First Aid and Fire Stations!
Item Price
A$4.55
A$6.07 shipping to USA
Advanced modelling in finance using Excel and VBA
Stock Photo: Cover May Be Different

Advanced modelling in finance using Excel and VBA

by Mary Jackson, Mike Staunton

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Frederick, Maryland, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$8.88
A$6.07 shipping to USA

Show Details

Description:
Wiley. Used - Good. Good condition. Good dust jacket. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included.
Item Price
A$8.88
A$6.07 shipping to USA
Advanced modelling in finance using Excel and VBA
Stock Photo: Cover May Be Different

Advanced modelling in finance using Excel and VBA

by Mary Jackson; Mike Staunton

  • Used
  • Good
  • first
Condition
Used - Good
Edition
First Edition
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Philadelphia, Pennsylvania, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$9.97
FREE shipping to USA

Show Details

Description:
Wiley. First Edition. Good. Good. Supplements included Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported
Item Price
A$9.97
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA
Stock Photo: Cover May Be Different

Advanced Modelling in Finance Using Excel and VBA

by Staunton, Mike, Jackson, Mary

  • Used
Condition
Used - Very Good
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$10.58
FREE shipping to USA

Show Details

Description:
Wiley & Sons, Incorporated, John. Used - Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects.
Item Price
A$10.58
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA [With CDROM]
Stock Photo: Cover May Be Different

Advanced Modelling in Finance Using Excel and VBA [With CDROM]

by Jackson, Mary; Staunton, Mike

  • Used
  • Good
  • Hardcover
Condition
Used - Good
Binding
Hardcover
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$10.58
FREE shipping to USA

Show Details

Description:
Wiley, 2001. Hardcover. Good. Former library book; Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$10.58
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA [With CDROM]

Advanced Modelling in Finance Using Excel and VBA [With CDROM]

by Jackson, Mary; Staunton, Mike

  • Used
  • Good
  • Hardcover
Condition
Used - Good
Binding
Hardcover
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$10.58
FREE shipping to USA

Show Details

Description:
Wiley, 2001. Hardcover. Good. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$10.58
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA [With CDROM]

Advanced Modelling in Finance Using Excel and VBA [With CDROM]

by Jackson, Mary; Staunton, Mike

  • Used
  • Very Good
  • Hardcover
Condition
Used - Very Good
Binding
Hardcover
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$10.58
FREE shipping to USA

Show Details

Description:
Wiley, 2001. Hardcover. Very Good. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$10.58
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA [With CDROM]

Advanced Modelling in Finance Using Excel and VBA [With CDROM]

by Jackson, Mary; Staunton, Mike

  • Used
  • Good
  • Hardcover
Condition
Used - Good
Binding
Hardcover
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$10.58
FREE shipping to USA

Show Details

Description:
Wiley, 2001. Hardcover. Good. Missing dust jacket; Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$10.58
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA
Stock Photo: Cover May Be Different

Advanced Modelling in Finance Using Excel and VBA

by Staunton, Mike, Jackson, Mary

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$10.70
FREE shipping to USA

Show Details

Description:
Wiley & Sons, Incorporated, John. Used - Good. Used book that is in clean, average condition without any missing pages.
Item Price
A$10.70
FREE shipping to USA
Advanced Modelling in Finance Using Excel and VBA
Stock Photo: Cover May Be Different

Advanced Modelling in Finance Using Excel and VBA

by Staunton, Mike, Jackson, Mary

  • Used
Condition
Used - Very Good
ISBN 10 / ISBN 13
9780471499220 / 0471499226
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$11.27
FREE shipping to USA

Show Details

Description:
Wiley & Sons Australia, Limited, John. Used - Very Good. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects.
Item Price
A$11.27
FREE shipping to USA