Win 90% of Trades; Quantitative Investment Models in Excel
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Win 90% of Trades; Quantitative Investment Models in Excel to your Wishlist.

Add to Wishlist

Win 90% of Trades; Quantitative Investment Models in Excel

Use Excel to Model Investing Strategies; Back Test and Optimize Them so You Can Make More Informed Trading Decisions
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Created by Daniel Davis
Last updated 6/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to extract historic stock market data
  • How to calculate technical indicators in Excel
  • How to construct an investment model In Excel, built around technical indicators
  • At the end of the course, you will have built your own quantitative model
  • BONUS: You will Receive the Instructor's Version of the Excel Model
View Curriculum
  • This Course is Designed for Beginners
  • Excel Skills will be Taught Along the Way
  • *You Do Not Need Extensive Math or Excel Skills to Succeed in this Course

Learn how to build investing/trading model in Microsoft Excel.  This course will take you through the process of building a quantitative investment model.  We will build our model on the Relative Strength Index, experimenting with various buy and sell parameters to see how our strategy performs. The model we will build in this course will output your performance, probability of success and average profitability per trade so that you can make the most informed trading decisions possible.

The model will be built around an analysis of technical indicators which you can use to identify trades. 

Quantitative finance is all about making investing more of a science and less of an art.  If you are interesting in learning how to make trades with 80%-90% success rates, this course is for you.  

Who is the target audience?
  • Anyone who Wants to Know how to Test Investment Strategies in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
Welcome to the Course
16 Lectures 01:19:57

Welcome to the course! Follow through this course to build your own quantitative investment model! Thank you for joining!

Preview 00:41

In this video we briefly discuss:

  • Quantitative finance 
  • Introduce the Inflection Point Model, the trading model we will build through this course.  You are welcome to keep and improve it.
  • Discuss what you will be able to do at the end of the course (aside from having an actionable trading model).
    • Be able to extract stock market data from the web
    • Be able to calculate Relative Strength values for any stock
    • Be able to build models around entry and exit points in a stock
    • Determine profitability/ define risks of a trading strategy
    • Use this information to make informed trades
Welcome to the Course!

Before we can build the Inflection Point Model, we must first get familiar with how it works and what information we will need in order to build it.  

Preview 07:56

See attached for Instructor's version of Inflection Point Model for your reference as you build your own version.  

We will be building a trading model called the Inflection Point Model.  This video introduces how the model looks in Excel, it's functionalities, and the optimization function. This is a peak into what your model will look like when it is complete. 

Preview 07:21

To build The Inflection Point Model we first need to extract historic stock data from the internet.  In this video, we will pull several years of GLD data and then perform some calculations on it in order to get the technical indicators needed to build the Inflection Point Model.  

Data Extraction and Calculating Relative Strength Index

We've just completed calculating the RSI. From here, we need to get Excel to take that data and clean it so that it can recognize when an entry or exit parameter is met. In this video, we will introduce how to do this. 

Coding Entry and Exit Triggers

We're about to write the heftiest code in the whole model.  Don't worry! It's not as hard as it looks.  In this video, we will introduce the profit and loss calculators and how they work on a conceptual level.  

Introducing Profit/Loss Calculators

Excel can calculate the profit and loss of any position that would be placed.  This video explains how to automatically determine the price changes from when you enter to when you exit a position.  

Coding Profit/Loss Calculators

Sometimes you will have to put multiple positions on at once (the RSI is below your entry trigger for multiple days).  In this video, we build the function that will identify when a second, third, fourth, etc. position must be placed.  Once Excel recognizes when a subsequent purchase must be placed, it will run a new set of profit/loss calculations. 

Coding Profit/Loss Calculators Part 2

Excel's formula bar only permits 64 levels of nesting.  In this video, we figure out a way to get around that limitation by adding a new column of profit/loss calculations that pick up where the previous column leaves off. 

Profit/Loss Calculators Part 3

This video shows the final steps of the calculations needed to determine the profit/ loss of the strategy you define.  Specifically, this video shows how to calculate the P/L for the subsequent purchases. 

Profit/Loss Calculators Part 4

Errant Trades are trades which are triggered by our entry parameter, however, the trade lasts long enough that Excel fails to recognize the exit parameter.  These are infrequent, however, to ensure the quality of our results, we have to build a function that will identify this situation if it happens.  This video reveals the code and steps necessary to build this function. 

Identifying Errant Trades/Quality Assurance

In this video we build out the calculations needed to build the summary data table (the table that shows how many trades we make, how many were successful, shows our total profit, errant trades and average profitability per trade). 

Compiling Performance Data

In this video we:

  • Calculate probability of success 
  • Find profitability of each trade, given the entry points we define
  • Determine average profitability per trade (Remember! That's profitability per single share traded)
Determining Probability of Success & Total Profit

Create a table that outputs your performance given every combination of entry and exit points.  From there, you can select the entry parameters that fit your personal risk tolerance.  On the second table, you will also see how you would have performed if you had stuck to your strategy for all of the years of GLD's data. 

Building Optimization Function

Some important qualities you need to remember when building your own models:

  • Ensure your formulas extend to cover all of your data. If you insert a new stock with more data than the model is currently designed to handle, you will need to pull the formulas down further. 
  • Stock picking: Ideal candidates for this strategy have volatile RSIs.  ETFs make excellent candidates for this strategy along with Blue Chips.  Not every stock will be a good candidate for this trading style. 
  • You will want to do this analysis on 15 different stocks and find the ones that are the most successful.  Add those to your watch list and monitor them until they pass through their buy triggers. 

Thank you!

Highlights of the Completed Model
About the Instructor
Daniel Davis
5.0 Average rating
2 Reviews
16 Students
1 Course
Professional Financial Analyst

Hello! I am a professional investment analyst who loves data analytics, financial modeling, and quantitative finance.  I have spent the last 10 years studying and investing in the stock market (and earning a B.S. in Finance along the way).  I have spent way too much time modeling investments in Microsoft Excel and use the knowledge that I glean from these models to make investment decisions.  I look forward to sharing what I have learned with you!