FORMATIONS |
Fiche détaillée d'un cours
VBA FOR FINANCE | |||
2018-2019 | FrIESEG School of Management
(
IÉSEG
)
| ||
Code Cours : | 1819-IÉSEG-M1S1-FIN-MA-EI46UE | FINANCE |
Niveau | Année de formation | Période | Langue d'enseignement |
---|---|---|---|
Master | 1 | S1 | FrEnglish |
Professeur(s) responsable(s) | R.BEAUPAIN |
---|---|
Intervenant(s) | Reanaud BEAUPAIN, Patrick DAGUET |
- Ce cours apparaît dans les formations suivantes :
- IÉSEG > IESEG Degree - Programme Grande École > Semester 1 > 2,00 ECTS
Pré requis
- Good knowledge of Microsoft Excel
- Good knowledge of finance (financial markets and corporate finance)
- Good knowledge of financial data services 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 concepts in programming (variables, conditions, loops, etc.). The course then covers several financial programming applications in corporate finance and financial 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 d'enseignement
Organisation du cours
Type | Nombre d'heures | Remarques | |
---|---|---|---|
Independent study | |||
Group Project | 16,00 | ||
Estimated personal workload | 18,00 | ||
Face to face | |||
Interactive class | 16,00 | ||
Charge de travail globale de l'étudiant | 50,00 |
Méthodes pédagogiques
- E-learning
- Interactive class
- Project work
Évaluation
The course is assessed based on a programming project in which students bring an original solution to a financial application of their choice using VBA programming.
Type de Contrôle | Durée | Nombre | Pondération |
---|---|---|---|
Others | |||
Group Project | 0,00 | 1 | 100,00 |
TOTAL | 100,00 |
Ressources internet
* Informations non contractuelles et pouvant être soumises à modification