B The Trader

How To Use EXCEL To Track Winning Trade Strategies


Listen Later

In the last video (Trader Therapy with Jack Kellogg and Kyle Williams), a subscriber asked us how to track winning setups and what criteria we use to track them. Kyle did a great job answering that question, but I just wanted to show you how I do it with a specific Excel example.

Before we get into it, let me just say that there's no right or wrong way to track strategies. As traders, we all work in different ways and prefer different things. I'm also not a huge fan of Excel, but I love analyzing trading strategies, and I found spreadsheets to be the best way to record setups in order to find the edge.

First, I have a separate tab for each strategy that I track. Within each tab, I list all tickers that appear on my radar (this list depends on the strategy). For each of the tickers, I write out specific criteria that matter to me - volume, support level, open, close, high of the day, low of the day, etc. The idea is to find an edge - a culprit, a common pattern that will help me decide if the setup will work for me.

If I don't see an edge, maybe my criteria are too broad. Or sometimes I just need to look at more information and cross-reference it with what I already have to find a pattern.

Watch the video to see me explain my tracking method on an EDAP ticker example. Was this video helpful? How do you track your strategies?

...more
View all episodesView all episodes
Download on the App Store

B The TraderBy Alex B

  • 4.8
  • 4.8
  • 4.8
  • 4.8
  • 4.8

4.8

356 ratings


More shows like B The Trader

View all
Chat With Traders by Ian Cox and Tessa Dao

Chat With Traders

1,991 Listeners

Top Traders Unplugged by Niels Kaastrup-Larsen

Top Traders Unplugged

585 Listeners

Desire To Trade Podcast | Forex Trading & Interviews with Highly Successful Traders by Etienne Crete

Desire To Trade Podcast | Forex Trading & Interviews with Highly Successful Traders

104 Listeners

Tom Bilyeu's Impact Theory by Impact Theory

Tom Bilyeu's Impact Theory

4,699 Listeners

Swing Trading the Stock Market by Ryan Mallory

Swing Trading the Stock Market

816 Listeners

Trading Nut | Trader Interviews - Forex, Futures, Stocks (Robots & More) by Cam Hawkins

Trading Nut | Trader Interviews - Forex, Futures, Stocks (Robots & More)

218 Listeners

Investing With IBD by Investor's Business Daily

Investing With IBD

379 Listeners

The Day Trading Show by Austin Silver

The Day Trading Show

56 Listeners

Wealthion - Be Financially Resilient by Wealthion

Wealthion - Be Financially Resilient

376 Listeners

Forward Guidance by Blockworks

Forward Guidance

274 Listeners

The Money Mondays by Dan Fleyshman

The Money Mondays

455 Listeners

Thoughtful Money with Adam Taggart by Adam Taggart | Thoughtful Money

Thoughtful Money with Adam Taggart

418 Listeners

The Trader's Journey by Investors Underground

The Trader's Journey

16 Listeners

Monetary Matters with Jack Farley by Jack Farley

Monetary Matters with Jack Farley

154 Listeners

Words of Rizdom - Trading Podcast by Riz Iqbal

Words of Rizdom - Trading Podcast

32 Listeners