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

If you haven’t watched that video already, go watch 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 was losing money like an idiot. But when i sat down and created this excel sheet, that you get it for free in this video, My win rate and confidence to take trades was slightly improved.

No kidding. When I started tracking down, every trade, every mistake i made, using this Excel sheet, I had a clear view on what kind of trading style I was good at. What time of the 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 the trades. Use this one. It’s absolutely free. It will even calculate your Win Rate. And will also 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 both are also free to use.

In the second column, Enter the Date you take the trade on. And In the next column, you can enter the total money you risked in the entire day. For example, If I took one trade, that had maximum loss potential of 100 dollars, I will enter 100 in this column. Similarly, If i take 2 trades, with each one having a maximum loss potential of 100 dollar, 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.

Risk per day, is self explanatory. This is where you enter the maximum risk you took per trade. For example, if you took a trade, that had 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 also help you track that.

The H and L column, are for the number of Long and Short positions you take for the day.
And in column M, you enter the total number of long and short positions.

Next column, is pretty obvious. This is where you enter the money you make or lose.
Now, 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 where winner, 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 of 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. And 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 as well, so you don’t miss any future videos.

Thanks for watching.