Finding an Edge in Trading using Spreadsheets
HTML-код
- Опубликовано: 9 фев 2025
- This episode has me digging into my trading journal spreadsheets and going over some of the statistical data that helps me make decisions on which setups to focus on and which to avoid.
Track these kind of stats and more with Trader Vue: bit.ly/traderv...
Last weeks video on overtrading can be found here: • Overtrading and Patience
Trading Tickers: bit.ly/tradingt...
Epidemic Sound: bit.ly/3odv3HR
FOLLOW ME:
Twitter: / sublimetrades
Instagram: / climb.higher
See my verified trades on profit.ly at bit.ly/sublimet...
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
This is pure gold. I’m so upset with myself for not tracking my trades with this level of detail. I will immediately be changing that. Thank you for this. (FeedTheBull)
Yep it’s never too late to start. I had nowhere near this level of detail when I was first starting out.
This spreadsheet is lit! So clean and professional. We need a video lesson on how to make one. Thanks in advance!
The best part of this is learning Excel skills you didn't know you needed.
Really great video! Can't believe I only found this video 18 months into trading.
Glad it was helpful!
This video was so good! Any more videos like this would be greatly appreciated. And thank you for putting in all the effort to show us :)
Yeah I’m getting good feedback on this one. Any suggestions for other things to talk about in this area?
@@SublimeTrades I would love to see a video on how you analyse each individual trade. I have my own way of doing it but would be interested to see how you do it. Thanks again :)
Thanks a lot for this man! Lot's of traders hide there spreadsheet which causes me to be confused when making my own. Seeing how you calculate all yours really helps put mine into perspective, more of this content please!
I was very protective of my spreadsheet for a long time. And I’m still not willing to just give out blank versions of it.
Sublime Trades I understand, but even giving us a general guideline on how to make our own would be awesome
@@SublimeTrades why not charge for the blank sheet? It's very good, you can make some side income and you're not really giving away your edges....WIN-WIN for everyone.
The amount of work you've put in here is why you're so successful. Awesome work man! Really good information here. Thank you for sharing!
Yeah it’s definitely a big part of it
Outstanding video, learned alot about tracking, thanks in advance
Glad it was helpful!
“Now I see!” Said the blind man. Thank you for showing so much light on this subject! I need to to replay this over and over again.
That’s great! Happy to help.
Thank you John for this informative tutorial. You really let us take a good look around behind the iron curtain so much appreciated. I have two questions for you: 1) In your spreadsheet, you have columns titled 'Initial Risk', 'Mental Stop Limit', 'Initial Risk' - can you elaborate on these? why have two columns for the same thing and does this mean you use mental stops instead of hard ones? 2) How are you calculating 'Initial % Risk'? Thanks a lot.
At the time I made this I only used mental stops, I almost always use hard stops now with listed stocks but I still use mental stops on OTCs. The mental stops limit column is the price level I am risking off of. The first “initial risk” column is my risk per share so like 5 cents or 28 cents or whatever it is on that trade. And the second initial risk column is my risk in dollars for the position, so maybe $584 risk, based on the risk per share and the number of shares.
This is the best video on youtube about building a edge
Thanks!
Sup man, really inspired me to further advance my spreadsheet of tracking so i appreciate that. Do you factor in comissions when calculating the averages?
Thank you so much! I'd love to learn a bit more how you set up your chart. TIA!!
Noted!
Hey John P, I see this video is about a year old... have you done an update on how those strategies are working out now? Did you decide to stick more to your bread-and-butter OTC breakouts or kept trading all the strategies equally? Also thanks for posting these videos.
I hardly play the reverse split strategy anymore but I still play the others.
@@SublimeTrades Makes sense. The reverse splits I've seen this year have not performed like the ones a year ago
Love it. Love the uptrend. Can you please provide a sample spreadsheet to start off with
Nope I can’t, but you can pretty much see everything that’s in my spreadsheet and should be able to recreate it yourself.
hi, how do you find past data on strategies like a gap up shorts or multiday breakout on specific dates. I am having trouble getting float and pre-market volume on past stocks
Most of the brokers with paid data should let you pull past data like that.
Such an amazing video! Definitely got me excited to track my own data!
Great!
Hey man, great stuff. I started with sykes , but also learned a ton from his students like Matt Monaco and Jack kellog, and now you also, so thanks for doing this. One question I got, is I see your win to loss ratio when it comes to dollar and percentage is different, like the last example with the otc breakouts the % ratio is 2.2 but in the column above where you look at dollar amount it is 1.68. Instinctively I feel like the ratio should be the same, but I'm prob missing something obv, Is that because you don't keep your sizing consistent or why is that?
Those would only be the same if you used the exact same position size every trade. I use the Kelly criterion which keeps me constantly sizing up as my account grows. I used to have risk as small as $25 or $50, and I gone as big as $2k risk. That’s why I started tracking it in terms of percent gains/loss. Those will stay constant regardless of how big the position is.
Hey John did you make this spreadsheet yourself ? Would you share a blank copy ? Very nice vid ! I wouldn't mind paying for it too!
Yes I made the spreadsheet myself. It’s not for sale. It’s more helpful to you if you make one yourself so you understand everything going into all the calculations.
Very very useful...Thanks
You’re welcome
Excellent video. Very clear. Thank you for the free content!
Happy to help!
have you calculated how many days these otc multiday break outs last and which days are the best to enter?
Yep
Any chance of you setting up a link to this spreadsheet as a template? I am a very experienced Excel user but can't follow this spreadsheet as you move around it so quickly and constrict the view so tightly.
Nope, sorry. My intention was not to have anyone attempt to reproduce my spreadsheet exactly, hence the reason I didn’t zoom in super close. I was very hesitant about even going into this much detail about my spreadsheets.
@@SublimeTrades That's a shame, it looks like a really sophisticated and useful spreadsheet.
edge is edge, sublime has put a lot of time and effort into all he does and himself within reasonable management. dang it i wish i started earlier myself. i see his passion and drive and growth with no ego which is key to myself. awesome vid and insight. thanks
I wish I could build a spreadsheet like that and start from scratch.
You can
@@krs1476 yes you can!
"Wish" typical word used by people who don`t want to put in the work
this is pure gold. Thanks mate.
Happy to help
Good Analysis I have mine but would like to add a couple of your items if you don't mind
Go for it!
Beautiful.
Thanks man
Fantastic video, John. Thank you for sharing. This spreadsheet, is this a template that you downloaded from somewhere, or did you build this out from scratch on Excel or Numbers?
I made the spreadsheet myself.
Hello now that Equity Feed has switched to Scanz which scanner do you use?
I'm using scanz now.
Great video man, brings a lot of value !
Awesome! Glad to help!
Very useful insights, thanks, brother!
Happy to help!
More than awesome mate 😊.any recommend stuff to learn about these spreadsheets formulas, I absolutely have zero experience in this
Just google it. Or for more in depth, focused training, I’m sure you can find courses on Udemy
awesome video man!
Thanks
Which scanners do u use?
I’m currently using StocksToTrade and Scanz
@@SublimeTrades 👍 thanks
another great video, thanks for that insight John
Thanks for watching, Jake
Really useful stuff man, thanks!
Happy to help!
These videos are much appreciated🙏
That’s great
Great video, buddy! You're an inspiration!
Thanks!
How much did you started with?
About $12.5k, and then added another $11.5k after I lost a bunch.
@@SublimeTrades I see, I really like your content! keep it up!
thanks john!
Happy to help
great content!!! congrats on your profits!!!
Thank you
niceee video ..! you just have to keep experimenting until you find your edge by keeping losses small and track to find what works best for you, yes this will take few months but worth it, you're experimenting with 3-4 strategy and one which working pretty well is OTC multiday breakout where you made more than $80k , awesome.........!
I’ve actually experimented with probably 30 strategies, and these 4 are where I’ve found an edge
Here before 1,000,000 views. 🙂
This was a sick video.
Thanks Jack!
Great vid
Thanks
Great job! Thx to share your proccess with us
You’re welcome
I received messages from someone I believe is impersonating you
Yeah be careful. Lots of scammers out there. I never initiate conversations with any of my followers through dms. And I don't trade anyone's money for them. And I've never traded crypto lol.
@@SublimeTrades I figured that. He had liked pages for the Illuminati of Kenya lol 😆
@@SublimeTrades he asked me to donate to his company and he would pay me interest in BTC
One good thing care out of it.. you got a new subscriber 👍