AlgoTrading101 – Learn VBA Fundamentals (Excel)

Course Curriculum

Chapter 1 Using Excel Magic to Improve Our Trading

Excel VBA – Why are we learning this?
Playing a Trading Game with Excel VBA
Download Code for Excel VBA Chapter
Simple Demonstrations with Excel VBA
Setting up your Excel for VBA
Warning! Trust Settings and Setting up Developer Tabs
Chapter 2 Referring to Sheets, Cells and Variables

Referencing Cells and Sheets (Part 1)
Referencing Cells and Sheets (Part 2)
Summary Notes – Referencing Cells and Sheets
VBA Basic Error Handling – Managing Erroneous Code
Exercise on Referencing
VBA Syntax – Structure of VBA Code
VBA Variables – Basic Building Blocks that Store/Do Stuff
VBA Reserved Words – Words You Cannot Use
VBA Intro to Data Types – Different Types of Variables
VBA List of Data Types
VBA Operators, Intermediate Window and Buttons
Chapter 3 If A happens, do B – Conditional Statements

VBA Conditionals – If This then That
Comparison and Logical Operators
Exercise on Conditionals
Worksheet Functions (aka Excel Functions in VBA)
List of VBA Worksheet Functions
VBA Functions – Using In-Built VBA Functions
List of VBA Functions
Chapter 4 Do Something Many Times – Loops

For Loops – Do Something Many Times
Do While Loops – Do Something Many Times (in another way)
Multi-step Loops – Jumps of more than 1
Exercise on Loops (Part 1)
Nested Loops (Loops within loops) and Indentations
Exercise on Loops (Part 2)
Other Types of Loops
Breaking out of Loops
Infinite Loops – Loops that go on forever
Chapter 5 Mini Project – Help the Finance Guy

VBA Self-Learning – Be a problem solver
VBA Mini Project – Help the Finance Guy