发帖
雷达卡
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
An Introduction to Excel VBA Programming with Applications in Finance and Insura.pdf
(4.54 MB, 需要: 100 个论坛币)
京公网安备 11010802022788号
