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 12 
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 27  No 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.