Professional Financial Computing Using Excel and VBA
Often financial computing guidebooks provide only quick-and-dirty implementations of financial models, rarely related to real-world applications. Professional Financial Computing Using Excel and VBA provides reusable, flexible, real-world implementations of financial models. The book explores financial models, like derivatives pricings, market and credit risk modeling, and advanced interest rate modeling. With step-by-step instructions, this resource reviews fundamental financial theories and concepts, as well as alternative approaches to ensure a comprehensive understanding of the different techniques. This text is an ideal reference for graduate students studying financial engineering and computing.

1146244792
Professional Financial Computing Using Excel and VBA
Often financial computing guidebooks provide only quick-and-dirty implementations of financial models, rarely related to real-world applications. Professional Financial Computing Using Excel and VBA provides reusable, flexible, real-world implementations of financial models. The book explores financial models, like derivatives pricings, market and credit risk modeling, and advanced interest rate modeling. With step-by-step instructions, this resource reviews fundamental financial theories and concepts, as well as alternative approaches to ensure a comprehensive understanding of the different techniques. This text is an ideal reference for graduate students studying financial engineering and computing.

135.0 In Stock
Professional Financial Computing Using Excel and VBA

Professional Financial Computing Using Excel and VBA

Professional Financial Computing Using Excel and VBA
Add to Wishlist
Professional Financial Computing Using Excel and VBA

Professional Financial Computing Using Excel and VBA

Overview

Often financial computing guidebooks provide only quick-and-dirty implementations of financial models, rarely related to real-world applications. Professional Financial Computing Using Excel and VBA provides reusable, flexible, real-world implementations of financial models. The book explores financial models, like derivatives pricings, market and credit risk modeling, and advanced interest rate modeling. With step-by-step instructions, this resource reviews fundamental financial theories and concepts, as well as alternative approaches to ensure a comprehensive understanding of the different techniques. This text is an ideal reference for graduate students studying financial engineering and computing.

Product Details

ISBN-13: 9780470824399
Publisher: Wiley
Publication date: 06/15/2010
Series: Wiley Finance , #633
Pages: 352
Product dimensions: 6.20(w) x 9.10(h) x 1.10(d)

About the Author

Dr. Humphrey K. K. Tung received his BSc in Physics from the University of Alberta, both MSc and PhD in Theoretical Particle Physics from the University of Toronto. He was a quantitative analyst of C.ATS, a leading risk management software vendor in Silicon Valley. He is now a Visiting Assistant Professor in the Department of Economics and Finance of the City University of Hong Kong and has taught the option pricing and implementation for financial engineering program since 2003.

Mr. Donny Lai is proficient in information systems development, IT project management, and applied finance. He has worked in the IT industry for over 20 years and received his Master Degree of Applied Finance from the University of Western Sydney, Australia. With his profound experience in e-commerce and e-finance, he is teaching in the department of Computer Science, City University of Hong Kong and has taught programming, data analysis, and spreading modeling since 2005. His current research interests include advanced web technologies, mobile computing, and financial computing.

Dr. Michael Wong advised more than 20 banks on market risk management, credit risk management, Basel II credit ratings systems and due diligence for wealth management services. He served as a founding member of FRM Committee of Global Association of Risk Professionals (GARP) in 1998-2002 and trained more than 6,000 chief risk officers, senior risk managers and bank regulators in Hong Kong, Taiwan, China, Korea, Singapore, Malaysia, and Macau. He founded CTRISKS (www.ctrisks.com), an Asia-based credit rating agency and risk consulting firm. Dr. Wong has published more than 50 journal articles and book chapters, and authored four professional books. He is listed in Risk Who's Who, and awarded both Teaching Excellence Award and Best Doctoral Dissertation Award.

Stephen Ng is an executive director of Canadian Imperial Bank of Commerce, who is responsible for coordinating market risk management initiatives in the Asia Pacific region. Previously, he was a quantitative investment manager at ING Investment Management where he developed investment strategies and conducted quantitative research in FX, rates and credit. In addition, he worked at Diversified Credit Investments, Deutsche Bank and Morgan Stanley in the past. He earned his MS in Mathematical Finance from University of Southern California and his BA in Economics from University of California, Berkeley. He is also a CFA charterholder and a Certified Financial Risk Manager.

Table of Contents

Preface ix

