Items related to Advanced modelling in finance using Excel and VBA
Synopsis
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.
"synopsis" may belong to another edition of this title.
From the Back 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
From the Inside Flap
Advanced modelling in finance using Excel and VBA
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.
"About this title" may belong to another edition of this title.
- PublisherWiley
- Publication date2001
- ISBN 10 0471499226
- ISBN 13 9780471499220
- BindingHardcover
- LanguageEnglish
- Edition number1
- Number of pages288
- Rating
Search results for Advanced modelling in finance using Excel and VBA
Stock Image
Advanced modelling in finance using Excel and VBA
Seller: SecondSale, Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00076151601
Quantity: 1 available
Stock Image
Advanced modelling in finance using Excel and VBA
Seller: SecondSale, Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00078592398
Quantity: 2 available
Stock Image
Advanced modelling in finance using Excel and VBA
Published by
Wiley (edition First Edition), 2001
ISBN 10: 0471499226
ISBN 13: 9780471499220
Used
Hardcover
First Edition
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Hardcover. Condition: Good. First Edition. Supplements included Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 0471499226-11-18-116
Quantity: 1 available
Stock Image
Advanced modelling in finance using Excel and VBA
Seller: Goodwill of the Olympics and Rainier Region, Tacoma, WA, U.S.A.
Seller rating 5 out of 5 stars
Condition: Acceptable. An acceptable and readable copy. All pages are intact, and the spine and cover are also intact. This item may have light highlighting, writing or underlining through out the book, curled corners, missing dust jacket and or stickers. Seller Inventory # 467IJT006Y4A
Quantity: 1 available
Stock Image
Advanced Modelling in Finance Using Excel and VBA
Published by
Wiley & Sons, Incorporated, John, 2001
ISBN 10: 0471499226
ISBN 13: 9780471499220
Used
Hardcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Har/Cdr. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # 6547698-6
Quantity: 1 available
Stock Image
Advanced Modelling in Finance Using Excel and VBA
Published by
Wiley & Sons, Incorporated, John, 2001
ISBN 10: 0471499226
ISBN 13: 9780471499220
Used
Hardcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Har/Cdr. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # GRP62927305
Quantity: 1 available
Stock Image
Advanced Modelling in Finance Using Excel and VBA
Published by
Wiley & Sons, Incorporated, John, 2001
ISBN 10: 0471499226
ISBN 13: 9780471499220
Used
Hardcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Har/Cdr. Used book that is in clean, average condition without any missing pages. Seller Inventory # 5850938-6
Quantity: 1 available
Seller Image
Advanced modelling in finance using Excel and VBA
Seller: Bay State Book Company, North Smithfield, RI, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. The book is in good condition with all pages and cover intact, including the dust jacket if originally issued. The spine may show light wear. Pages may contain some notes or highlighting, and there might be a "From the library of" label. Boxed set packaging, shrink wrap, or included media like CDs may be missing. Seller Inventory # BSM.IN6J
Quantity: 1 available
Stock Image
Advanced modelling in finance using Excel and VBA
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
hardcover. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_363186112
Quantity: 1 available
Stock Image
Advanced modelling in finance using Excel and VBA
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: 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. Seller Inventory # T09E-01540
Quantity: 1 available