Professional Financial Computing Using Excel and VBA

3.6 avg rating
( 5 ratings by Goodreads )
 
9780470824399: Professional Financial Computing Using Excel and VBA
View all copies of this ISBN edition:
 
 

"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs."
Dr. Cameron Wicentowich
Vice President, Treasury Analytics
Canadian Imperial Bank of Commerce (CIBC)

"Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks."
Dr. Jin Zhang
Director of Master of Finance Program and Associate Professor
The University of Hong Kong

"Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples."
Dr. Isaac Gottlieb
Temple University
Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs

"synopsis" may belong to another edition of this title.

From the Inside Flap:

Too often, books on financial computing provide only quick-and-dirty implementations of financial models that have very little use in real-world applications. Professional Financial Computing Using Excel and VBA aims to provide real-world implementations of financial models that are robust, reusable, and flexible. The book covers a wide range of financial models in the areas of derivatives pricings, market and credit risk modeling, as well as advanced interest rate modeling.

Each of the chapters on model implementations starts with a review on all the necessary financial theory and concepts from a practitioner’s perspective. Step-by-step instructions on the implementation are then provided to explain the programming techniques involved for models with different complexities. Alternative approaches are also discussed to offer readers a comprehensive understanding of different techniques. The appendices provide an in-depth look at how to implement financial models using both Excel 2007 and VBA, and to discuss the essential programming practices and skills in structuring complex financial models through advanced VBA features.

This book is designed for self-study, reference, and classroom use for graduate programs in financial engineering and computing. All Excel and VBA codes illustrated in the book are included in the enclosed CD.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Lai
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Softcover First Edition Quantity Available: > 20
International Edition
Seller:
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Condition: New. 1st edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS/DHL with tracking number. Choose expedited shipping for superfast delivery 3-5 business days by UPS/DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery and shipping charges will be extra. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. In case of orders from Europe, custom charges may comply by the relevant government authority and we are not liable for it. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Seller Inventory # LPBDUS1512005

More information about this seller | Contact this seller

Buy New
US$ 28.46
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

Humphrey,K.K.
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Softcover Quantity Available: 3
International Edition
Seller:
Unique Bookseller
(Delhi, India)
Rating
[?]

Book Description Softcover. Condition: Brand New. .. Black & White or color International Edition. ISBN and front cover may be different, but contents are same as the US edition. Book printed in English. Territorial restrictions may be printed on the book. GET IT FAST within 3-5 business days by DHL/FedEx/Aramex and tracking number will be uploaded into your order page within 24-48 hours. Kindly provide day time phone number in order to ensure smooth delivery. No shipping to PO BOX, APO, FPO addresses. 100% Customer satisfaction guaranteed!. . Seller Inventory # UBS03320

More information about this seller | Contact this seller

Buy New
US$ 32.46
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

HUMPHREY,K.K.
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Quantity Available: 1
International Edition
Seller:
Bookshub
(Karol Bagh, India)
Rating
[?]

Book Description Condition: New. New. International edition. Different ISBN and Cover image but contents are same as US edition. Perfect condition. Customer satisfaction our priority. Seller Inventory # ABE-FEB-133021

More information about this seller | Contact this seller

Buy New
US$ 34.39
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

4.

HUMPHREY,K.K.
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Quantity Available: 1
International Edition
Seller:
EBOOKSTORE2010
(New Delhi, ND, India)
Rating
[?]

Book Description Condition: Brand New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Customer Satisfaction guaranteed!!. Seller Inventory # SHUB133021

More information about this seller | Contact this seller

Buy New
US$ 34.44
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

5.

HUMPHREY,K.K.
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Softcover Quantity Available: 1
International Edition
Seller:
Basi6 International
(Irving, TX, U.S.A.)
Rating
[?]

Book Description Condition: Brand New. New, SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Excellent Customer Service. Seller Inventory # ABEUSA-133021

More information about this seller | Contact this seller

Buy New
US$ 36.79
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Lai, Donny C. F.; Tung, Humphrey K. K.; Wong, Michael C. S.
Published by Wiley
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Hardcover Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Wiley. Hardcover. Condition: New. 0470824395 New Condition. Seller Inventory # NEW7.0180985

More information about this seller | Contact this seller

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

7.

Lai, Donny C. F., Tung, Humphrey K. K.,
Published by Wiley (2010)
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Hardcover Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Wiley, 2010. Hardcover. Condition: New. Never used!. Seller Inventory # P110470824395

More information about this seller | Contact this seller

Buy New
US$ 75.45
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

8.

Donny C. F. Lai; Humphrey K. K. Tung; Michael C. S. Wong; With: Stephen Ng
Published by John Wiley and Sons
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description John Wiley and Sons. Condition: New. Brand New. Seller Inventory # 0470824395

More information about this seller | Contact this seller

Buy New
US$ 76.99
Convert Currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, Rates & Speeds

9.

Donny C. F. Lai, Humphrey K. K. Tung, Michael C. S. Wong, Stephen Ng (Contributor)
Published by Wiley (2010)
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Hardcover Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Wiley, 2010. Hardcover. Condition: New. 1. Seller Inventory # DADAX0470824395

More information about this seller | Contact this seller

Buy New
US$ 75.98
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

10.

Donny C. F. Lai, Humphrey K. K. Tung, Michael C. S. Wong
Published by John Wiley and Sons Ltd, United Kingdom (2010)
ISBN 10: 0470824395 ISBN 13: 9780470824399
New Hardcover First Edition Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description John Wiley and Sons Ltd, United Kingdom, 2010. Hardback. Condition: New. 1. Auflage. Language: English . Brand New Book. 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. Seller Inventory # AAH9780470824399

More information about this seller | Contact this seller

Buy New
US$ 97.43
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book