| Description |
1 online resource (x, 263 pages) : illustrations. |
| Series |
Wiley finance series |
|
Wiley finance series.
|
| Bibliography |
Includes bibliographical references and index. |
| Contents |
1. Introduction -- pt. 1. Advanced Modelling in Excel -- 2. Advanced Excel functions and procedures -- 3. Introduction to VBA -- 4. Writing VBA user-defined functions -- pt. 2. Equities -- 5. Introduction to equities -- 6. Portfolio optimisation -- 7. Asset pricing -- 8. Performance measurement and attribution -- pt. 3. Options on Equities -- 9. Introduction to options on equities -- 10. Binomial trees -- 11. The Black-Scholes formula -- 12. Other numerical methods for European options -- 13. Non-normal distributions and implied volatility -- pt. 4. Options on Bonds -- 14. Introduction to valuing options on bonds -- 15. Interest rate models -- 16. Matching the term structure -- App. Other VBA functions. |
| Access |
Use copy Restrictions unspecified star MiAaHDL |
| Reproduction |
Electronic reproduction. [Place of publication not identified] : HathiTrust Digital Library, 2010. MiAaHDL |
| System Details |
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002. http://purl.oclc.org/DLF/benchrepro0212 MiAaHDL |
| Processing Action |
digitized 2010 HathiTrust Digital Library committed to preserve pda MiAaHDL |
| Summary |
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 fo. |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Visual Basic for applications.
|
|
Microsoft Excel (Computer file) |
|
Microsoft Visual Basic for applications. |
|
Microsoft Excel (Computer file) |
|
Microsoft Visual Basic for applications |
|
Finance -- Mathematical models.
|
|
Finances -- Modèles mathématiques. |
|
Finance -- Mathematical models |
|
Financieel management. |
|
Optiehandel. |
|
Microsoft Excel. |
|
Numerieke methoden. |
|
Visual Basic. |
|
Finanças (modelos matemáticos) |
|
Excel. |
|
Visual basic. |
| Added Author |
Staunton, Mike.
|
| Other Form: |
Print version: Jackson, Mary, 1936- Advanced modelling in finance using Excel and VBA. New York : Wiley, ©2001 0471499226 (DLC) 00069327 (OCoLC)45620773 |
| ISBN |
0470061669 (electronic bk.) |
|
9780470061664 (electronic bk.) |
|
9780471499220 |
|
0471499226 |
|
More Resources