Create Your Own Automated Stock Trading Robot In EXCEL!
- 4.5 hours on-demand video
- 7 articles
- 5 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Be able to trade and generate extra income even while you're at work or away from the computer
- Understand the basics of the Interactive Brokers Excel API
- Learn how to build automation through sub procedures in Visual Basic
- Be able to automate any spreadsheet task with VBA
- Learn how to import data and do backtesting in Excel
- Download your own copy of Ranger 1.0
- Use Ranger1.0 to automate your own trading right away
- Understand the code in Ranger 1.0 and be able to customize it to fit your own ideas
- Add your own functions and algorithms to Ranger1.0
- Build YOUR OWN automated trading system in Excel from scratch
- You should already be familiar with Excel
- Trading experience is useful, but not required
- Computer, internet connection, Excel 2010 or newer, Microsoft Windows
- You will need $10,000 to open a margin account and $5,000 to open an IRA account with Interactive brokers.
In this course you will learn how to build trading automation in Excel, the most popular spreadsheet software on the market. In Excel, there are no limits to what you can build! You are limited only by your imagination! The course is built around learning Visual Basic for applications (VBA) and we'll be examining a simplified version of the system I built for trading called Ranger1.0. We'll use this system as an example to show you how to build your own automation. Every student will be able to download a copy of Ranger1.0 for their own use. By the end of the course you will understand the code that runs Ranger1.0 and be able to customize it to fit your ideas. You will also be able to use what you've learned to build your own automated system from the ground up, if that's what you choose to do.
The focus of this course is on trading stocks. It is possible to trade futures, currencies, options, and bonds through Ranger1.0, but examples on how to trade these are not covered in detail. However, by the end of this course you will have enough knowledge in Visual Basic to be able to create your own custom automation to trade whatever you want however you want!
The sky is the limit! With excel you really can build just about anything you can imagine. This course will get you started using Visual Basic, even if you've never written any code before. You will learn how to automate the order life cycle, how to build timers, play sounds, record live data, do backtesting, and even how to build a decision making AI!
Finally, I will guide you through everything you need to know to set up an account with Interactive Brokers, how to set up the Excel API, and how to trade using a simulated "Paper" trading account. An Interactive Brokers account is required to receive live streaming data and to send orders, but even if you do not have an account, I will show you how to get historical data for excel that you can do backtesting on right away!
- Anyone interested in learning the basics of automated trading in Excel
- Anyone looking for ways to add automation to their trading routine
- Anyone who wants to build an automated trading system in Excel
Here we talk about what we want in an automated trading system and go over what Ranger1.0 is and what it does.
This is a live demo showing how the automated setup is activated and how the system handles the market open. Then I send a trade through my simulated trading account followed by an exit order. We also talk briefly about the live data recorder and the Log Data function.
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.
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.
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!