Course Details
Country:
France
Institution:
Université Paris I Dauphine
Course Title:
Financial Modeling and Applications
Course Number:
4MFCEZ41
Course Description:
The objective of this course is to show how to use Excel and VBA (Visual Basic for Applications) programming for financial modeling. The course is divided in two parts. Part 1 aims at presenting the main features of the VBA programming language in Excel. The course first covers the Excel object model: What are Excel objects, how do they behave and how are they organized? This is an important issue as understanding the Excel object model is a precondition for writing computer codes that are able to interact with Excel objects. The course then moves to the VBA language features: projects, modules, sub and function procedures, variable types and control structures (conditional statements and loop). Part 2 shows how to use VBA programming in Excel to solve typical finance problems with real datasets. Chapter one is about the properties of stock returns. In application number one, we will see how
Language:
English
Approved Equivalent:
FNAN 341
Attachment Files:
