FIN 3400 Digital tools and financial analysis

FIN 3400 Digital tools and financial analysis

Course code: 
FIN 3400
Department: 
Finance
Credits: 
7.5
Course coordinator: 
Dagfinn Rime
Product category: 
Bachelor
Portfolio: 
Bachelor of Finance - Programme Courses
Semester: 
2020 Autumn
Active status: 
Active
Teaching language: 
Norwegian
Course type: 
One semester
Introduction

The modern world generates data at an incredible rate.  This has profound impact on how businesses are run, investors make their decisions, and how we apply financial theory to navigate the world. This course provides a first introduction to essential quantitative tools to take advantage of data available and to analyze data through the lenses of financial theory.  

To be ready for today’s competitive labor market and being able to quickly and precisely analyze and visualize data, students should master quantitative tools. Everyone uses software in the modern world, but we would be kidding yourself if we think that this only means spreadsheets such as Excel, OpenOffice or Google Sheets. Students give themselves a huge advantage if they learn to write programs -- to code.

In this course, students will therefore learn both to use spreadsheets (such as Excel, OpenOffice or Google Sheets), and elementary programming using R. R is today widely used in business, in general, and in the financial industry, in particular. It is a general programming language that also allows statistical analysis and handling of large datasets. R is open source, which has, at least, three advantages: it is a dynamic and evolving project with a huge amount of contributors around the world, there are extensive, freely available online resources, and it is free.

Students will learn to use spreadsheets and elementary coding through analyzing a set of topical questions in finance using data and visualization techniques.  This course will be "hands-on" and prepare students to provide quantitative answers to question facing the organization they are working for. This course is intended to be both fun and interesting. Students will learn to work together. Several teaching methods will be utilized in the course. 

Students will develop basic skills that will be useful in their studies of finance, and later, in professional life. In most entry-level positions, ability to efficiently gather and process data is a crucial skill. Spreadsheets are widely used and ability to use spreadsheets fast and efficiently are expected by almost all employers. Programming skills are also expected by more and more employers. Combining programming skills with financial insight is important in the financial industry, in business in general, and in public administration. Below you find examples where programming is useful:

  • Analysis of companies’ investment and finance decisions (this also applies to non-profit organizations)
  • Data based analysis for portfolio and investment strategies in financial markets
  • Analysis of big data sets in order to provide insight before making important decisions
  • Automating processes relevant for buying and selling stocks, foreign exchange, and other securities
  • Financial advice

R and spreadsheets (Excel, OpenOffice and Goggle sheets) are used in this course. R is a market leading programming language, and is used by e.g. NBIM (“Oljefondet”, Norges Bank Investment Management) and many financial institutions. 

Learning outcomes - Knowledge

During the course students shall:

  • Learn about the financial system
  • Get to know financial aggregates for the macro economy and major financial variables such as return and turnover.
  • Learn about financial instruments, such as stocks, bonds and exchange rates.
Learning outcomes - Skills

After completed course studens will be able to:

  • Be able to retrieve, process, and do simple data analysis to solve a specific problem.
  • Describe and present data in graphs and tables using R and spreadsheets.
General Competence

Throughout the course, students will develop important basic skills that are in high demand by employers. In this course, emphasis will be placed on learning a set of immediately practical and applicable skills. These skills will also be expected in other bachelor of finance courses.

Course content
  1. Introduce interesting issues that are highlighted in finance
  2. Understand the financial system and how different participants must relate to finance
  3. Introduction to R and spreadsheets (Excel/OpenOffice/Google sheets)
    • Retrieve data for Excel and R. Use data for macroeconomics and financial markets.
    • Process data in Excel and R. "Clean data", merge data, create new variables (eg returns on boxes).
    • Create figures and tables of data. Make simple summaries, such as averages and standard deviations.
  4. Apply Excel and R to problems. For example:
    • Compare wealth in different countries
    • Compare returns on various financial instruments, such as equities and bonds.
Teaching and learning activities

The course consists of lectures and task solving in class. There will be use of R and spreadsheets (Excel / Open Office / Google sheets).

The final grade in the course is a result of continuous evaluation of several examination components, process evaluation, during the semester. Each exam component is assessed on a scale of 0-100. The components are then weighted together according to the information in the course description, which then leads to final letter grade. Students who do not achieve points in one or more of the examination components will receive a lower grade or fail. Detailed information about the points system, and which letter grades they give, will be informed at the start of the course. In the case of continuation, all the examination components, as a general rule, must be re-executed at the next course completion.

The process evaluation includes one assignment that must be solved in groups, which are organized by the lecturer. In addition, there is a final individual exam. Specific evaluation information will be provided in class. It is the student's responsibility to obtain such information. Please note that while attendance is not mandatory, it is the student's responsibility to obtain information given in class.

Software tools
Software defined under the section "Teaching and learning activities".
R
Additional information

The course uses R which is free (open source). Details regarding the installation of various packages and additional tools are given at the beginning of the course. In addition to R, spreadsheets (Excel, Open Office and Google sheets) are used. During the first two weeks of the course, students are expected to acquire skills similar to the online intro course, which is offered for free on the Portal.

Students will have access to web resources (R and Excel / Open Office / Google sheets) that will enable them to be well prepared when the course starts.

The course may be taught in English or Norwegian, depending on the available teaching skills. The exam paper will be given in both languages.

Qualifications

Higher Education Entrance Qualification.

Required prerequisite knowledge

No spesific prerequisites required. 

Exam categoryWeightInvigilationDurationSupport materialsGroupingComment exam
Exam category:
Submission
Form of assessment:
Written submission
Exam code:
FIN 34001
Grading scale:
Point scale
Grading rules:
Internal examiner
Resit:
All components must, as a main rule, be retaken during next scheduled course
30No3 Week(s)Group/Individual (2 - 5)Assignment 1
Exam category:
Submission
Form of assessment:
Written submission
Exam code:
FIN 34001
Grading scale:
Point scale
Grading rules:
Internal and external examiner
Resit:
All components must, as a main rule, be retaken during next scheduled course
70Yes2 Hour(s)
  • No support materials
Individual Final Exam
Exams:
Exam category:Submission
Form of assessment:Written submission
Weight:30
Invigilation:No
Grouping (size):Group/Individual (2-5)
Support materials:
Duration:3 Week(s)
Comment:Assignment 1
Exam code:FIN 34001
Grading scale:Point scale
Resit:All components must, as a main rule, be retaken during next scheduled course
Exam category:Submission
Form of assessment:Written submission
Weight:70
Invigilation:Yes
Grouping (size):Individual
Support materials:
  • No support materials
Duration:2 Hour(s)
Comment:Final Exam
Exam code:FIN 34001
Grading scale:Point scale
Resit:All components must, as a main rule, be retaken during next scheduled course
Type of Assessment: 
Continuous assessment
Total weight: 
100
Student workload
ActivityDurationComment
Teaching on Campus
30 Hour(s)
Seminar groups
12 Hour(s)
Prepare for teaching
83 Hour(s)
Group work / Assignments
30 Hour(s)
Examination
45 Hour(s)
Sum workload: 
200

A course of 1 ECTS credit corresponds to a workload of 26-30 hours. Therefore a course of 7,5 ECTS credit corresponds to a workload of at least 200 hours.