Trend Following (Stock Trading) Via Quantitative Modeling In Excel

Master the principles of a stock investing or trading strategy called Trend Following used in hedge funds.

SGD$149

Immediate implementation upon learning

Free 1-year signals service
(worth SGD$320)

Shareable Certificate

100% Online

Approx. 7 hours to complete

English

certificate.png
wireless-symbol.png
global.png

SGD$469

68% OFF

implementation.png
clock-circular-outline.png
line-graphic-on-monitor-screen.png

Complimentary

Trend Simulator

What you will get in this course

report.png
paper.png
steps.png
excel.png
key2.png
qa.png

Fully completed model file that you can use for live investing

Practice sheets on financial mathematics and excel functions with solutions

Guided step-by-step model building process complete with templates

Free Excel-based resources (from the web) to download price data from yahoo finance in bulk

Trend Simulator that shows the performance of any given portfolio of stocks using the strategy taught in the course. Runs in Python.

Unlimited lifetime access anywhere, anytime. Learn at your convenience.

Prompt email Q&A support to assist your learning

line-graphic-on-monitor-screen.png

Free 1-year signals service that updates on portfolio composition and trades to be done (worth SGD$320)

simulation.png

What you will learn

  • Learn about Quantitative Investing & how it is different from conventional methods of investing

  • Know the pitfalls of buying and holding a pure stock portfolio

  • Know the criteria to choose the right stocks universe for trend following

  • Master an established quantitative method used in hedge funds called Trend Following to trade stocks

  • Understand how Trend Following works and why it is adaptive to market conditions

  • Know both the strengths and weaknesses in Trend Following

  • Use critical Excel lookup, logic, math and statistical functions required for modelling in this course

  • Understand the intuition, math and know how to implement financial concepts such as Returns and Risk

  • Where and how to get price data

  • Know how to model a buy and hold portfolio

  • Know how to incorporate transaction costs into the model

  • Understand the concept of leverage and how we can use it to boost our returns

  • Learn how to incorporate leverage and borrowing costs into the model

  • Learn the concept and math behind key investment performance metrics such as Sharpe Ratio

  • How to calculate key performance metrics and create a performance analytics worksheet for tracking model performance

  • How to create a dashboard to extract and display key information for making investment decisions

  • Know how to operate the Trend Following model

Course Content

Requirements

7 sections: ~7hrs total length

1. Introduction

2. Concept of Trend Following

3. Excel Crash Course

4. Financial Mathematics

5. Building the Trend Following Model

6. Trend Following Operations

7. Handling Dow Components Changes

idea.png
function.png
excel.png

A keen learning attitude with an open mind

Basic knowledge in Math and Statistics is preferable, but not compulsory

Basic knowledge in Excel is preferable, but not compulsory

Description

We will teach you in-depth a defensive stock investing approach known as Trend Following, from concept to implementation, whose principles are used among hedge fund professionals. This strategy is capable of creating stock portfolios that are resilient during bear markets as compared to the broad stock market. After the course, you will be able to Do-It-Yourself.

Trend Following is a powerful quantitative strategy that is grounded in well-established principles and common sense. There are no chart reading, no thick annual reports, no constant monitoring of market news, and no forecasting.

We are bundling this course together with a 1-year free signals service where we will update you on the portfolio composition and trades to be done (if any) on a daily basis through Telegram.

* The strategy taught in this course is applied to the US market.

Our Difference

hello.png
monitor.png
clock.png
bmi.png
excel.png
free.png

Say good bye to chart reading, thick annual reports, and an overload of market news

All investment decisions are driven by the model we will build in this course. 

5 minutes of your time each day to update the model is all you need

The model keeps you on course during times of market stress. The result is consistency.

We use Excel. No programming experience is required.

No need to pay for expensive tools or data subscriptions. We use only free resources.