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 -Implied volatility calculator   Homework 18 due
Tue, Apr 4 ADVANCED TOPICS: TIMERS

Thu, Apr 6 ALGO TRADING: HEDGING A PORTFOLIO

Tue, Apr 11 ADVANCED TOPICS: GAMMA HEDGING  - DeltaGamma Hedging (optional)

Thu, Apr 13 ADVANCED TOPICS: LESSONS LEARNED - Check out the HT Bulletin
--
Tue, Apr 18 THE EXCEL IDE AND VBA
--
Thu, Apr 20 FIM TOPICS: BITCOIN
--
Tue, Apr 25 FIM TOPICS: HTF
--
Thu, Apr 26 THE MCINTIRE HEDGE TOURNAMENT: Wed. Apr 26th from 5pm to 9pm - no regular class on the 27th   --
Tue, May 2nd PRIZES, PICTURES, AND LESSONS LEARNED

Contents

The Tournament

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