How To Build An Automated Trading Robot In Excel

Learn how to use Visual Basic in Excel to automate your stock trading with Interactive Brokers. Includes trading system Ranger 1.0.

In this course from Peter Titus, 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!

I was searching for a way to automate my trading systems with Interactive Brokers and couldn't find anything of substance. That's until I came across this training from Peter Titus. Peter is an excellent trader and this course details everything you need to get started creating automated trading systems in Excel. He even provides his own working trading system Ranger 1.0 for you to get started with. Thank you Peter!

-- Joe Marwood

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 Ranger 1.0.

We'll use this system as an example to show you how to build your own automation and how to hook it all up with the Interactive Brokers API.

After enrolling you will be able to download a copy of Ranger 1.0 for your own use. By the end of the course you will understand the code that runs Ranger 1.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 Ranger 1.0, but examples on how to trade these are not covered in detail.

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 really 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, and even get you started with a trading system (that you can optimize further) that is already profitable!

Screenshot of the Excel trading robot Ranger 1.0 in action. Learn how to build your own completely from scratch.

What am I going to get from this course?

  • 42 lecutres and 4.5 hours of video content
  • Learn how to trade and generate extra income even while you're 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
  • Start off with a basic trading system that is already profitable
  • Download your own copy of Ranger 1.0
  • Use Ranger 1.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 Ranger 1.0
  • How to import data and do back-testing in Excel
  • How to automatically log trading data and automate setup procedures
  • How to build a decision-making AI in Excel that thinks like a human
  • How to run your system in automatic or manual mode
  • How to keep your orders hidden from the market with order management
  • How to set up trading alerts, timers and sounds
  • Build YOUR OWN automated trading system in Excel from scratch
Who is the target audience?
  • 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
  • Anyone who wants to automate their trading with Interactive Brokers


Your Instructor


Peter Titus
Peter Titus

Peter Titus graduated from the University of Wisconsin- Madison with an engineering degree in 2003. He has been actively trading stocks and options since 2006 and has been building automated trading systems in Excel using Visual Basic for Applications (VBA) since 2009. He specializes in day trading stocks and ETFs.


Course Curriculum


  Introduction to Automated Trading
Available in days
days after you enroll
  Using Visual Basic for Applications (VBA) 4 Lectures
Available in days
days after you enroll
  Ranger 1.0 functionality
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
Is there anything I need to take the course?
To follow along with this course properly, you will need Excel 2010 or later and some experience using the program. An Interactive Brokers account is also helpful but not necessary for all sections.
I'm fairly new to trading, will I find this course easy to follow?
You do not need much trading experience to take this course. However, you do need some knowledge of Excel. If you are unfamiliar with Excel, this course might be hard going.
Can you tell me more about Ranger 1.0?
Sure. Ranger 1.0 is an automated trading robot for Excel developed by Peter Titus. Ranger 1.0 trades intraday breakouts and uses 'Range Width' to calculate targets and stops. The robot is designed for stocks but can also be applied to futures, currencies and options. You will have full access to Ranger 1.0 when you enrol in the course.
I'm not sure if I'm ready for automation yet. Will I find any value in this course?
Absolutely. Even if you are not ready for automation yet there is a lot to learn from this course about Excel and trading systems. Also, when you purchase you receive lifetime access. Many students will take advantage of the offer and then come back to the course when they are ready.
What is Access All Areas? Is this course included?
Great question. The answer is yes. You can access all courses and save up to 50% with Marwood Research: Access All Areas. This is the best value option.

Get started now!



Before making payment, please read the Terms of Use and Risk Warning. Making a payment assumes you have agreed to the policies inside.