Use This to Improve Your Trading Strategy
SUBSCRIBE for more Videos!

Download Excel Sheet for Free: https://bit.ly/tradingrushexcel

(show_more)

If you are not using this as a day trader, watch out. Not using this is one of the biggest mistakes that 90 percent of traders make. In this video, I’m going to respond to a comment I received on a video where I tested the MACD strategy 100 times to show its real win rate.

If you haven’t watched that video already, go watch it now! In that video, I use an Excel sheet to track my trades. I made that Excel sheet many years ago when I was new to trading and losing money like an idiot. But when I sat down and created this Excel sheet, which you get for free in this video, my win rate and confidence to take trades slightly improved.

No kidding. When I started tracking every trade and every mistake I made using this Excel sheet, I had a clear view of what kind of trading style I was good at, what time of day I made more money, and where I lost the most.

If you are a beginner trader who does not have an Excel sheet or anything similar to track your trades, use this one. It’s absolutely free. It will even calculate your win rate and show how much money you make using a graph. Once you have taken trades for the day, open this Excel file using One Drive or Google Docs. They are both free to use.

In the second column, enter the date you take the trade on. In the next column, enter the total money you risked for the entire day. For example, if I took one trade with a maximum loss potential of $100, I will enter 100 in this column. Similarly, if I take two trades, each with a maximum loss potential of $100, I will enter 200.

Column D is for the Forex pair or stock you traded. Here, enter the names of the stocks you traded for the day.

The “Risk per day” column is self-explanatory. This is where you enter the maximum risk you took per trade. For example, if you took a trade that had the potential to lose 1 percent of your account, enter 1 in the column. You should never risk more than 1 percent of your account. This Excel sheet can help you track that.

The H and L columns are for the number of long and short positions you take for the day. In column M, you enter the total number of long and short positions.

The next column is where you enter the money you made or lost. Column Q will automatically calculate and adjust your total account value when you enter the profit.

Here’s an example:

Enter your starting balance right here; otherwise, it won’t calculate properly. The graph will also change when you make and lose money. It will show the total account value.

This is where your win rate will be calculated. If you only enter the number of trades and how many of those were winners, the number of losers and total win rate will be automatically calculated. You can also see your win rate using this chart.

The other two graphs are optional. They will calculate the number of long and short trades you take. You can enter those values here.

That’s all. You asked for the Excel sheet that I use in my videos, and I made it available for you to download. You can download it using the link in the description. The link will take you to my website for my main channel. For those who don’t know, I run another channel that is not related to trading. Anyway, download the Excel sheet from my website. To open it, upload it to One Drive or Google Drive.

Subscribe to the channel for more trading videos. Check out the video where I tested RSI, Bollinger Bands, MACD, and Stochastic Indicator strategies 100 times to show their real win rate.

And don’t forget to ring that notification bell so you don’t miss any future videos.

Thanks for watching.