Menu

VBA FOR FINANCE

Code Cours
2324-IÉSEG-M1S1-FIN-MA-EI46UE
  1. Home
  2. ECTS Courses
  3. VBA FOR FINANCE
Establishment
IESEG School of Management
Language of instruction
English
Teaching content
FINANCE
Training officer(s)
R.BEAUPAIN
Stakeholder(s)
Reanaud BEAUPAIN, Patrick DAGUET
Level
Master
Program year
1
Period
S1

Présentation

Prerequisite
- Good knowledge of Microsoft Excel
- Good knowledge of finance
- Good knowledge of financial data services and how to access information from Excel
- No prior programming knowledge is expected
Goal
At the end of the course the student should be able to :

- Read, understand and explain the VBA programming language
- Program basic applications using Excel VBA
- Draw a diagram of a program structure
- Communicate effectively in English
- Propose creative solutions within an organization
- Employ state of the art management techniques
- Demonstrate an expertise on key concepts, techniques and trends in their professional field
Presentation
This course first introduces students to computer programming using the VBA language and introduces standard (variables, conditions, loops, etc.) concepts in programming. The course covers several financial programming applications (procedures and/or functions) in corporate finance and capital markets. All lectures take place in the Financial Markets Lab where students can interactively apply the course material and develop financial applications interacting with a financial data service.

Modalités

Organization
Type Amount of time Comment
Présentiel
Cours interactif 16,00
Travail personnel
Charge de travail personnel indicative 18,00
Group Project 16,00
Overall student workload 50,00
Evaluation
The course is assessed based on a programming project in which students bring an original solution to a financial question using VBA programming.

Ressources