Cantitate/Preț
Produs
Total produse
Vezi coșul
An Introduction to Excel VBA Programming: with Applications in Finance and Insurance de Guojun Gan

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

Autor Guojun Gan
en Limba Engleză Hardback – 7 apr 2017
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
Citește tot Restrânge

Toate formatele și edițiile

Toate formatele și edițiile Preț Express
Paperback (1) 42828 lei  6-8 săpt.
  CRC Press – 22 mar 2019 42828 lei  6-8 săpt.
Hardback (1) 69290 lei  6-8 săpt.
  CRC Press – 7 apr 2017 69290 lei  6-8 săpt.

Preț: 69290 lei

Preț vechi: 84500 lei
-18% Nou

Puncte Express: 1039
Preț estimativ în valută:
13260€ • 13815$ • 11025£

Carte tipărită la comandă

Livrare economică 10-24 februarie 25

 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă
Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781138197152
ISBN-10: 1138197157
Pagini: 300
Dimensiuni: 156 x 234 x 20 mm
Greutate: 0.57 kg
Ediția:1
Editura: CRC Press
Colecția Chapman and Hall/CRC

Cuprins

I VBA Preliminaries
Introduction to VBA
Getting Started
Modules
VBA Classes
The ExcelMacro Recorder

Excel Objects
The Excel ObjectModel
The Application Object
TheWorkbook Objects
TheWorksheet Objects
TheWorksheetFunction Object
Variables, Data Types, and Scopes
Variable Declaration and Data Types
Arrays
Constants
Strings
Dates
Scopes
Operators and Control Structures
Operators
Flow Control
Loops
Functions, Events and File IO
User-Defined Functions
Events
File IO
Error Handling and Debugging 109
Error Handling
Debugging VBA Code
Best Practices of VBA Coding
II Applications

Generating Payment Schedules
Introduction
Public Holidays in the United States
The Julian and Gregorian Calendars
Day Count Conventions
Business Day Conventions
Implementation
TheMDateModule
TheMHolidayModule
TheMScheduleModule
TheMInterfaceModule
Bootstrapping Yield Curves
Introduction
Interpolation
Bootstrapping Yield Curves
Finding Roots of an Equation
Implementation
TheMCurveModule
TheMInterfaceModule
Generating Risk-Neutral Scenarios
Introduction
The Black-ScholesModel
Generating Random Normal Numbers
Implementation
TheMGeneratorModule
TheMInterfaceModule
Valuing a GMDB
Introduction
Life Table Construction
GMDB Valuation
Greek Calculation
Implementation
TheMLifeTableModule
TheMGMDBModule
TheMInterfaceModule
Connecting to Databases
ActiveX Data Objects
SQL
Implementation
TheMDatabaseModule
TheMInterfaceModule
Object-Oriented Programming 233
Introduction
Objects
Implementation
The CZeroCurveModule
The CSwapModule
The CBootstrapperModule
An OO Bootstrapping Tool

Solutions to Selected Exercises

Notă biografică

Guojun Gan is an Assistant Professor in the Department of Mathematics at the University of Connecticut, where he has been since August 2014. Prior to that, he worked at Manulife Financial, a large life insurance company in Toronto, Canada, for six years. His research focuses on data mining and actuarial science. He has published four books and several papers related to data mining, actuarial science, and mathematical finance.

Descriere

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.