News
Our Degree Programs
Establishment
Language of instruction
English
Teaching content
FINANCE
This course occurs in the following program(s)
MSc in Investment Banking and Capital Markets
- Crédits ECTS: 5.00
Training officer(s)
R.BEAUPAIN
Stakeholder(s)
Renaud BEAUPAIN
Présentation
Prerequisite
- Good knowledge of Microsoft Excel
- Good knowledge of finance
- Good knowledge of the Bloomberg and Thomson Reuters EIKON terminals and how to access information from Excel
- No prior programming knowledge is expected
- Good knowledge of finance
- Good knowledge of the Bloomberg and Thomson Reuters EIKON terminals 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
- Compose constructive personal feedback and guidance
- Employ state of the art management techniques
- Demonstrate an expertise on key concepts, techniques and trends in their professional field
- Be a reference point for expertise-related questions and ambiguities
- 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
- Compose constructive personal feedback and guidance
- Employ state of the art management techniques
- Demonstrate an expertise on key concepts, techniques and trends in their professional field
- Be a reference point for expertise-related questions and ambiguities
Presentation
This course first introduces students to computer programming using the VBA language and introduces standard (variables, conditions, loops, etc.) and more advanced (Userforms, arrays, 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 Bloomberg/Thomson Reuters EIKON.
Modalités
Organization
| Type | Amount of time | Comment | |
|---|---|---|---|
| Présentiel | |||
| Cours interactif | 40,00 | ||
| Travail personnel | |||
| Group Project | 40,00 | ||
| Charge de travail personnel indicative | 45,00 | ||
| Overall student workload | 125,00 | ||
Evaluation
This course first introduces students to computer programming using the VBA language and introduces standard (variables, conditions, loops, etc.) and more advanced (Userforms, arrays, 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 Bloomberg/Thomson Reuters Eikon.
| Control type | Duration | Amount | Weighting |
|---|---|---|---|
| Examen (final) | |||
| Examen écrit | 0,00 | 1 | 60,00 |
| Autres | |||
| Projet Collectif | 0,00 | 1 | 40,00 |
| TOTAL | 100,00 | ||