Autoplay
Autocomplete
Previous Lesson
Complete and Continue
How To Build An Automated Trading Robot In Excel
Introduction to Automated Trading
Introduction to Ranger 1.0 Part 1 (7:14)
Introduction to Ranger 1.0 Part 2: Live Demo (4:51)
Legal Stuff - Disclaimer
Resources for those unfamiliar with support/resistance and breakouts
Using Visual Basic for Applications (VBA) 4 Lectures
Visual Basic for Applications (VBA) basics (10:12)
If and or statements (7:10)
Macros, cells, and dialogue boxes (8:29)
Loops (7:39)
Ranger 1.0 functionality
Download Ranger1.0 here! (5:12)
Compile Error: Cannot Find Project or Library
How to build a timer (8:41)
How to schedule a task at a specific time (5:31)
How to build an alarm and play sounds (4:51)
Clearing cells and ranges (6:09)
Auto_Open and Worksheet_Calculate subs (2:23)
Introduction to the Interactive Brokers Excel API (5:23)
How to request live market data automatically (7:05)
How to automate your daily setup tasks (13:35)
How to send orders manually through Excel (3:36)
Checking for set up errors automatically (5:38)
How to design your system to run in automatic or manual mode (7:15)
Managing the order life cycle (3:49)
How to trigger orders and send them automatically (16:00)
Smart position sizing (12:49)
How gains are calculated (smart position sizing continued) (6:46)
How to insert price targets automatically (3:26)
Price targets (17:15)
How to automate stops (10:44)
Conflicting subs: how to prevent them (5:03)
Manual Position Exit (Force Exit Button) (1:49)
How to automatically close positions near the end of the day (2:48)
Overnight positions and special situations (2:16)
How to automatically log trading data (5:40)
How to record live data tick by tick (15:52)
Extras
How to import data from Interactive Brokers or other sources (10:22)
How to do backtesting in Excel (14:50)
Create your algorithm, an introduction to Excel workbook functions (5:14)
How to build a decision making AI that thinks like a human (10:04)
How to debug your code line by line (7:41)
Setting up Interactive Brokers for the first time (4:26)
Where should you go from here (3:24)
Wrap up and thank you (0:56)
Support
Course Discussions
Bonus
Bonus Lecture
Introduction to Ranger 1.0 Part 2: Live Demo
Complete and Continue