Это видео недоступно.
Сожалеем об этом.
How To Make A Day Trading Tracker In Google Sheets
HTML-код
- Опубликовано: 14 авг 2024
- How To Make A Day Trading Tracker In Google Sheets
📈 Link to download all my Portfolio Trackers: / thinkstocks
☑️ Follow me on Twitter: / keithfrislid
🎥 Here is the camera I use for my videos: amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
www.sahg6dtr.c...
In this video, I will walk you through the processes of making the best day trading tracker or journal in google sheets so you can stay organized, keep track of your winnings and track your progress over time! This video is long so make sure you are ready to sit in front of the computer for a while. Trust me when I say this, it is worth the watch! Make sure to like this video and subscribe to my channel to help my RUclips algorithm!
Here are all the codes in this video:
🔹Target: =IF(ISBLANK(D6)," ",(C6-D6)*2+C6)
🔹Risk =IF(ISBLANK(D6),"",$M$4)
🔹Cost =IF(ISBLANK(J6)," ",J6*G6)
🔹Profit =IF(ISBLANK(K6),"",IF(H6="Long",((K6-J6)*G6),((J6-K6)*G6)))
🔹Total Profit =SUM(L:L)
🔹Total Trades =COUNT(L:L)
🔹Win Percentage =COUNTIF(M:M,"W")/M2
🔹Date =IFS(B6="","",A6="",now(),TRUE,A6)
For some reason, RUclips doesn't allow the greater than sign in the description. Here are all the functions that contain the greater than sign, replaced with This blue circle 🔵. So you just need to manually put the greater than sign anywhere where the blue circle appears.
🔹Risk =IF(D6=0," ",If(C6🔵D6, F6/(C6-D6), F6/(D6-C6)))
🔹Shares =IF(D6=0," ",If(C6🔵D6, F6/(C6-D6), F6/(D6-C6)))
🔹Type =If(D6=0," ",If(C6🔵D6, "Long", "Short"))
🔹Result =IF(isblank(B6),"",If(isblank(K6),"OPEN",If(L6🔵0, "W", "L")))
Video Chapters:
0:00 Introduction
2:00 How It Works
5:00 How To Make This In Google Sheets
8:25 Target Function
11:30 Risk Function
14:37 Shares Function
17:37 Type Function
19:02 Cost Function
20:30 Profit Function
22:30 Result Function
24:04 Total Profit Function
24:30 Date Function
27:38 Total Trades Function
29:54 Status Data Validation
30:50 Win % Function
31:43 Finishing Touches
Disclaimer: This is not financial advice. I am not a financial advisor. This video is meant for education and entertainment. Do not use this video as investing advice and consult with a professional advisor before buying or selling securities.
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#daytradingtracker #daytradingjournal #daytrading
I needed a way to keep track of my trading and this was such a perfect video. Thank you so much!
You're welcome!
Thanks ....thats what i was looking for . Greetings from Wollsburg Germany
Great work ... went through the entire sheet building with you .. A million blessings
Thats awesome, and thats for watching!
Great video, as always! The date calculation is really clever. I think the Shares formula can be written as IF(d6=0, "", f6/(abs(c6-d6)) - a bit shorter. And the same for the Profit.
Thanks! And thats a good one for shares and profit!
SO GOOD WAY YOU EXPLAIN BEING AS A NEW LEARNER TRADING I WAS LOOKING SO MANY LOG TRADE DID NOT FIND SO COMPLETE EXPLANATION THANK YOU
Another cool breakdown here bro! Tracker is looking good 👌🏼👌🏼
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Thank you for doing this video. I'm a beginner trader and this is very helpful as a way to keep track of my progress. Keep making amazing content it is much appreciated.
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Subscribed!! One of the best video so far, Thanks a lot.
Thanks!
THX! For correct calculation of shares in the formula add ROUNDDOWN.
Awesome, I just got a lot of experience with the "IF" function now. Thanks man 👍🏿
Superb walk through. Great job! This spreadsheet is exactly what I needed and your video was very easy to follow. Again, great work!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
love this video! Thanks Stock Guy!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
awesome tutorial. I modidifed mine for futures trading and it works incredibly well. Really needed this to track my trading progress. Thank you very much
Great Stuff, really helpful thanks. Just added columns entry and exit images- done.
How can i make the target a non arbitrary number. For exampLe depending on my trade set up my RR wiLL be different. As you have shown a fixed 2/1 for every trade..
I don't even know how to thank you!!)) God bless you!) you are amazing!))
Superb video and very helpful. Thanks for sharing! Can you also please share the formula to calculate total amount won, total amount lost, average win amount and average loss amount from the Profit figures? Suggestion - it would be great if you add another row at top for Expectancy = Total Profit / Total Trades, Profit Factor = total amount won / total amount lost, total profit as % of account balance, and in the lower columns commission amount, net profit including commissions, and profit as % of cost of each trade, and share those formulas if you can. At least expectancy, profit factor, and profit as % of account balance. Thanks!
Can you make an options trading journal please! Have it also show monthly gains broken down and graphs to show the progress for YTD and MONTHLY! That would be awesome thanks for all your videos
This is a very awesome journal. Could you please make a video to incorporate instances where you partially take profits and leave some shares/positions for a runner. How do you automatically record such profits/losses in a continual trade management scenario. Like they say "partials pay". Like in real intraday trading where one opens a trade and manages it a long the way with partials. We would really appreciate an extension video covering that aspect @ThinkStockss
wow thank you brother, its amazing , keep up the good work😄
Such an awesome 👌 video
Thank you a very good video. How can you add the comissions to the formula. So that it reduces or adds the comssion before counting Profits?
Thanks for this wonderful video, but in MS excel the formula which you used for calculating Win℅ doesn't work. Could you please write here a formula to work for MS excel?
guys can you explain what fill means and shares and how to calculate both
Hello, I do not know if I did it right. But the code I got from your youtube page. Does not work for me, do you have any tips on what the problem can be? ... and a great video, as always !!!
Same problem I have 😔
Thank you sir.
Thank you
Amazing again! Very well done!
Hi ty for the video. do you know if there is a way to get Live data feed for stocks for pre-market and after hour trades? Most scrubbers' sources doesn't have a live pre-Market or after hour data.
This was amazing…. So much useful insight thank you so much!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
when i added my additional chart it doesnt get in order by % of allocation, is there a way that we can make them to show in order from maximum to minimum? thank you.
Could you tell me what formula's you would use for options instead of shares in the shares but instead Contracts or Target cause its usually single dollar amounts.
Hmm thats a tough one. Maybe the best thing is to have a separate column for contracts
really great video , i apreciate your effort , but i am facing issue with date column... its working fine when i am entering new stock name but after completing whole row its getting renamed as "DATE" not with actual date. can you say why so ?
How would you change all this for forex? How to add monthly and yearly profits? How about adding a link/ screen shot for each trade
Great Vid! Thanks Man!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Your videos are awesome , and this tutorial is a cool one thankyou, can you add an additional tab to print out a report of wins, losses , type, time, etc 🤞
how to fill m4 coloun pls explain about risk
THANK YOU SO MUCH BRO .
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!!!
Nice work! One question
Is it possible to change it to where it lets you put in fractional shares like "0.000254"
It does not work when I do something like that
Good stuff, thank you very much, God bless you!
Thanks for the codes!! Hey there is one probleemos.... the RISK...
if I change the risk later it will also change it from older trades... do you know how to fix that?
Yes! I had same problem!!
This is awesome, thank you.
bro thanks. i wanna know the hexa code for green colour.
Your videos are awesome. Thanks. Have you made a function for leveraged trades?
that is an Awesome spread sheet , I have learned a lot , I appreciate it :)
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Amazing video by the way never ever have I coded anything so pretty cool
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Amazing video, thank you for sharing your knowledge, very good content!
Question: there is a way to make the Risk factor variable? since many trades have different risk! Thank you!
Actually ive been following this here and im actually wondering if i dont use the risk/reward always at 2. my risk reward is always between 2-5.
What do you think about creating a Daily Report Card that is automatically ingested into another page that graphically displays the information? If this is way out of scope for what you do - you can tell me to pound sand! 🤣. Thanks for the Trading Journal walkthrough!
Excellent information. Do you have an Option Tracker Journal? That will awesome. Tks.
good video, but for some reason i get a error when i put in the target code
I swear you're dam amazing at making these google sheet trackers, SUB right there! I've got a request, is it possible that you can create a video to follow up on this tracker on how to include Win/Lose STREAK please, no obligations. Thanks!
Thanks man! And hmm a win lose streak would be cool. Ill have to look into how to do that!
Excellent Video, I applaud you.
Thanks!
Thank you very much!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Awsome video. I am trying to modify the sheet to accomodate for trading cryptos and displaying results against stable coins. Could/would you help me out a little?
How do I switch the coding from a short sellers pov to a long pov? I realized that its backwards for me. Thanks for your help.
What does your function look like?
Yessssss! Thank you for this!
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!
Very good helping to make a tracker. I am having one problem. After a few days, many of the dates change and I don't know how to stop it, or what I'm doing wrong.
Thats odd, did you rearrange your cells?
@@ThinkStocks Yes. I'm separating trading days between 10 cells. I'll just need to manually input after a days trading. No problem.
P.S. I'm not changing or cut/paste the date column. I'm just making room for other formula's off to the right for the days total: wins, loses, total profits, average wins, etc.
So you understand, Think Stocks, I have taken your tracker and modified it for my use. Without your formula's I would not have a tracker that I'm satisfied with.
So I get pretty much everything except when he says "im going to need 250 shares". What does he mean by that?
My friend, you would be an absolute legend if you could help me out here.
I buy certain stocks, Apple, Microsoft, Next Era, Pfizer on dips off their recent highs.
Is there a formula to indicate when a stock has dipped by, say, 5% off recent high? And every additional dip of 3% until it hits bottom.
I then leave it alone until the price passes the previous recent high and the process begins again.
I have been using this simple yet effective method with these companies for the past 5 years and the returns have been quite good.
Using a pen and paper method however, is tedious and slow.
Hey Ned, that doesn't sound too hard. I can make a video showing how to do that. If you want a quicker response go to my channel and in the about section email and ill show you what I was quickly able to come up with!
@@ThinkStocks That would be incredible.
Thank you
I love this and have mine set up with several month tabs to keep track of my monthly trades. Was wondering how do I carry over my total profits from one monthly sheet over to another month . i made a cell for the month profits just want to carry over the total profits at the top of the sheet, thanks for your time.
Glad you liked it!
Nice what about scaling in and out of my trades?
AWESOME.....BRILLIANT WORK.
Thanks!
all the spread sheets I keep looking at don't do financial year data... for example, if I bought in June sell in October the same year, it needs to be recorded for the financial year that October falls in so as to report my taxes... if you bought 2 years ago it doesn't count for the FY until you sell it... these data sheets that I keep looking at don't show the report to send to my accountant to report the year that the loss or profit was made in..
I made a really nice trading journal in excel with filters and charts for analysis, if you want to take a look its the only video of my channel. Maybe drop a suggestion or anything you didnt like, I would really appreciate it!!!
Thank you Kindly 😊
Hi mate I have enjoyed your work. I supported your site. Can u help me out I am trying to set up a valid date and can not get it working so when I add a new ticker it updates automatically thank u 🙏
Hey Kevin, thanks for the support! If you want send me a copy of your tracker and I'll see if I can fit it! You can find my email in the about section on my channel
Do you have one of these for cryptocurrency?
What if I only risk 10% of my account on every trade and my account obviously varys day to day is there a way to put the risk as 10% of a $amount that I can constantly change
Hmm. If you keep track of your overall account value somewhere on the sheet you can then make the risk cell =[account value]*0.10 and that will get you the 10% risk
@@ThinkStocks your the man thanks for the quick response you get another sub sir😉
Thanks man!
@@ThinkStocks so I would write =(N2)*0.10
enter
Assuming N2 is where I placed my account value and I write that in the risk cell
new in trading. what does "fill" do? or how to use it?
Fill is what price you got into the position for. Just because you set an order for say 100 dollars doesn't mean you get "filled" for 100. You might get filled at 99.99 dollars. And when day trading every penny counts!
Can you please make an options trading journal
Can I use this for forex?
This is really really good. But a more automated approach where you enter transactions and it gets automatically updated on this table would be next level. In one Google sheet, we can have both our journal, and open positions as well, which makes tracking both open and closed trades way easier instead of manually entering into the journal every time. But really, your sheets have helped a lot. A big thanks to you.
My goal is to keep learning each day and share with you guys what I've learned. Hopefully one day I'll get there!
What does the risk does? I didnt get the concept
Its how much money you are "risking" each trade. Or where you are taking your losses. So if you loss say 200 dollars on a trade that's where your stop loss is. And in day trading its always important to have at least a 2 to 1 win lose ratio. So it you have your stop loss at 200 dollars you should aim to make 400 dollars profit
For some reason when I write the coding and press enter nothing happens
What does your function look like? Maybe I can help!
the total profit was not working
Is there another video where you explain all the terminology (5a thru 5n)?
The terminology in the functions or the actual terminology of the words?
@@ThinkStocks the words, from "entry" thru to "exit"
Ah okay. I do not have a video but I'm adding that to the list now!
@@ThinkStocks great!! Please!! Would be very helpful! The chart/sheet is amazingly clean and very well organized!!
Another small issue is, as someone else in comments had mentioned, if you change the RISK at the top, it will change the value for all entries.. Is there any way to get around that?!
For now there's not really a way around it unless you remove the code from the previous stocks with smaller risk
HOW TO DOWNLOAD THIS SHEET?
All my sheets are on my patreon! Link in the description!
Can’t make shares work. Keeps saying #value!
This tracker isn{t in your patreon
Hey, I just double checked to make sure it is still on my patreon and it is. If you click on the link to the folder with all my traders its the 4th one. Should say "4. Day Trading Journal" the tracker has a dashboard on the first sheet so the thumbnail to the sheet might look different. But once you click on it you will see its the same thing
I am trading cryptos, how do you keep track of take multiple "Take Profits"?
🔥🔥🔥🔥
Are you Irish?
Too simple. And has no reporting.
Thank you
Thank you