该文件包含以下内容：CPPI策略、DynamicChart、Events、GBM、GF实体现金流折现财务模型、Goldman Sachs Business Services Valuation、JPMorgan Valuation、Lehmann Brothers Analysis Model、Magicpic、Merrill Lynch Valuation、Normdist、二叉树模型、俄...
0.053433 Total = 102 -0.01322 0.025089 H = 0.023317 0.094291 --- Put data (e.g. log returns) in column A 0.010017 0.036587 0.059132 -0.02109 -0.00797 -0.06205 0.050602...
Table of Contents Preface Part I: Some Essential Background Preface Part I: Some Essential Background Part I: Some Essential Background Chapter 1: Excel 2003: Where It Came From Chapter 2: Excel in a Nutshell Chapter 3: Formula Tricks and...
About the Authors v Acknowledgments ix Introduction xxiii Chapter 1: Primer in Excel VBA 1 Using the Macro Recorder 2 Recording Macros 2 Running Macros 5 The Visual Basic Editor 8 Other Ways to Run Macros 11 User Defined Functions 18 Creat...
Preface Like its predecessor Numerical Techniques in Finance, this book presents some important financial models and shows how they can be solved numerically and/or simulated using Excel. In this sense this is a finance cookbook; like any...
一、函数应用基础......................................................................................................................................................... 1 （一）函数和公式......................................................
目 录 序..................................................................................................................................................... I 目 录.............................................................................
Excel函数应用之财务函数 Excel函数应用之查询与引用函数 Excel函数应用之工程函数 Excel函数应用之函数简介 Excel函数应用之逻辑函数 Excel函数应用之数据库函数 Excel函数应用之数学和三角函数 Excel函数应用之统计函数 Excel函数应用之文本 Excel函数应用...
Contents Preface xv Acknowledgements xvii 1 Introduction 1 1.1 Typographical and code conventions used in this book 1 1.2 What tools and resources are required to write add-ins 2 1.2.1 VBA macros and add-ins 3 1.2.2 C/C++ DLL add-ins 3 1.2...
Contents at a Glance Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . xv Part I Basic Information Chapter 1 Excel in a Nutshell . . . . . . . ....
