Discover this podcast and so much more

Podcasts are free to enjoy without a subscription. We also offer ebooks, audiobooks, and so much more for just $11.99/month.

How To Use EXCEL To Track Winning Trade Strategies

How To Use EXCEL To Track Winning Trade Strategies

FromB The Trader


How To Use EXCEL To Track Winning Trade Strategies

FromB The Trader

ratings:
Length:
14 minutes
Released:
Jan 26, 2020
Format:
Podcast episode

Description

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?  
Released:
Jan 26, 2020
Format:
Podcast episode

Titles in the series (100)

Sharing my trading journey and interviewing successful traders along the way to help you learn and become a more profitable trader!