Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 4.5 hours on-demand video
  • 7 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Finance & Accounting Investing & Trading Stock Trading

Create Your Own Automated Stock Trading Robot In EXCEL!

Learn how to use Visual Basic in Excel to automate your trading!
Rating: 3.8 out of 53.8 (284 ratings)
2,168 students
Created by Peter Titus
Last updated 10/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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

Requirements

  • 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.

Description

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!

Who this course is for:

  • 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

Course content

5 sections • 46 lectures • 4h 45m total length

  • Preview07:14
  • Preview04:51
  • Legal Stuff - Disclaimer
    00:47
  • My Best Ideas
    00:20
  • Resources for those unfamiliar with support/resistance and breakouts
    00:31

  • Visual Basic for Applications (VBA) basics
    10:12
  • If and or statements
    07:10
  • Macros, cells, and dialogue boxes
    08:29
  • Loops
    07:39

  • Download Ranger1.0 here!
    05:12
  • If you get the following error: Compile Error: Cannot Find Project or Library
    00:17
  • How to build a timer
    08:41
  • How to schedule a task at a specific time
    05:31
  • How to build an alarm and play sounds
    04:51
  • Clearing cells and ranges
    06:09
  • Auto_Open and Worksheet_Calculate subs
    02:23
  • Introduction to the Interactive Brokers Excel API
    05:23
  • How to request live market data automatically
    07:05
  • How to automate your daily setup tasks
    13:35
  • How to send orders manually through Excel
    03:36
  • Checking for set up errors automatically
    05:38
  • How to design your system to run in automatic or manual mode
    07:15
  • Managing the order life cycle
    03:49
  • How to trigger orders and send them automatically
    16:00
  • Smart position sizing
    12:49
  • How gains are calculated (smart position sizing continued)
    06:46
  • How to insert price targets automatically
    03:26
  • Price targets
    17:15
  • How to automate stops
    10:44
  • Conflicting subs: how to prevent them
    05:03
  • Manual Position Exit (Force Exit Button)
    01:49
  • How to automatically close positions near the end of the day
    02:48
  • Overnight positions and special situations
    02:16
  • How to automatically log trading data
    05:40
  • How to record live data tick by tick
    15:52

  • 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
    05:14
  • How to build a decision making AI that thinks like a human
    10:04
  • How to debug your code line by line
    07:41
  • Setting up Interactive Brokers for the first time
    04:26
  • Where should you go from here?
    03:24
  • Need My Help Building Custom Automation?
    00:06
  • Wrap up and thank you
    00:56

  • 75% OFF coupon for: The Big Volatility Short
    00:42
  • A Perfect Strategy For Options Income
    00:36

Instructor

Peter Titus
Trader, Technologist, and Entrepreneur
Peter Titus
  • 3.6 Instructor Rating
  • 575 Reviews
  • 10,894 Students
  • 3 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.