Class Schedule
DATE  TOPICS (may be rearranged to fit the class needs)  DECKS  HOMEWORK 
Thu, Jan 18  WELCOME! Intro to the class, tools, and resources. 
Deck  No Homework due 
PART I  PROCESS AUTOMATION  
Tue, Jan 23  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 25  MODELING FINANCIAL PROCESSES  Deck 
Homework 2 due 
Tue, Jan 30  ALGORITHMIC THINKING: Control Structures  VB keyword dictionary  VBA keyword dictionary  Deck 
Homework 3 due 
Thu, Feb 1  ALGORITHMIC THINKING: Procedures  Deck  Homework 4 due 
PART II  BUSINESS INTELLIGENCE IN FINANCE  
Tue, Feb 6  BI TOOLS: SQL  Intro to SQL with the SmallBankDB  Deck 
Homework 5 due 
Thu, Feb 8  DATA QUALITY: MANIPULATING DATA  SQL keyword dictionary  Deck 
Homework 6 due 
Tue, Feb 13  MANIPULATING DATA II  Deck 
Homework 7 due 
Thu, Feb 15  BI TOOLS: SQL, VBA and EXCEL  Deck 
Homework 8 due 
Tue, Feb 20  SQL, VBA and EXCEL II  Deck 
Homework 9 due 
Thu, Feb 22  SQL, VBA and EXCEL III  Deck 
Homework 10 due 
Tue, Feb 27  BI TOOLS: PIVOT TABLES Pivot tables fundamentals  Chapter
12 
Deck 
Homework 11 due 
PART III  FINANCIAL ANALYTICS  
Thu, Mar 1  INTRODUCTION TO THE HEDGE TOURNAMENT (Rulebook in sidebar)  
Homework 12 due 
Spring Break  
Tue, Mar 13  INTRODUCTION TO THE HEDGE TOURNAMENT (cont.)  Homework 13 due 

Thu, Mar 15  OPTIONS  The Nasdaq's options trading guide  Deck 
Homework 14 due 
Tue, Mar 20  BLACK SCHOLES COMPUTATIONAL FUNDAMENTALS (no deck)  Homework 15 due 

Thu, Mar 22  FINANCIAL STRATEGIES: PAYOFF CURVES  Deck 
Homework 16 due 
Tue, Mar 27  FINANCIAL STRATEGIES: HEDGING  Deck 
Homework 17 due 
Thu, Mar 29  IMPLIED VOLATILITY  Deck 
Homework 18 due 
Tue, Apr 3  HEDGING A PORTFOLIO  Deck 
Homework 19 due 
Thu, Apr 5  ALGO TRADING: THE SMART HEDGER  Deck 
Homework 20 due 
Tue, Apr 10  ADVANCED TOPICS: TIMERS  AUTO ALGOTRADING  Deck 
Homework 21 due 
Thu, Apr 12  ADVANCED TOPICS: GAMMA HEDGING  Deck 
Homework 22 due 
Tue, Apr 17  ADVANCED TOPICS: Blockchain  Deck 

Thu, Apr 20  ADVANCED TOPICS: VBA and the Excel editor  
Tue, Apr 24  No morning class  
Tue Apr 24  THE MCINTIRE HEDGE TOURNAMENT: from 5pm to 9pm  
Thu, Apr 26  No class  
Tue, May 1  *** PRIZES, PICTURES, AND LESSONS LEARNED *** 
Contents
The Tournament
Some of the following links will be enabled later in the course.