Create Your Own Automated Stock Trading Robot In EXCEL!

I show you how to open VBA and how to navigate the interface. Then I show you how to easily use and define variables and how to write sub procedures.

We go over how to write "if" statements, then how to add "and" and "or" to these statements to perform some simple example functions.

I show you how to record a macro and use code from it in your sub. We talk about how to write code to simply reference a cell by a row and a column number. I also show you how easy it is to generate a "yes - no" dialogue box.

Here we build a sample loop using the GoTo function and a counter.

Download Ranger1.0 excel file here

I show you how to build a timer and where timers are used in Ranger1.0 as well as how to make a simple clock that ticks every second.

Here we talk about how easy it is to schedule a task (or run any sub at any set time) using the application.ontime function.

We go over how the alarm works, and how to play sounds through VBA. (sounds must be .wav files)

I show you how the "clear worksheet" sub works and how to clear ranges of cells and change cell colors.

When building an automated trading system, you can use the Auto_Open sub to run anything as soon as the workbook opens, and use the Worksheet_Calculate sub to run anything every time the worksheet calculates (such as every time a price changes)

Here we go over the various features of the Excel API.

I show you how to request live market data in excel, using the Excel API and how to automate this task.

I go through how to set up the worksheets to get ready for trading manually, then I show you how to automate this entire process.

Here we go over how to send orders manually through the Excel by entering the symbol and the trade data into the "Conditional Orders" worksheet.

Here we talk about why we need to add "island" as the primary exchange for certain nasdaq stocks and how to automatically detect a setup error.

I show you how the system can be designed to generate a trade that requires your final approval before being sent, and also how to send all trades automatically. We also go over how to tell if the order was "Submitted" or "Filled" and at what price and for how many shares.

Here we go over how each stage of the order cycle is managed and how we keep track of which stage each trade is in.

Here we take a look at how the system checks for trades and stopouts, the code it uses to trigger orders, and how it can be set to send them automatically.

I show you the calculation I use (and how to customize it) to calculate the number of shares to buy so that you risk the same amount on every trade whether you are trading something with a wide (volatile) range, or something with a narrow range.

Here we go over how gains are calculated after we exit each trade, and how the smart position sizing calculation is used in calculating our "real" percentage gain or loss.

We go over the PTpaste sub and how it auto-inserts our price targets after a buy and stop price are entered.

Here we go over the code that handles our exit order (take profits order)

Here we talk about our stop and timeout code

This lecture is on how to easily prevent subs (especially those that run multiple times per second) from conflicting with the Interactive Brokers subs that request market data or send orders.

I show you how the "Force Exit" button puts the text "Timeout" into the nearest trade cell so you can quickly exit a trade manually if you want.

Here we go over how to close your open positions at a set time near the end of the day. Especially useful if you're day trading.

Sometimes you may encounter a situation where you need to start the system from an "open position" state. This could be due to Interactive Brokers cancelling your order or if you entered a position manually from TWS or some other special situation. Here I show you how to make sure the system is set up properly to go forward from an "open position" state.

I show you how the system logs data when you're done trading and pastes your gains or losses on the "Log" worksheet.

Here we go over how the system records live market data and how you can customize it.

In this lecture I show you how to import historical data (intraday and yearly) using interactive brokers. Then I show you other sources of market data on the web you may find useful.

This lecture is about how to do backtesting in Excel. If you are doing a lot of backtesting, especially if you are using "standard" technical indicators, Excel is probably not the best software platform out there, but the advantage of Excel is you can backtest anything you can build an algorithm for. I built a sample backtester to show you how to do it and help you get started. The sample rules we tried here are already profitable on yahoo and apple. You can further optimize this system with your own ideas!

There are an enormous number of Excel workbook functions and you can use ANY of them in your own automated trading system. If you want the standard technical indicators too, there are add-ins you can get to bring those into excel as well!

I show you how to build a decision making AI that makes decisions the way a human does. We go over three different types of data inputs, and how transform them into numbers an AI can use to make a decision- as well as how to "weight" each factor based on how important it is.

Here we go over how to step through your code line by line using the F8 command. I show you how to force a sub to run by setting up a sample situation and how to disable certain lines from running by putting a ' mark in front of them. Don't forget to re-enable these lines of code if you want then to run again in a live situation!

Here I show you some of the most useful tricks I've learned when configuring Interactive Brokers and the best way to get technical support. I've also attached a huge list of resources for additional learning about the Trader Work Station and the Excel API. Be sure to click on the "View Resources" button!

A warm thank you from me for taking this course as well as a discussion on how to continue your journey!

Congratulations to all who have completed this course! You now have the power and knowledge to build your own automated trading system in Excel!