YO CLAY 5 yrs later this is still good content. appreciate you. actually hell I think you should do a update on it. most basic tutorial I found even I can do this lol btw...do you offer any excel services? I got some things I'd like to do in their to help with my risk management. thanks
Hi there! Do you have a copy of the excel file. In the past I think you had one on Amazon . I don't want to make my own . Let me know if you have one you are willing to share or sell. Ty
Hey man, if i pay 0,75% fees on both entry and exit of my trades. How do i make the "commision" column calculate both of the Entry Price and Exit prices commisions?
nice set-up. However I am having difficulty in finding a tutorial where I could differentiate the balance amount that triggers the rest of the result on its own. I have the video saved from another source but cannot match it to my own.. This one focuses on XAU trades. Can you help? -T
Dude I was after the free excel and it led me to Amazon to pay $267 and your other link to pay 3k. where is the free stuff you said or do I need to look around in the small print??
Very helpful, Thanks a lot. What if you sell only partial amount of stock and later more at a different price? Your formula is only of all in all out....
Hello Clay, thank you for the video. You tracked back a couple of times in regards to where certain things need to be, position size etc.. What is the proper order?
@@camojoe7341 i'm still kind of confused, what do you mean "correct order"... this video was done years ago, so I can't quite remember all the details.
Hi, thanks for the video, I know it was long time ago but still good. I wanted to ask how can I do for introduce also selling actions? I have been filling the spread sheet but I have this question.... thank you!
@@claytrader Hi again vecino! I also had some issues with forex, Im not asking for a tutorial XD, just saying, I dont understand why...with USD/MXN doesn't apply like all the others (BYND, AMZN, etc..) saludos
if you're interested in "talking forex/trading in general", that's the entire idea behind my private trading community (which you are welcomed to join) which you can find here claytrader.com/team/
That was a really great video, the only thing, could be a big thing. What if I download a cvs file, and want to put it in ? Just an Idea, in the scope of 1 broker, 1 spdsht, 1 trader you know really simple.
Robert, that would be a little more work, but totally doable. What you'd have to do is make a spreadsheet with the same layout as the CSV file from your broker. Then download the csv, and copy and paste all of the data from it into your spreadsheet with the formulas in it.
What I mean is that In trading there is two transactions : long (buy) you get profit when the exit price is higher than the entry price, and, Short where you get profit if Exit price is lower than entry price, using your example all short positions will appear as losses
@@claytrader they use macro / VBA and the "=IF" criteria to buy / sell. For example "IF DOW goes to 30000, sell a 29000 put". I am also trying to find out how it can be done and this is an example here th-cam.com/video/fbwOLcsKJ3Y/w-d-xo.html
I'm using Google Spread Sheet from Google Drive... and yes, it's for free :)
Thank you for this vid, now I know more what to put in!
Glad it could help!
yeah, google sheets, or even office online will work just fine for this kind of work. glad i could help!
Google sheets? You peasant!
Would love videos on scanning and screening stocks. Thanks for the great videos.
Thanks for the feedback. Those types of videos already exist, they're here claytrader.com/courses/
This is a great introduction to basic bookkeeping.
What is your method when you scale in or out of a trade, rather than a quick 1-in, 1-out method?
if you're interested in "talking stocks/trading in general", you are more than welcomed to join my private community - claytrader.com/team/
YO CLAY 5 yrs later this is still good content. appreciate you. actually hell I think you should do a update on it. most basic tutorial I found even I can do this lol btw...do you offer any excel services? I got some things I'd like to do in their to help with my risk management. thanks
Thanks for feedback. As of now, we don't offer any excel services.
@@claytrader thanks for the reply Clay.
you're welcome
Woww! I feel like an expert now. Thanks mate, cheers! Got to keep track of my crypto gains and losses.
Happy to help!
Finally someone did this thanks
Cheers!
Glad you enjoyed it, you can thank Vic in the Inner Circle for his suggestion.
Hi there! Do you have a copy of the excel file. In the past I think you had one on Amazon . I don't want to make my own . Let me know if you have one you are willing to share or sell. Ty
Reach out to us at the site, claytrader.com
How do you create pivot tables for tracking specific patterns and probability
Good question.
Thank you ...
You're welcome Rahul.
Should you add the commission fee to your max loss?
Yeah, you could do that.
Hey man, if i pay 0,75% fees on both entry and exit of my trades. How do i make the "commision" column calculate both of the Entry Price and Exit prices commisions?
You'll need to enter in those formulas for each location.
Thank you so much! I've been waiting quite some time for someone to make a detailed explanation like this.
You're welcome.
I'm glad we could fill that need for you!
nice set-up. However I am having difficulty in finding a tutorial where I could differentiate the balance amount that triggers the rest of the result on its own. I have the video saved from another source but cannot match it to my own.. This one focuses on XAU trades.
Can you help?
-T
Sorry, not sure what you're asking.
How can i do this but for futures? The tick value is currency but my enter and exits are not currency, its in points?
Sure, you could modify it.
Dude I was after the free excel and it led me to Amazon to pay $267 and your other link to pay 3k. where is the free stuff you said or do I need to look around in the small print??
Link should be in the description box.
Great video clay
Clay soil
Thanks
Great video- thanks!
You are welcome!
Very helpful, Thanks a lot. What if you sell only partial amount of stock and later more at a different price? Your formula is only of all in all out....
Yeah, you would need to make an adjustment in that regard.
Hello Clay, thank you for the video. You tracked back a couple of times in regards to where certain things need to be, position size etc.. What is the proper order?
What do you mean "proper order"?
ClayTrader the correct order*. You didn’t say “your welcome” when I thanked you for posting the video, it helped me out. I’m not a troller.
@@camojoe7341 i'm still kind of confused, what do you mean "correct order"... this video was done years ago, so I can't quite remember all the details.
Commission should be added to the Max loss
feel free to add that in
Great! That was a helpful video. Thank you!
You're welcome.
Appreciate the feedback, thanks
Great video. Great suggestion Vic.
Good point. Vic in the chatroom nailed it with this suggestion!
Agreed, thanks for the suggestion vic! never would have thought of the topic on my own!
Hi, thanks for the video, I know it was long time ago but still good. I wanted to ask how can I do for introduce also selling actions? I have been filling the spread sheet but I have this question.... thank you!
We can maybe try to do an update video!
@@claytrader would be great... but if is possible do it soon!!! :P just kidding, thanks again from Monterrey, México
@@alanalanis6040 cheers
@@claytrader Hi again vecino! I also had some issues with forex, Im not asking for a tutorial XD, just saying, I dont understand why...with USD/MXN doesn't apply like all the others (BYND, AMZN, etc..) saludos
if you're interested in "talking forex/trading in general", that's the entire idea behind my private trading community (which you are welcomed to join) which you can find here claytrader.com/team/
Wow man! Thanks alot, i really appreciate this one!
You're welcome.
How did u get the commision?
I mean how do u compute?
Comission varies according to broker.
That was a really great video, the only thing, could be a big thing. What if I download a cvs file, and want to put it in ? Just an Idea, in the scope of 1 broker, 1 spdsht, 1 trader you know really simple.
Robert, that would be a little more work, but totally doable. What you'd have to do is make a spreadsheet with the same layout as the CSV file from your broker. Then download the csv, and copy and paste all of the data from it into your spreadsheet with the formulas in it.
The link to Excel is an amazon link to MS Office for $130... nice
Cheers
What about the half of trading activity : "Shorting" it's not included
What about it? This video is just to show you how spreadsheets work.
What I mean is that In trading there is two transactions : long (buy) you get profit when the exit price is higher than the entry price, and, Short where you get profit if Exit price is lower than entry price, using your example all short positions will appear as losses
Right. I'm aware of "long" and "short".
This spreadsheet only works if you never take a short...Just subtracting exit from entry will not work
We can try and revise
Exit price is how much you sell for
Stop loss automatically sells to limit losses
Thanks.
Hope I can do the same in Numbers on a Mac!
Don't use a Mac? ;-)
@@claytrader wash your mouth out lol
@@HandsfreeTrading haha :-)
The commission isn't $10 total ?
$5 buy
$5 sell?
Depends on the broker, but yes, that is possible.
@@claytrader thank you very much!!
Fake comments?
Only yours.
Fake Clay or Clay Double?
"Clay Double" lol
This is book keeping. Not trading from excel
How can you "trade from Excel"?
@@claytrader they use macro / VBA and the "=IF" criteria to buy / sell. For example "IF DOW goes to 30000, sell a 29000 put".
I am also trying to find out how it can be done and this is an example here th-cam.com/video/fbwOLcsKJ3Y/w-d-xo.html
I took a course and got certified for microsoft excel its worth it if anyone is interested in excel
Thanks for the thoughts.
There is so much you can do with excel, really a good way to go if you are really interested in it