Class Schedule
DATE | TOPICS (may be rearranged to fit the class needs) | DECKS | HOMEWORK
DUE |
Jan. 18 | Welcome! Intro to the class, tools, and resources |
Deck |
No Homework due |
PART I | PROCESS AUTOMATION | |
|
Jan. 23 | Technology concepts Recording processes with the macro recorder. Read #1 |
Deck | H01 |
Jan. 25 | Modeling process: Activity diagrams. Read #2 |
Deck |
H02 |
Jan. 30 | Subs, and Functions | Deck |
postponed (see Teams) |
Feb. 1 | Process Automation: Loops Optional demo to examine after class, Read #3 How to solve the 'trusted location' problem |
Deck | H03 |
PART II | BUSINESS INTELLIGENCE IN FINANCE | |
|
Feb. 6 | BI tools: SQL and DBMS Read #4 (& optional How to rename a folder) |
Deck |
H04 |
Feb. 8 | BI tools: getting SQL, VBA, and Excel to work I - Canned queries |
Deck |
H06 (we skipped H05) |
Feb. 13 | BI tools: getting SQL, VBA, and Excel to work II - Dynamic queries | Deck |
H07 |
Feb. 15 |
BI tools: getting SQL, VBA, and Excel to work III - Non-queries | Deck |
H08 |
Feb. 20 |
Data Quality: manipulating data I | Deck |
H09 |
Feb. 22 | Data Quality: manipulating data II | Deck |
H10 |
Feb. 27 | BI Tools: Pivot tables - Read #5 | Deck |
H11 |
PART III | FINANCIAL ANALYTICS | |
|
Feb. 29 | Introduction to the Hedge Tournament | Deck |
H12 |
S P R I N G R E C E S S | |||
Mar. 12 | Stock and Options transactions fundamentals | Deck |
H13 |
Mar. 14 | Financial metrics | Deck |
H14 |
Mar. 19 | Transactions: Stock | Deck |
H15 |
Mar. 21 | Trading options Folder recovery, Trust recovery, Key recovery |
Deck |
H16 |
Mar. 26 | Evaluating options: the Black-Scholes model. Read #6 | Deck |
H17 |
Mar. 28 | Delta hedging | Deck |
H18 |
Apr. 2 | Implicit volatility | Deck |
H19 |
Apr. 4 | Algo trading: delta hedging of a portfolio family |
Deck |
H20 |
Apr. 9 | The recommender | Deck |
H21 |
Apr. 11 | Simulation | Deck |
H22 |
Apr. 16 | Syncing | Deck |
H23 |
Apr. 18 | Tweaking your robotrader | Deck |
H24 (not due) |
Apr. 23 | No morning class - all day office hours | Deck |
|
Apr. 25 | No morning class - office hours until 4pm THE MCINTIRE HEDGE TOURNAMENT: 5pm to 9pm |
||
Apr. 30 | Prizes, pictures, and the history of the Tournament - regular class hours |
Contents
The HT
Some of the links will be activated later in the course.