![Advanced Modelling in Finance Using Excel and VBA](https://d3525k1ryd2155.cloudfront.net/f/220/499/9780471499220.IN.0.m.jpg)
Advanced Modelling in Finance Using Excel and VBA Hardcover - 2001
by Staunton, Mike, Jackson, Mary
- Used
Description
About Better World Books Indiana, United States
Better World Books is the world's leading socially conscious online bookseller and has sold over 100 million books. Each sale generates funds for global literacy and education initiatives. We offer low prices, fast shipping, and have a 100% money back guarantee, if you are not completely satisfied.
Better World Books wants every single one of its customers to be happy with their purchase. If you are not satisfied your purchase or simply find out that it was not the book you were looking for, please e-mail us at: help@betterworldbooks.com. We will get back to you as soon as possible with directions on how to return the book to our warehouse. Please keep in mind that because we deal mostly in used books, any extra components, such as CDs or access codes, are usually not included. CDs: If the book does include a CD, it will be noted in the book's description ("With CD!"). Otherwise, there is no CD included, even if the term is used in the book's title. Access Codes: Unless the book is described as "New," please assume that the book does *not* have an access code.
Details
- Title Advanced Modelling in Finance Using Excel and VBA
- Author Staunton, Mike, Jackson, Mary
- Binding Hardcover
- Edition Har/Cdr
- Condition Used - Very Good
- Pages 288
- Volumes 1
- Language ENG
- Publisher Wiley & Sons Australia, Limited, John, USA
- Date 2001-06-08
- Features Dust Cover, Index, Table of Contents
- Bookseller's Inventory # GRP62927305
- 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
From the publisher
First line
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
Categories
Media reviews
Citations
- Reference and Research Bk News, 11/01/2001, Page 113