Chapter 1 Financial Engineering and Computing 1

1.1 Financial Engineering and Spreadsheet Modeling 1

1.2 Lehman Brothers’ Products for Retail Investors 3

1.3 Risk Management and Basel II 4

1.4 About the Book 4

1.5. Chapter Highlights 6

1.6 Other Remarks 7

Chapter 2 The GARCH(1,1) Model 9

2.1. The Model 9

2.2. Excel Implementation 10

2.3. Excel Plus VBA Implementation 15

Chapter 3 Finite Difference Methods 21

3.1. Difference Equations 21

3.2. Excel Implementation 24

3.3. VBA Implementation 28

3.4. Crank–Nicholson Scheme 33

Chapter 4 Portfolio Mean-Variance Optimization 37

4.1. Portfolio Selection 37

4.2. Excel Implementation 42

4.3. Excel Plus VBA Implementation 48

Chapter 5 Newton–Raphson Method 59

5.1. Newton–Raphson Method for Systems of Equations 59

5.2. VBA Routine 61

Chapter 6 Yield Curve Construction Using Cubic Spline 67

6.1. Cubic Spline Interpolation 67

6.2. Yield Curve Construction 75

6.3. Excel Plus VBA Implementation 77

Chapter 7 Binomial Option Pricing Model 85

7.1. Risk-Neutral Option Pricing and the Binomial Tree 85

7.2. VBA Implementation 89

Chapter 8 The Black–Derman–Toy Model 95

8.1. The Term Structure Model and the Black–Derman–Toy Tree 95

8.2. Excel Plus VBA Implementation 98

Chapter 9 Monte Carlo Option Pricing 109

9.1. The Monte Carlo Method 109

9.2. Risk-Neutral Valuation 112

9.3. VBA Implementation 114

9.4. Exotic Options 124

9.5. American Options 132

Chapter 10 Portfolio Value-at-Risk 143

10.1. Portfolio Risk Simulation 143

10.2. Monte Carlo Simulation for Multiple-Asset Portfolios 152

10.3. Historical Simulation for Multiple-Asset Portfolios 160

10.4. VBA Implementation of Portfolio Risk Simulation 164

10.5. Drill Down of Portfolio Risk 180

Chapter 11 The Hull–White Model 189

11.1. Hull–White Trinomial Tree 189

11.2. Excel Plus VBA Implementation 196

11.3. The General Hull–White Model 203

11.4. Implementation of the General Hull–White Model 210

Chapter 12 CreditMetrics Model 221

12.1. The CreditMetrics Model 221

12.2. Individual (Segregate) Asset Valuation Framework 221

12.3 Monte Carlo Simulation in Detail 225

12.4. Excel and VBA Implementation 227

Chapter 13 KMV–Merton Model 243

13.1. KMV–Merton Model of Credit Risk 243

13.2. Excel and VBA Implementation 248

Appendix A VBA Programming 255

A.1 Introduction 255

A.2 A Brief History of VBA 255

A.3 Essential Excel Elements for VBA 256

A.3.1 Excel Cell Reference 257

A.3.2 Excel Defined Names 261

A.3.3 Excel Worksheet Functions 264

A.4 The VBA Development Environment (VBE) 266

A.4.1 The Developer Tab in the Ribbon 266

A.4.2 The Windows of VBE 268

A.4.3 The Project Explorer 272

A.4.4 The VBA Project Structure 273

A.4.5 The Procedure to Create a VBA Subroutine 275

A.4.6 The Procedure to Create a VBA Function 278

A.5 Basic VBA Programming Concepts 280

A.5.1 Variables and Data Types 285

A.5.2 Declaration and Assignment Statements 287

A.5.3 Flow Control Statements 293

A.6 VBA Arrays 300

A.7 Using Worksheet Matrix Functions in VBA 304

A.8 Summary 311

Appendix B The Excel Object Model 315

Appendix C VBA Debugging Tools 321

Appendix D Summary of VBA Operators 327

Appendix E Summary of VBA Functions 331

Appendix F Summary of VBA Statements 333

Appendix G Excel Array Formula 341

Index 349

From the B&N Reads Blog
Page 1 of

Related Subjects

Business
Professional Finance & Investing
Finance - General & Miscellaneous
Business
Professional Finance & Investing
Finance - General & Miscellaneous

Customer Reviews