Fiche détaillée d'un cours


 


Voir la fiche établissement

COMPUTER PROGRAMMING : Visual Basic for Applications

2017-2018

IESEG School of Management ( IÉSEG )

Code Cours :

1718-IÉSEG-MBK1S1-FIN-FINMBKCE18UE

FINANCE


Niveau Année de formation Période Langue d'enseignement 
MSc in Investment Banking and Capital Markets1S1English
Professeur(s) responsable(s)R.BEAUPAIN
Intervenant(s)Renaud BEAUPAIN


Pré requis

- 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

Objectifs du cours

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

Contenu du cours

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 d'enseignement

Organisation du cours

TypeNombre d'heuresRemarques
Face to face
Interactive class40,00  
Independent study
Group Project42,50  
Estimated personal workload42,50  
Charge de travail globale de l'étudiant125,00  

Méthodes pédagogiques

  • Presentation
  • E-learning
  • Project work
  • Interactive class


Évaluation

The course is assessed based on a written exam and a programming project in which students bring an original solution to a financial question using VBA programming.

Type de ContrôleDuréeNombrePondération
Final Exam
Written exam0,00160,00
Others
Group Project0,00140,00
TOTAL     100,00




 
* Informations non contractuelles et pouvant être soumises à modification
 
 
Vidéo : Un campus à vivre
Notre chaîne Youtube