Quantitative Investing; An Introduction Using Excel

Daniel Davis, Professional Investment Analyst

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
16 Videos (1h 20m)
    • Welcome!

      0:59
    • Course Intro

      3:44
    • Overview of Essential Technical Indicators

      7:56
    • The Project We'll Build

      7:21
    • Getting Stock Data From the Web

      7:31
    • Coding Entry and Exit Triggers

      5:08
    • Profit and Loss Calculations

      4:02
    • Profit and Loss Calculations Part 2

      5:15
    • Profit and Loss Calculations Part 3

      4:45
    • Profit and Loss Calculations Part 4

      4:54
    • Identifying "Errant Trades" and Quality Assurance

      5:11
    • Errant Trades Part 2

      6:08
    • Determining Probability of Success and Total Profit

      3:26
    • Building the Summary Data Table

      5:44
    • Highlights of the Completed Model

      4:11
    • Finishing Thoughts

      4:00

About This Class

Have you ever heard of Quantitative Investing? Do you want to sharpen your skills within Microsoft Excel?  This course will take you through the process of building a quantitative investment model in Excel.  We will build a trading model based off of the technical indicators and model various buy and sell parameters to find optimal trades.   You can use the information you glean from this model to make informed trades with high probabilities of success.  

The model we will build in this course will simulate and back test a trading strategy, outputting your performance, probability of success and average profitability per trade. 

The model will be built around an analysis of technical indicators, namely the Relative Strength Index, which we will use to determine high probability trades for any stock you wish to analyze. 

You do not need advanced excel skill or a finance background to succeed in this course, we will go through every piece step by step. 

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.  

6

Students

--

Projects

0

Reviews (0)

Daniel Davis

Professional Investment Analyst