
- English
- PDF
- Available on iOS & Android
eBook - PDF
Advanced Modelling in Finance using Excel and VBA
About this book
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.
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Advanced Modelling in Finance using Excel and VBA by Mary Jackson,Mike Staunton in PDF and/or ePUB format, as well as other popular books in Negocios y empresa & Finanzas. We have over one million books available in our catalogue for you to explore.
Information
Table of contents
- Cover
- Title Page
- Copyright
- Contents
- Preface
- Acknowledgements
- 1 Introduction
- Part One Advanced Modelling in Excel
- 2 Advanced Excel functions and procedures
- 3 Introduction to VBA
- 4 Writing VBA user-defined functions
- Part Two Equities
- 5 Introduction to equities
- 6 Portfolio optimisation
- 7 Asset pricing
- 8 Performance measurement and attribution
- Part Three 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
- Part Four Options on Bonds
- 14 Introduction to valuing options on bonds
- 15 Interest rate models
- 16 Matching the term structure
- Appendix Other VBA functions
- Index
- EULA