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.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
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 co-author, with Elroy Dimson and Paul Marsh, of Millennium Book II: 101 Years of Investment Returns (2001) and Millennium Book: A Century of Investment Returns (2000).
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 covered 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 and Reimer)
* Quasi Monte Carlo simulation
* volatility smiles
* Black, Derman and Toy trees
* normal interest rate trees
The book is accompanied by a CD-ROM containing the spreadsheets, VBA functions and macros used throughout the work.
This unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. It takes a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. Each area contains both standard material and more advanced topics.
All models are developed fully in both spreadsheets, bringing clarity to teaching in finance, and user-defined functions in VBA, giving a ready-made library of portable functions that can be used in Excel. The spreadsheets and VBA functions are provided on a CD-ROM.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
EUR 4,00 per la spedizione da Germania a Italia
Destinazione, tempi e costiEUR 25,47 per la spedizione da U.S.A. a Italia
Destinazione, tempi e costiDa: medimops, Berlin, Germania
Condizione: good. Befriedigend/Good: Durchschnittlich erhaltenes Buch bzw. Schutzumschlag mit Gebrauchsspuren, aber vollständigen Seiten. / Describes the average WORN book or dust jacket that has all the pages present. Codice articolo M00471499226-G
Quantità: 1 disponibili
Da: medimops, Berlin, Germania
Condizione: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Codice articolo M00471499226-V
Quantità: 2 disponibili
Da: Better World Books Ltd, Dunfermline, Regno Unito
Condizione: Good. Har/Cdr. Ships from the UK. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Codice articolo 6547698-6
Quantità: 2 disponibili
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Hardback. Condizione: Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine. Codice articolo GOR003851120
Quantità: 1 disponibili
Da: Brit Books, Milton Keynes, Regno Unito
Hardcover. Condizione: Used; Very Good. ***Simply Brit*** Welcome to our online used book store, where affordability meets great quality. Dive into a world of captivating reads without breaking the bank. We take pride in offering a wide selection of used books, from classics to hidden gems, ensuring there is something for every literary palate. All orders are shipped within 24 hours and our lightning fast-delivery within 48 hours coupled with our prompt customer service ensures a smooth journey from ordering to delivery. Discover the joy of reading with us, your trusted source for affordable books that do not compromise on quality. Codice articolo 3628184
Quantità: 1 disponibili
Da: AwesomeBooks, Wallingford, Regno Unito
Condizione: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. . Codice articolo 7719-9780471499220
Quantità: 2 disponibili
Da: Bahamut Media, Reading, Regno Unito
Condizione: Very Good. Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee. Codice articolo 6545-9780471499220
Quantità: 2 disponibili
Da: MusicMagpie, Stockport, Regno Unito
Condizione: Very Good. 1747956032. 5/22/2025 11:20:32 PM. Codice articolo U9780471499220
Quantità: 1 disponibili
Da: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Hardcover. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.71. Codice articolo G0471499226I3N00
Quantità: 1 disponibili
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Hardcover. Condizione: Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.71. Codice articolo G0471499226I4N10
Quantità: 1 disponibili