Applied Financial Analysis

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.