An Introduction to Excel VBA Programming: with Applications in Finance and Insurance

An Introduction to Excel VBA Programming: with Applications in Finance and Insurance
by Guojun Gan
Pages: 300 pages
Publisher Finelybook 出版社: Chapman and Hall/CRC; 1 edition (2 May 2017)
Language 语言: English
ISBN-10 书号: 1138197157
ISBN-13 书号: 9781138197152
B072BMKLGZ
Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data,this text is suitable for advanced undergraduate students,graduate students,actuaries,and financial analysts who wish to learn VBA.
Features
Presents the theory behind the algorithms in detail
Includes more than 100 exercises with selected solutions
Provides VBA code in Excel files and data to reproduce the results in the book
Offers a solutions manual for qualified instructors
Contents
Part I VBA Preliminaries
Chapter 1 Introduction To VBA
Chapter 2 Excel Objects
Chapter 3 Variables,Data Types,And Scopes
Chapter 4 Operators And Control Structures
Chapter 5 Functions,Events,And File Io
Chapter 6 Error Handling And Debugging
Part II Applications
Chapter 7 Generating Payment Schedules
Chapter 8 Bootstrapping Yield Curves
Chapter 9 Generating Risk-Neutral Scenarios
Chapter 10 Valuing A Gmdb
Chapter 11 Connecting To Databases
Chapter 12 Object-Oriented Programming
Chapter A Solutions To Selected Exercises
Excel Visual Basic for Applications（VBA）可用于自动化Excel中的操作，并且是在银行和保险公司中操纵数据和构建模型的最常用的软件程序之一。 Excel VBA编程简介: 在财务和保险领域的应用介绍了读者对VBA编程的基础知识，同时展示了VBA应用程序来解决金融和保险领域的现实问题。假设没有以前的编程经验和使用代码和数据的可重复的示例，本文适用于希望学习VBA的高级本科生，研究生，精算师和金融分析师。
特征
详细介绍算法背后的理论
包括超过100个练习与选定的解决方案
在Excel文件和数据中提供VBA代码，以便在本书中重现结果
为合格的教员提供解决方案手册
目录
第一部分VBA预备
第1章VBA简介
第2章Excel对象
第3章变量，数据类型和范围
第四章运营商与控制结构
第5章功能，事件和文件
第6章错误处理和调试
第二部分应用
第七章生成付款时间表
第8章自举屈服曲线
第9章产生风险中性场景
第10章评估Gmdb
第11章连接到数据库
第12章面向对象编程
第A章选择练习的解决方案