How to Create a Day Trading Tracker in Google Sheets (Step by Step)

Get 50% off of Seeking Alpha Premium!

In this video, I take you step by step on how to make an extremely useful interactive day trading tracker. This tracker can be use to track the successfulness of your trading, as well as provide some valuable insight to analytics that may help your future trading.

Formulas Below:

Trades Placed Profit
=if(E8=0,"",(D8-C8)*E8)

Trades Placed W/L (*Note: youtube does not allow the greater than or less than sign in the description, so replace the word greater than in the formula below with the greater than sign.)
=if(E8=0,"",IF(F8 greater than 0,"W","L"))

Days Traded Date:
=unique(A8:A)

Days Traded Profit:
=if(I8=0,"",SUMIF(A$8:A,I8,F$8:F))

Days of the Month values:
=SUMIF($I$8:$I,date($N$7,$L8,O$7),$J$8:$J)

Win Amount Total:
=sumif(G8:G500,"W",F8:F500)

Loss Amount Total:
=sumif(G8:G500,"L",F8:F500)

Dashboard Wins:
=COUNTIF(Recording!G8:G500,"W")

Dashboard Losses:
=COUNTIF(Recording!G8:G500,"L")

*Note* - These formulas are based off of where my prior data is located. You may have to change what cells the data is pulling from based off of where you put your prior data.

If you are having trouble, be sure to ask a question in the comments or head to my patreon page and download this spreadsheet for your own use!

Thanks for watching and don't forget to like and subscribe!

#DayTrading #DayTradingTracker #GoogleSheets

[toniomiklo]

I'm full of admiration for the way you seem to have mastered Excel. I don't think there's anything like this on YT. Very original content.

[nothingable]

Oh my, this was amazing, thank you so much, I wanted to improve my spreadsheet journal and this blew mine away! Really appreciate you sharing your expertise!

[CodConquest]

For those who are having an issue with the Days of the Month function where it is displaying a "0" value you need to ensure that your columns which holds the date values (In his example it's Columns A and I) are set to the date format. In addition, you have to ensure that the way you are writing the date matches the format set. Hope this helps.

[barneygaumer]

Ur vid was fire bro! It took me from zero to hero in about an hour. I hacked it up a little to suite my needs but seriously could not have gotten the results I got without your vid. Thanks much!! Cheers!!

[AshleyMelling-ce]

In the case of the formula =SUMIF($I$4:$I, date($N$4, $L4, O$4), $J$4:$J), the date function is referring to the cell $N$4, which contains the formula itself. This creates a circular dependency, and the spreadsheet cannot calculate the formula.

To fix this error, you can either:

Move the formula to a cell that is not contained within the range of cells that it refers to.
Change the reference in the formula so that it does not refer to a range that contains the formula itself.
If you are using the iterative calculation setting, you can also ignore the error message and allow the spreadsheet to calculate the formula. However, this may result in inaccurate results.

To enable iterative calculation, go to File - Settings - Calculation and select "Enable iterative calculation".

[jimpowell]

I really do like your trading journal and the way it is laid out. I just wish it was also setup for options trading and tracking. That would be fantastic. Other than that, it is a really great trading journal.

[luthervaryus]

The most utilitarian and simple (in a good way) methodology for tracking trades I’ve seen. You also have a excellent way of leading through your process. Well put together. I’ll definitely sign up for your patreon.

[theharmoniholic]

the ability to add long or short position would be the finishing touch

[socialonly]

Thank you a lot, we do appreciate the effort and the time put on this awesome work

[DaTruthHurtzzzz]

hands down the best video, not only was I beginner and you helped me understand so much you made it really easy to understand. You deserve WAYY more views and likes

[yekaterinagarmash]

This video was extremely helpful and a great way for me to orgnize all the information. Massive thank you!

[Kwuasimoto]

This is a super good video man, very simple for a beginner at excel/spreadsheets to understand. One thing that could help is explaining to users what combinations of CTRL+SHIFT you're using to highlight the columns. Other than that, great job mang thanks!

[alexandrocalvin]

It is amazing having a people like you, giving us the best information for making our workflow more efficient enough! Can't thank you enough mate! Well done!!!😊🙏🏻

[fjori]

Amazing video and super helpful.
I still got a question though. If you bough 4 shares of AAPL at a price of 114.98 as shown in the video but then you add 3 more shares at 115.2 and sold everything at 137.42, what formula can be used in this situation?

[aladinzahran]

What an amazing video, it is not only about a world class tracking trades sheet but also an awesome educational presentation about Google Sheets. Great job! Thank you so much 👍

[zanderrichens]

Absolutely love this video! this is why I love YouTube, because of such incredible content by people like you! thank you so much, man! Earned a Sub!

[blacklitecontent]

Wonderful video, very enjoyable to follow along. Great tracker and perfect instruction. Thank you good sir.

[jimmyj]

This was brilliant. Thank you for the time and effort you put into this. Very much appreciated!

[jeromealbertyn]

So simple and easy to understand. Well done!!

[nuthinbutbusiness]

Do you have a spreadsheet for FOREX traders? Or how can I adapt your spreadsheet for the Forex market?