RM 711 - Applied Financial Analysis

Overview

Course Title

Applied Financial Analysis

Department(s)

Description

This course will introduce students to programming for quantitative analysis with finance applications. The course will start with a review of advanced Excel Functions (Financial Functions, Data Tables, Regression Functions, Conditional Functions, Dates, Lookup Functions, Pivot Tables, Matrices) and then will cover VBA, including recording macros, creating and using functions in VBA, creating and using VBA Sub Procedures, incorporating user interaction, loops, and arrays, objects and add-ins. Students will work with dynamic datasets, construct Bloomberg formulas, extract Bloomberg data into Excel and use Bloomberg's function builder. Students will also cover documentation and good practices for database and model management.

Typically Offered

Fall, Spring

Academic Career

Graduate

Credits

Minimum Units

3

Maximum Units

3

Academic Progress Units

3

Repeat For Credit

No

Components

Name

Lecture

Hours

3

Course Schedule