Professional Financial Computing Using Excel & VBA

( 2 )


"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 ...

See more details below
$98.75 price
(Save 21%)$125.00 List Price
Other sellers (Hardcover)
  • All (13) from $22.98   
  • New (10) from $57.95   
  • Used (3) from $22.97   
Professional Financial Computing Using Excel and VBA

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$71.49 price
(Save 42%)$125.00 List Price


"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

Read More Show Less

Product Details

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

Meet 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 (, 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.

Read More Show Less

Table of Contents

Introduction: BCD as Defined by Me: Breast Cancer Drama 17

The Good, The Bad and The Ugly 21

1 The Ultrasound-Guided Core Needle Biopsies 27

2 An Inconvenient Year: 1-20-08 33

3 First Opinion 35

4 Second Opinion 39

5 Third Opinion 43

6 Free Day, 47

7 Fourth Opinion 48

8 Estrogen-Progesterone Test 50

9 Fifth Opinion 51

10 The Facts I Am Considering as Key after All Five Opinions 54

11 The Decision 56

12 "Prenderla Giorno per Giorno" (Taking It One Day at a Time) MRI's and the Ultrasound Tests 58

13 Notes of Clarification 61

14 MRI & Ultrasound Test Results, Second Round BCD Results 63

15 It's the "Me" in Medical that's the Problem 68

16 Something Else We Need to Change: How They Track Research 70

17 Test No. 3: Core Needle Biopsy of Axillary Lymph Nodes 73

18 Hear Me as a Woman and Not as a Cancer Patient 76

19 Results of Test No. 3: Core Needle Biopsy of Axillary Lymph Node 78

20 The Night before the Next Two Days 82

21 And Then There Was One, Which Is Truly the Loneliest Number That Can Ever Be 83

22 It All Comes at Me at Once 89

23 Short Takes 94

24 My Body Sends Me Two Important Signs, Two Days after Surgery 97

25 A New Twist to Living out the String 99

26 The Disengagement of Dickie the Drain But First, My Tribute to D2 (D-Squared) 104

27 Pictures: Ladies, These are for You 107

28 Dickie the Drain is History 111

29 A Boutique Like Most Have Never Seen Before 114

30 Taking Control of How I Lose the Rest of Me But First, How I Met the Auditor 117

31 Shaving My Hair Off 120

32 A Family Connection: Through All the Clutter and Noise, I Hear Her 122

33 Kind of/ Sort of Meeting the Chemo Oncologist 130

34 The Second Opinion from a Radiation Oncologist & My Get Out Of Jail Free Card 138

35 I Have Never Shopped For a Rug Like This Before (Part 1) 141

36 I Have Never Shopped For a Rug Like This Before (Part 2) 143

37 Alright, Enough Already! 146

38 The Mugascan 150

39 What Exactly Is a Skin-Sparing Mastectomy? 152

40 Chemo, the New Cocktail for Me & My Introduction to Red Death 158

41 Getting the Shot from Larry 163

42 The First Few Days after Chemo 165

43 Doing What I Always Do: Reaching Through the Sky and Dreaming Big Really Big 168

44 The Big Shave (Part 1) 171

45 The Big Shave Party (Part 2) What a Difference a Day Makes-24 Little Hours 173

46 The Second Chemo Treatment: Going Chemotose 177

47 Learning and Teaching Lessons while Allowing the Boat to Take Its Course 184

48 Hair Today But Gone Tomorrow or Tony, the Trucker and Tits 188

49 Larry & the Three Bald Zaccones at Chemo No. 3 191

50 In the Beginning 194

51 The Week before Chemo No. 4 197

52 Camp Chemo: the First Five-Star Camp of Its Kind 200

53 The Genetic Counselor and Chemo No. 5 204

54 Embrace the Suck 211

55 A Medical Imbalance: The Current Teams Plan for Radiation 215

56 Chemo No. 6 With Withering Contempt, Half-Concealed Irritation and Feigned Amusement I Move on to Weary Disdain I am a Human Chia Pet 222

57 Chemo No. 7, Shot No. 7 and the Land Of Oz 228

58 When Everything Is Coming Your Way, You're in the Wrong Lane 232

59 The Last Chemo, a Little Respite and Then Diving into the Next Step 238

60 How to Keep It Moving 244

61 Do Boneless, Skinless Chicken Cutlets Float? 246

62 Slash, Poison and Burn & Focusing on the Long-Term 249

63 Hoping That This Will Extend My Expiration Date 254

64 A New Twist to Cleavage and the Tests before Radiation 257

65 From Strategic Planning to Strategic Plotting, All in One Day 309

66 The New Chick Gang, a Caveat and a String 315

67 A Cord to the Right of Me, a Mammogram to the Left Here I Am Stuck in the Middle with One Boob 320

68 When the Dark Days Come, Let Them Come 328

69 The Case of the Disappearing Tattoos 334

70 Lately, I've Walked More Than a Few Miles in My Italian Leather Slingbacks 343

71 Nutrition, Drugs and Their Amazing Interactions 350

72 I've Decided That Much of What You Want in Life, Lies Right Outside Your Comfort Zone 362

73 Tissue and Needles and More Oh, My! 365

74 Dreaming with Your Eyes Wide Open & the Transition from Patient to Advocate 382

75 All I Need to Do Is to Show Up 388

76 Measure Twice, Cut Once: Reconstruction Surgery 394

77 The Waiting Begins Again 406

78 OK, So How Fast Is the Speed of Dark? 408

79 "Stress Is When You Wake Up Screaming and Then You Realize You Haven't Slept Yet" 411

80 Love Means Never Having to Say You're Sorry 421

81 Wondering What Happens When You Get Scared Half to Death Twice 424

82 Life De-drained and Re-claimed 432

83 Nurses and Their Critically Important Role 436

84 One Nipple Away from a Full Set & My Last Tattoo 440

85 Origami's Fabulous Folds & Lefty Gets a Lift 445

86 When Support Moves Beyond a Bra 451

87 Accepting the Challenge and My Future 457

88 And This: My Final Chapter 460

Prescriptions & Over-the Counter Drugs that Were Taken 462

What Questions Should I Ask My Doctors? 464

The Language Of Breast Cancer 481

Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted June 27, 2014

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 8, 2014

    ∻ ☨ ╭ ╯ Ɛ Ƒ Ɯ

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)