Handbook of Financial Risk Management
eBook - ePub

Handbook of Financial Risk Management

Simulations and Case Studies

Ngai Hang Chan, Hoi Ying Wong

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Handbook of Financial Risk Management

Simulations and Case Studies

Ngai Hang Chan, Hoi Ying Wong

Book details
Book preview
Table of contents
Citations

About This Book

An authoritative handbook on risk management techniques and simulations as applied to financial engineering topics, theories, and statistical methodologies

The Handbook of Financial Risk Management: Simulations and Case Studies illustrates the prac­tical implementation of simulation techniques in the banking and financial industries through the use of real-world applications.

Striking a balance between theory and practice, the Handbook of Financial Risk Management: Simulations and Case Studies demonstrates how simulation algorithms can be used to solve practical problems and showcases how accuracy and efficiency in implementing various simulation methods are indispensable tools in risk management. The book provides the reader with an intuitive understanding of financial risk management and deepens insight into those financial products that cannot be priced traditionally. The Handbook of Financial Risk Management also features:

  • Examples in each chapter derived from consulting projects, current research, and course instruction
  • Topics such as volatility, fixed-income derivatives, LIBOR Market Models, and risk measures
  • Over twenty-four recognized simulation models
  • Commentary, data sets, and computer subroutines available on a chapter-by-chapter basis

As a complete reference for practitioners, the book is useful in the fields of finance, business, applied statistics, econometrics, and engineering. The Handbook of Financial Risk Management is also an excellent text or supplement for graduate and MBA-level students in courses on financial risk management and simulation.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
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.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
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.
Do you support text-to-speech?
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.
Is Handbook of Financial Risk Management an online PDF/ePUB?
Yes, you can access Handbook of Financial Risk Management by Ngai Hang Chan, Hoi Ying Wong in PDF and/or ePUB format, as well as other popular books in Commerce & Finance. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Wiley
Year
2013
ISBN
9781118573549
Edition
1
Subtopic
Finance
1
An Introduction to Excel VBA
Excel VBA is probably the most commonly used computational tool in financial institutions, particularly when a new model is tested at a preliminary stage within a division. Many traders use Excel VBA to compute their trading strategies. Some data providers allow users to update information in real time using the Excel format. Excel VBA thus allows traders and risk managers to implement their solutions conveniently in real time.
1.1 HOW TO START EXCEL VBA
1.1.1 Introduction
VBA stands for Visual Basic for Application. It is a programming language that enhances the applicability of MS Excel by enabling the users to instruct Excel to perform tasks automatically. As most of the programs in this book are written in VBA, a brief introduction to VBA is provided in this opening chapter. Although we do not assume that readers have prior programming knowledge, programming experience in other languages would be helpful. For readers already familiar with VBA, this chapter serves as a refresher and quick reference. A list of the functions defined throughout the book can be found at the end of the chapter. These functions not only improve readability and traceability but also simplify the programs. For a more thorough understanding of Excel VBA, readers are referred to other books specializing in the matter. We believe, however, that this chapter is sufficient to allow a beginner to learn and execute the codes within the book.
MS Excel 2003 is used for illustration in this book. If readers are using another version of Excel, then they may find some minor differences. Nevertheless, if this is the first time for a reader to use Excel VBA, then set the macro security level to Medium or Low and restart Excel to enable the macros:
Click [Tools] → [Macro] → [Security] → [Medium] or [Low] (Fig. 1.1).
FIGURE 1.1 Set security level.
c01f001
MS Excel 2007 users should click the Options button to enable the macros.
1.1.2 Visual Basic Editor
VBE, which stands for Visual Basics Editor, is the environment in which macros are created, modified and managed. Macros (VBA procedures) are the code components that automate repetitive Excel tasks. A macro consists of codes that start with the keyword Sub or Function and end with the keywords End Sub or End Function. These codes are known as Sub and Function procedures. A module contains one or more macros, and a project contains one or more modules. A macro developed in VBE becomes part of a workbook and is saved at the same time that the workbook is saved. To open and edit macros in VBE, follow the procedure below.
1. Open VBE: Click [Tools] → [Macro] → [Visual Basic Editor] or press Alt + F11 (Fig. 1.2).
2. Insert module: In the project window on the left of the VBE, right-click one of the worksheets → [Insert] → [Module] (Fig. 1.3).
3. Edit in VBE: Type the codes in the code window.
4. Execute the program: In VBE, click [Run] → [Run Sub] and choose the macro to be compiled. Equivalently, in Excel, click [Tools] → [Macro] → [Macro] and choose the macro to be compiled.
FIGURE 1.2 Open VBE.
c01f002
FIGURE 1.3 Insert modules.
c01f003
1.1.3 The Macro Recorder
Excel offers a macro recorder that records the actions of the mouse and/or keyboard and translates them into VBA codes, thus allowing the designated actions to be repeated by running the macro again. Although the macro recorder is sometimes useful, it is unable to generate codes that perform looping, assign variables, or execute conditional statements, which are...

Table of contents

  1. Cover
  2. Series
  3. Title Page
  4. Copyright
  5. Preface
  6. Chapter 1: An Introduction to Excel VBA
  7. Chapter 2: Background
  8. Chapter 3: Structured Products
  9. Chapter 4: Volatility Modeling
  10. Chapter 5: Fixed-Income Derivatives I: Short-Rate Models
  11. Chapter 6: Fixed-Income Derivatives II: LIBOR Market Models
  12. Chapter 7: Credit Derivatives and Counterparty Credit Risk
  13. Chapter 8: Value-at-Risk and Related Risk Measures
  14. Chapter 9: The Greeks
  15. Appendix
  16. References
  17. Author Index
  18. Subject Index
  19. Wiley Handbooks in Financial Engineering and Econometrics
Citation styles for Handbook of Financial Risk Management

APA 6 Citation

Chan, N. H., & Wong, H. Y. (2013). Handbook of Financial Risk Management (1st ed.). Wiley. Retrieved from https://www.perlego.com/book/1002677/handbook-of-financial-risk-management-simulations-and-case-studies-pdf (Original work published 2013)

Chicago Citation

Chan, Ngai Hang, and Hoi Ying Wong. (2013) 2013. Handbook of Financial Risk Management. 1st ed. Wiley. https://www.perlego.com/book/1002677/handbook-of-financial-risk-management-simulations-and-case-studies-pdf.

Harvard Citation

Chan, N. H. and Wong, H. Y. (2013) Handbook of Financial Risk Management. 1st edn. Wiley. Available at: https://www.perlego.com/book/1002677/handbook-of-financial-risk-management-simulations-and-case-studies-pdf (Accessed: 14 October 2022).

MLA 7 Citation

Chan, Ngai Hang, and Hoi Ying Wong. Handbook of Financial Risk Management. 1st ed. Wiley, 2013. Web. 14 Oct. 2022.