Professional Financial Computing Using Excel & VBA (Hardcover)
暫譯: 專業金融計算：使用 Excel 與 VBA (精裝版)

Donny C. F. Lai, Humphrey K. K. Tung, Michael C. S. Wong

Professional Financial Computing Using Excel & VBA (Hardcover)
  • 出版商: Wiley
  • 出版日期: 2010-02-01
  • 售價: $4,455
  • 貴賓價: 9.5 折 $4,232
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Hardcover
  • ISBN: 0470824395
  • ISBN-13: 9780470824399
  • 相關分類: Excel

    • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

《專業金融計算：使用 Excel 和 VBA》是一部值得讚賞的著作，橋接了金融工程的理論基礎與其應用，這些應用通常表現為“黑箱”軟體應用。這本書打開了黑箱，揭示了基於行業標準隨機模型的風險建模和金融工程架構，利用 Excel 和 VBA 的功能創建了一個強大且實用的建模工具包。購買這本書的金融工程專業人士將在其定制的金融工程和建模需求上獲得先發優勢。

Dr. Cameron Wicentowich

加拿大帝國商業銀行 (CIBC) 財務分析副總裁

金融的電子表格建模已成為許多量化金融課程中的標準課程，因為基於 Excel 的 Visual Basic 編程現在廣泛用於構建最佳投資組合、定價結構性產品和管理風險。《專業金融計算：使用 Excel 和 VBA》是由一個獨特的金融、物理和計算機學術及實務團隊撰寫的。這本書對於那些正在攻讀金融工程和風險管理碩士學位的人來說，是一個很好的參考資料。它對於金融工程師啟動設計結構性產品、建模利率期限結構或信用風險的項目也非常有用。

Dr. Jin Zhang

香港大學金融碩士課程主任及副教授

在過去幾年中，Excel 已成為金融規劃和計算最強大的工具之一。大多數用戶僅利用其部分功能。原因之一是涵蓋 Excel 高級功能的金融書籍有限。《專業金融計算：使用 Excel 和 VBA》更進一步，處理了許多專業人士所需的 Excel 工具。這本書對於從事金融工程、金融風險管理、計算金融或數學金融的專業人士或學生來說，是必備之作。我喜歡作者使用現實生活中的實際範例來涵蓋這些材料的方式。

Dr. Isaac Gottlieb

天普大學

著作，《下一代 Excel：分析師和 MBA 的 Excel 建模》

類似商品