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.
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!
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
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
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!
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
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!
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 🤞
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!
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!
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!
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!
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?
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!!!
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 !!!
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 ?
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.
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.
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?
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.
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!
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
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
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
@@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?!
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
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 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
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!
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.
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!
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!!!
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!
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.
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.
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?
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.
![Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡](/img/n.gif)
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!
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
Subscribed!! One of the best video so far, Thanks a lot.
Thanks!
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
Awesome, I just got a lot of experience with the "IF" function now. Thanks man 👍🏿
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!
THX! For correct calculation of shares in the formula add ROUNDDOWN.
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
Thanks ....thats what i was looking for . Greetings from Wollsburg Germany
I don't even know how to thank you!!)) God bless you!) you are amazing!))
Great Stuff, really helpful thanks. Just added columns entry and exit images- done.
This would have been perfect for me when I was day-trading. Maybe later this year. Great video...onto the next one.
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!
wow thank you brother, its amazing , keep up the good work😄
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?
Amazing again! Very well done!
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!
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 🤞
Good stuff, thank you very much, God bless you!
guys can you explain what fill means and shares and how to calculate both
Your videos are awesome. Thanks. Have you made a function for leveraged trades?
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!
This is awesome, thank you.
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!
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!
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!
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?
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!!!
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
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 😔
bro thanks. i wanna know the hexa code for green colour.
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 ?
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
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!
Thank you
Excellent Video, I applaud you.
Thanks!
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.
how to fill m4 coloun pls explain about risk
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?
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!
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
AWESOME.....BRILLIANT WORK.
Thanks!
So I get pretty much everything except when he says "im going to need 250 shares". What does he mean by that?
Thank you Kindly 😊
I needed a way to keep track of my trading and this was such a perfect video. Thank you so much!
You're welcome!
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?
Can you please make an options trading journal
Can I use this for forex?
the total profit was not working
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
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
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
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
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
HOW TO DOWNLOAD THIS SHEET?
All my sheets are on my patreon! Link in the description!
I am trading cryptos, how do you keep track of take multiple "Take Profits"?
Are you Irish?
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..
Great work ... went through the entire sheet building with you .. A million blessings
Thats awesome, and thats for watching!
Can’t make shares work. Keeps saying #value!
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!
Do you have one of these for cryptocurrency?
Such an awesome 👌 video
Thank you sir.
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
Thank you
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!
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.
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.
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!
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!
Nice what about scaling in and out of my trades?
Too simple. And has no reporting.
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
For some reason when I write the coding and press enter nothing happens
What does your function look like? Maybe I can help!
🔥🔥🔥🔥
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!
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.
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 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!