Class Schedule

 DATE TOPICS (may be rearranged to fit the class needs) DECKS   HOMEWORK DUE
Tue, Jan 15 Welcome!  Intro to the class, tools, and resources Deck
No Homework due
 PART I PROCESS AUTOMATION

Thu, Jan 17 The technology: Excel, VBA, Visual Studio, and SQL
Read Walkenbach 2016, Chapter 39. Reading requires a VPN if you are not on grounds.

Deck

H01
Tue, Jan 22 Process automation: Activity diagrams
VB keyword dictionary
- VBA keyword dictionary

Deck
 
H02
Thu, Jan 24 Process Automation: from models to code Deck
H03
Tue, Jan 29 Loops, subs and functions
If you would like a VBA handbook, see the bottom of the readings and software section

Deck

H04
 PART II BUSINESS INTELLIGENCE IN FINANCE

Thu, Jan 31 BI tools: SQL - Intro to SQL with the SmallBankDB
If you would like a SQL handbook, see the bottom of the readings and software section

Deck

H05
Tue, Feb 5 BI tools: SQL, VBA, and Excel I - Canned queries  - T-SQL keyword dictionary Deck
H06
Thu, Feb 7 BI tools: SQL, VBA, and Excel II  - Dynamic queries Deck
H07
Tue, Feb 12 BI tools: SQL, VBA, and Excel III - Nonqueries Deck
H08
Thu, Feb 14 Data quality: manipulating data I Deck
H09
Tue, Feb 19 Data quality: manipulating data II
Deck
H10
Thu, Feb 21 BI Tools: Pivot tables -  Pivot tables fundamentals - Chapter 1-2 Deck
H11
 PART III FINANCIAL ANALYTICS

Tue, Feb 26 Introduction to the Hedge Tournament (Rulebook in sidebar) Deck
H12
Thu, Feb 28 Introduction to the Hedge Tournament (cont.) Deck H13
Tue, Mar 5 Options - Black Scholes fundamentals- The Nasdaq's options trading guide Deck
H14
Thu, Mar 7 Transactions: Stock and Options no deck
H15

SPRING BREAK


Tue, Mar 19 Trading Deck
H16
Thu, Mar 21 Financial strategies for hedging Deck
H17
Tue, Mar 26 Implied volatility (tool is here) and financial charting
Deck
H18
Thu, Mar 28 Algo trading: delta hedging Deck
H19
Tue, Apr 2 Algo trading: delta hedging a portfolio Deck
H20
Thu, Apr 4 Algo trading: simulation Deck
H21
Tue, Apr 9 Algo trading: timers Deck
H22
Thu, Apr 11 Performance improvements Deck
H23
Tue, Apr 16 Performance improvements: error log Deck

Thu, Apr 18 Advanced topics

Tue. Apr 23 THE MCINTIRE HEDGE TOURNAMENT: 5pm to 9pm, 3rd floor labs (no regular class)  
Thu Apr 25 No regular class

Tue Apr 30 *** Prizes, pictures, and lessons learned ***  5pm RRH 116

Contents

The Tournament

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