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

An Introduction to Excel VBA Programming: with Applications in Finance and Insurance Front Cover
0 Reviews
2017-05-08
300 pages

Book Description

Visual Basic for Applications (VBA) can be used to automate operations in and is one of the most frequently used 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 and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and analysts who wish to learn VBA. 

Features

  • Presents the theory behind the 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

Table of 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 Programming
Chapter A Solutions To Selected Exercises

Book Details

  • Title: An Introduction to Excel VBA Programming: with Applications in Finance and Insurance
  • Author:
  • Length: 300 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2017-05-08
  • ISBN-10: B072BMKLGZ
File HostFree Download LinkFormatSize (MB)Upload Date
ZippyShare Click to downloadAZW31.805/11/2017
How to Download? Report Dead Links & Get a Copy

Leave a Reply