Class Schedule

 DATE TOPICS (may be rearranged to fit the class needs) DECKS   HOMEWORK
Thu, Jan 19 WELCOME!
Intro to the class, tools, and resources.
Deck No Homework due
 PART I PROCESS AUTOMATION

Tue, Jan 24 THE TECHNOLOGY: Excel, VBA, Visual Studio, and SQL
Read Walkenbach 2016, Chapter 39
Reading requires a VPN if you are not on grounds
Deck Homework 1 due
Thu, Jan 26 MODELING FINANCIAL PROCESSES Deck Homework 2 due
Tue, Jan 31 ALGORITHMIC THINKING: Control Structures Deck Homework 3 due
Thu, Feb 2 ALGORITHMIC THINKING: Procedures Deck Homework 4 due
 PART II BUSINESS INTELLIGENCE IN FINANCE

Tue, Feb 7 BI TOOLS: SQL - Intro to SQL with the SmallBankDB Deck Homework 5 due
Thu, Feb 9 DATA QUALITY: MANIPULATING DATA Deck Homework 6 due
Tue, Feb 14 MANIPULATING DATA II Deck Homework 7 due
Thu, Feb 16 BI TOOLS: SQL AND VBA Deck Homework 8 due
Tue, Feb 21 SQL AND VBA II - VB keyword dictionary - VBA keywords dictionary Deck Homework 9 due
Thu, Feb 23 SQL AND VBA III - Using VS to Connect to the SQL server from home (advanced users) Deck Homework 10 due
Tue, Feb 28 BI TOOLS: PIVOT TABLES Pivot tables fundamentals - Chpt 1-2
Deck Homework 11 due
 PART III FINANCIAL ANALYTICS

Thu, Mar 2 INTRODUCTION TO THE HEDGE TOURNAMENT (Rulebook in sidebar)
Homework 12 due

Spring Break

Tue, Mar 14 INTRODUCTION TO THE HEDGE TOURNAMENT (cont.)   Homework 13 due
Thu, Mar 16 OPTIONS - The Nasdaq's options trading guide Deck Homework 14 due
Tue, Mar 21 BLACK SCHOLES COMPUTATIONAL FUNDAMENTALS Deck Homework 15 due
Thu, Mar 23 FINANCIAL STRATEGIES: PAYOFF CURVES Deck Homework 16 due
Tue, Mar 28 FINANCIAL STRATEGIES: HEDGING Deck Homework 17 due
Thu, Mar 30 IMPLIED VOLATILITY Deck Homework 18 due
Tue, Apr 4 HEDGING A PORTFOLIO Deck Homework 19 due
Thu, Apr 6 ALGO TRADING: THE SMART HEDGER Deck Homework 20 due
Tue, Apr 11 ADVANCED TOPICS: TIMERS Deck Homework 21 due
Thu, Apr 13 NO CLASS
Homework 22 due
Tue, Apr 18 ADVANCED TOPICS: GAMMA HEDGING Deck

Thu, Apr 20 ADVANCED TOPICS

Tue, Apr 25 ADVANCED TOPICS

Wed Apr 26 THE MCINTIRE HEDGE TOURNAMENT: Wed. Apr 26th from 5pm to 9pm  
Thu, Apr 27No Regular class

Tue, May 2nd *** PRIZES, PICTURES, AND LESSONS LEARNED ***

Contents

The Tournament

Some of the following links will be enabled later in the course.