Contents
FTA: Class Schedule
| Date | Topic | Deck | How to prepare & Homework due |
|---|---|---|---|
| Tue 1/13 | Welcome to Information Technology and Finance: what you will learn, skills for your career |
Deck01 | Browse this web site. Bring to class any questions you might have. |
| Part I : Acquiring Business Process Automation Skills | |||
| Thu 1/15 | Foundational technology concepts. Recording processes with the macro recorder |
Deck02 |
H01 is due at the beginning of class Join the FinTech Community |
| Tue 1/20 | Modeling process: Activity diagrams |
Deck03 |
H02 |
| Thu 1/22 | How programs work: Loops |
Deck04 |
H03 - Orange words |
| Tue 1/27 | How programs work: Function calls CLASS MOVED ONLINE - SAME TIME |
Deck05 |
H04 - Orange words |
| Part II : Acquiring Business Intelligence (BI) Skills for Finance | |||
| Thu 1/29 | BI tools: SQL and DBMS |
Deck06 |
H05 - Orange words (every time from now on) |
| Tue 2/3 | Retrieving business data (SQL + VBA + Excel): Canned queries | Deck07 |
H06 |
| Thu 2/5 | Retrieving business data: Dynamic queries | Deck08 |
H07 Starting today, homework are due on Tue or Thu at midnight. |
| Tue 2/10 | Managing business data: Non-queries | Deck09 |
H08 |
| Thu 2/12 | Data Quality: data cleaning I | Deck10 |
H09 |
| Tue 2/17 | Data Quality: data cleaning II | Deck11 |
H10 |
| Thu 2/19 | BI Tools: Pivot tables | Deck12 |
H11 |
| Part III: Acquiring Financial Analytics Skills | |||
| Tue 2/24 | Introduction to the Hedge Tournament |
Deck13 |
H12 |
| Thu 2/26 | Stock and Options transactions fundamentals | Deck14 |
H13 |
| Spring Recess | |||
| Tue 3/10 | Financial Metrics |
Deck15 |
H14 |
| Thu 3/12 | Transactions: Stocks |
Deck16 |
H15 Heads up: 24 min video |
| Tue 3/17 | Transactions: Option valuation: the Black-Scholes model | Deck17 |
H16 |
| Thu 3/19 | Profit Curves and Delta Hedging | Deck18 |
H17 |
| Tue 3/24 | Financial charts and debugging |
Deck19 |
H18 |
| Thu 3/26 | Implicit volatility |
Deck20 |
H19 |
| Tue 3/31 | Algo trading: delta hedging of a portfolio family |
Deck21 |
H20 |
| Thu 4/2 | The full recommender |
Deck22 |
H21 |
| Tue 4/7 | Simulation |
H22 | |
| Thu 4/9 | Syncing |
H23 | |
| Tue 4/14 | Tweaking your robotrader |
H24-The last! | |
| Thu 4/16 | Tweaking your robotrader | ||
| Tue 4/21 | No regular class: All-day software clinic | ||
| Thu 4/23 | No regular class: software clinic | ||
| The McIntire Hedge Tournament: 4/23 6pm-9pm | |||
| Tue 4/28 | Results, ranking, pictures, and the history of the Tournament - regular class hours | ||