VBAExcel


 * Excel VBA **

Ch1: 2 3 4 Ch2: 1 2 create a program to compute growth of investment of 10000 at 2% per year over 30 year period Ch3: 2 3 Ch4: 3 4 5 Ch5: 1 2 3 4 5 Ch6: 1 Ch7: 1 2 Ch8: 1 2 3 Ch9: 1 2ae 5 (just write the line, no programming) Ch10: 1 2 3 4 6 Ch11: 1 2 4 5 6 Ch12: 1 2 4 6 7 Additional examples of VBA loops: @http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=122:excel-vba-loops-with-examples-for-loop-do-while-loop-do-until-loop&catid=79&Itemid=475 Ch13: 2 5 6 9 Ch14: 1 Ch15: Actuarial mortgage computation. Also good practice: 1 2 3
 * HW from S. Chapra book Introduction to VBA for Excel: **

Ch2: 1 2 Ch3: 3 Ch4: 3 4 5 Ch5: 2 3 4 5 Ch6: 1 Ch7: 1 Ch8: 2 3 Ch9: 1 2ae Ch10: 3 4
 * Exam 1 problems: **

Ch 11: 1 4 6 Ch 12: 1 2 4 6 7 Ch 13: 2 5 6 Ch 14: 1
 * Exam 2 problems: **

**__Introduction to VBA in Excel (MCO517) Final Project__** You are required to write a user friendly program to value options numerically using a binomial model. The following should be used for reference: Chapter 7: Pages 163 – 168 Background reading on types of options. Chapter 8: Pages 188 – 193 Background on factors affecting option prices. Chapter 13: Valuing options numerically using a binomial model (pages: 308 – 313 is the essential material). You should use meaningful names for all variables and document your code liberally. The project should be as user friendly as possible. It should have a user interface to allow input of variables and a calculate button. The binomial tree(s) and the final valuation should be generated by the program and laid out neatly. Check that your model agrees with the numbers in the example on page 311 (one or two numbers on the tree are slightly off). Set up two buttons (or other controls) – one of these should populate the input variables with the data for problem 13.1 and the other should do the same with the data for problem 13.2 (so that your professor can test your results for each of these problems without manually entering the data).


 * Introduction to VBA for Excel **

SYLLABUS **__Department:__** Mathematics. **__Course Title:__** VBA Programming in Excel for Actuaries (MCO517) (3 Credits) **__Developer:__** Kaganovskiy **__Prerequisite:__** Good working knowledge of Excel, Basic Windows. **__Course Objectives:__** The student will understand the VBA development environment. **__Course contents__** Course will use the Excel 2010 environment. **__Course requirements:__** Programming assignments as prescribed throughout the course. **__Attendance:__** The importance of a good attendance record is imperative for this course. The nature of this material is such that it cannot be mastered without attending classes on a regular basis. Lack of attendance may result in a failing grade. **__Grading System:__** The course grade will be based on class participation, midterm, final exam, and final project. **__Methodology:__** Classroom lectures and assigned homework. Introduction to VBA for Excel - S. Chapra, Prentice Hall, ISBN: 978-0-13-239667-7 First few pages you can use till your book arrives:
 * __ Course description __**__ : __ This course will give the student a basic knowledge of VBA programming in Excel with a view to developing financial models.
 * Macro Recording
 * VBA Editor Environment
 * Object Oriented Programming (OOP) and the Excel Object Model
 * Object Properties and Methods
 * Procedures, Subroutines and Functions
 * Variables, Data Types, Arrays, Ranges
 * Built in Functions
 * Program flow control, Loops
 * Event-handler procedures
 * Error handling
 * Using the debugger
 * Dialog boxes and user forms
 * Charts
 * Financial programming examples
 * Speeding up the application
 * Files
 * __ Course Text: __**

Bibliography:

Excel 2010 Power Programming with VBA – John Walkenbach - Wiley ISBN 978-0-470-47535-5 Excel VBA Programming for Dummies - – John Walkenbach - Wiley ISBN 978-0-470-50369-0.