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 DATA QUALITY: 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 ALGO TRADING: 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 Deck Homework 22 due
Tue, Apr 18 GAMMA HEDGING

Thu, Apr 20 FIM TOPICS

Tue, Apr 25 FIM TOPICS

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

Tue May 2 *** PRIZES, PICTURES, AND LESSONS LEARNED  - @ 5pm in the regular classroom ***

Contents

The Tournament

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