An Introduction to VBA Programming
with Applications in Finance and Insurance
1st Edition
Will be published approx. on 22. May 2017
Book
Paperback/Softback
978-1-138-19720-6 (ISBN)
Unfortunately, price unknown
Not yet published
Not available
Description
Visual Basic for Applications (VBA) is a programming language created by Microsoft that can be used to automate operations in Microsoft Excel. This textbook has been written for undergraduate students majoring in actuarial science and related areas who wish to learn the basic fundamentals and applications of Excel VBA. It can also be used as supplementary reading for courses related to computer programming, financial modelling, and information technology for business.
More details
Person
Content
Preface. VBA Preliminaries. Introduction to VBA Programming. Excel Objects. Variables, Data Types and Scopes. Operators and Control Structures. Functions, Events and File IO. Error Handling and Debugging. Applications. Generating Payment Schedules. Bootstrapping Yield Curves. Generating Risk-Neutral Scenarios. Pricing a GMDB. Connecting to Databases. Object-Oriented Programming. References. Index. Index of VBA Keywords.