Roaring Kitty - Tools Part 3 of 3 (spreadsheets)
Вставка
- Опубліковано 12 лип 2020
- In this video I walk through the spreadsheets I lean on for my investment process. This is the second of two long tools videos - if you can only watch one, watch this one. Recorded on 6/23/20.
The primary sheets include:
- 3:30 Universe: for maintaining my universe of stocks
- 21:35 Company: for performing fundamental analysis
- 39:12 Tracker: for tracking stocks
--- 39:12 dashboard
--- 43:46 Roaring Kitty portfolio
--- 1:03:05 Buy/Sell lists
--- 1:05:45 Pulse list
--- 1:06:45 Trend list & commentary on March 2020
--- 1:18:27 Industry filter
--- 1:22:01 Industry breakout
--- 1:26:20 Daily movers
--- 1:32:54 Insider buying
--- 1:38:38 CSV export
--- 1:42:31 Screener
--- 1:45:25 Exporting filtered data to CSV = painful tangent unless you're a spreadsheet nerd
--- 1:48:35 Rounding it out
The Roaring Kitty channel revolves around educational live streams where I share my daily routine of tracking stocks and performing investment research.
My investment style involves continually tracking thousands of stocks using a variety of widely available tools. When opportunity strikes - as it occasionally does in markets comprised of biased humans - I’m prepared to pounce and capitalize on the situation. I'm probably best classified as a fundamentals-focused deep value investor, though I find I'm increasingly leaning on technical analysis for screening, timing, and tracking stocks. In the years ahead I look forward to honing my portfolio management approach by acquiring bolt-on skillsets and further developing my approach to risk management.
Some of the tools I use: Google Chrome, Chrome extensions & search engines, Google Sheets / Google Apps Script / StackOverflow, StockCharts, insider buying via OpenInsider, stock ownership via WhaleWisdom, SEC filings via sec.gov, SeekingAlpha, Twitter, Quandl / Sharadar, and bond prices via FINRA.
The Roaring Kitty channel and live streams are for educational purposes only. I share my approach to investing in an effort to set you on the right path to building out your own investment process. I don't provide personal investment advice or stock recommendations during the stream. Please understand that my style of investing is extremely aggressive and I take on a substantial amount of risk. It's likely my approach would not be suitable for you. If you're seeking personalized advice, I encourage you to sit down with a financial professional who can review your personal situation, financial background, risk tolerance, etc. Check out the Roaring Kitty disclaimer video for more information: • Roaring Kitty - Discla...
Who is here in 2024!!!!
Here now lol
I'll still be here in 2034.
Sitting on 350 shares on June 20, 2024 ... its 710pm on thursday.....
@@imakez4u1353 and buying
Here
No way DFV wasn't a dude who knew wtf he was doing. Humble, educational and chill. Really like this guy.
He’s definitely an expert level investor.
WE LIKE THIS GUY!
@@Slider14967 WE LIKE THE KITTY
Check out his broker profile. Guy knows his stuff.
Same... HE IS GOLD HAHA
This man built a bloomberg terminal in excel (sheets) goddamn
He can afford to pay 30k a year for Bloomberg terminal now lol
As a coder his disclaimer that coders see this and know it can be done simpler, with e.g python, is correct.
I have so much more technical skill than this guy, but he has something way better: insight.
He made some tools for what he needed: understand the market. no need to go nuts with technical shit.
Effective, Chill, smart, what a guy.
@@momentofclarity873 just learn the api of your data provider and then use pandas.
You need some years of training.
But The whole point of my comment was effectivness.
Not the way to go If you wanna be a trader.
DFV used lame Excel, but look what he did with it.
Effectivness, if you go too deep you'll never get to the point. Wich is choosing stocks!
its not even excel
@@brianhoy too many clicks. Hates clicks.
31:03 "Nobody's paying me for these......Nobody knows who I am......I'm a nobody."
Not anymore 😂🤣
Now he's gonna get bombarded with sponsorships lol
the man is a living legend
He's the man, who stuck IT to the man 😂🙏
He left UA-cam and the internet@@amir-ng6jv
This guy is a genius. Commenting for visibility.
RoaringKitty, the type of dude to call himself not smart and lazy and also have created this monster of an xls sheet. Damn this is the most humble guy i've seen talk ever.
Happy for your success, my dude!
The markets will humble anyone that thinks they are right.
He's a CFA - those exams are insanely difficult
Tbh, making this excel sheet isn't hard, most people who use excel seriously and daily probably know how to make one of these.
However, like the other guy was saying, the dude is chartered CFA, he's definitely smart
I think all people are lazy and thats why we have technology moving forward so fast. We automate and make everything easier cus we are lazy. But it requires some work at first. But in long term it pays off
True revolution won't come from people burning cars. It came from a humble guy smiling with his spreadsheets.
What about attacking the US capital during vote certification and murdering cops in the process. Did you happen to see that?
@@jefffoster8614 as well, those assholes wont bring change. Change will come from a guy like this.
@@NoName-to5xl BLM is the new civil rights movement, which brought real change to USA. Educate urself. Stop being fooled by the optics of burning cars and broken windows, Be smarter. Or as freak Melania said 'be best' WTF???
@@jefffoster8614 civil rights movement by crashing other peoples lifes, lol jokes on you
@@florinho1994 WTF does 'crashing other poeples lifes' mean stevie ?? And I'm not referring to the failed grammar...
floored with your work ethic... as a former international equity trader in NYC myself, nobody on my trading floor of hundreds of traders did this much research on a single stock ... impressed
@@GabrielGosselin there is a distinction to be made in reasoning about buildings and structures, and stocks.
This is a whole new level.
Sunday: Binge watch all of DFV's videos on research methods and tools
Monday: Yolo on waay OTM weekly calls on meme stocks
This is the way
This is the way
This is the way
GUILTY
What's OTM
His face and body language indicates he feels so content from inside and that should be the purpose of life.
Exactly, you can tell he just loves researching stocks. Results speak for itself.
"You're gonna see how lazy I am."
(*2 hours of spreadsheets later...)
I can see how you get those 50-100% returns, there's not a lot of speculation really; you do a hell of a lot of research work.
Thanks mate for showing us your processes, you deserve every success.
Good luck in future and I hope you retain your natural cheerful disposition and excitement for your work.
The reality is it's all speculation. But I get what you're saying. Just his speculation was backed by research/analysis. The guy has a CFA charter he's not like the majority of these bums on UA-cam investing mostly on historical chart data
Half a billion dollars later
This guy is an absolute inspiration. I'm incredibly happy and proud of the success he's had. What a guy. Thank you!
Dude, this guy's enthusiasm over this stuff. Such a gearhead. I love it.
This video goes on to show that a LOT of preparation goes before you hit a jackpot in any field. Yes, luck may play a role but you can never discount sheer hard work!
Luck is opportunity meeting preparation
Going back and watching all the videos again. You’re a freaking genius, and the best part is you’re humble about it. I love your work and everything that goes into what you do, especially the thoroughness of keeping the past 20 years to keep what stocks are doing in check. Your work is my inspiration. & This is why…. GME to the moon. 🚀🌙
Hey Keith, if you still read these, I really appreciate your videos. Outside of GME, I find these videos educational and actually help me become a better investor.
Thank you so much. Hope you are well.
Really hope he does read here. I try to understand his method, you got any tips and source ? Is there a specific name/term for the type of analysis he runs ?
Same
Trying to understand investments in general and especially his methods so I can break into VC
@PatrickGartner-od6xs he's a deep value investor. Old school Ben Graham type. Read security analysis and these videos will make a ton more sense.
Appreciate the tip - a beginner
JFC this guy is a maniac! SMH the amount of time dedicated to this endeavor is almost unfathomable. He loves to say he's lazy, but, he puts in some serious hours for all of this. The reward for that work is downtime and enjoying his work in material gains. Super impressive, my guy.
On top of that, he's stoic af. He is chill about ditching old processes/tools for new ones, and just learning from it. No emotional panic.
OK now you have the funds, you gotta build your dream program that does everything these spreadsheets do. I'd gladly pay a subscription to something like that
Like an affordable Bloomberg terminal for retail investors
🚀 The DeepFuckingValue Terminal 🚀
#DFV Terminal
He has a cat , just call it the litterbox
So, after 1 year, Googled DFV Terminal and nothing... Not a single software developer came accross this comment?
@@FilipeSilva1 I did. Building a language interface into this data, so you don't gotta fuck around jumping to different sources.
“If you’re not into spreadsheets I don’t know what the hell you’re doin here” 👀
he said that right after I read your comment
I hate spreadsheets, that's how lazy I am.
It's a great way to grab a couple of idea's to add to your own research, even if you don't deep dive like he does.
Depends on the time frame you have for investing, DFV clearly uses longer term time frames than day traders.
@@scottydog9997 absolutely. Personally I love spreadsheets, but even for those who don’t it’s a great way to see how he analyzes companies.
@@MuffinManStories I'm more of a day/swing trader, but I do use certain fundamentals in my research before I build a thesis.
I tend to scalp intraday and build into a larger long term position. You really need a combo of technical and fundamental research to be successful in this game, and even then you could be wrong. One of RK's submissions on WSB showed he had a drawdown of 50% on G_M_E prior, most would have closed that position unless they were truly confident in its upside potential.
Just added insider trading, and market sentiment as part of that thesis thanks to DFV.
Will have to thank him someday for the tips.
How does it feel that you are amongst the likes of Graham, Buffett and Munger, you absolute god.
You are legend. What you did was more than a “bet”, you changed lives, exposed what’s wrong with the system and started a movement. Me and many others missed the train, but still thank you for what you did. You deserve everything and more.
Agreed. I'm seriously worried for his safety now.
@@regaininglife9084 he definitely might get framed for some bullshit charges like insider trading or some shit like that. Hedge funds have a lot of powerful friends to frame this as illegal.
@@fl3669 it would be hard to prove he did anything illegal (not that he did). Not like DFV won’t have the capital to sustain a tough lawsuit now should it ever happen 🤣
@@LiberationofSins lmao true.
Nah dude everyone who is actually has been on wsb for longer than 3 weeks knows that it is all about the tendies. In 2019 everyone was praying for a stock market crash. Wsb doesn’t give a shit about any ideology we just like the stock.
"I'm a nobody" .. that statement aged well.
We love you DFV. Godbless. Thank you for the eduction and knowledge. God is on your side.
feels good going back to watch these old videos huh? to the moon!
I would absolutely watch the "take the day off work" run thru of this thing
1:28:29 It is cool RK. I like it a lot - really look forward to getting to your level of sophistication on the journey. I just really wish you would come back - you would have been a great companion on the road these past 3 years.
Kitty’s back.
@@instapwnxcame back to own 2.1% of the company.
rewatching everything from you @RoaringKitty ❤ thanks for all the educational info
I am a software developer watching this to get ideas on how to build out my automated trading bot using market data APIs... just know that there are plenty of people just as nerdy as you (if not more) and this is fascinating. You're right when you say it would be easier to build the features you want (the submit button, connecting everything together in one UI instead of multiple sheets, automatically updating the portfolio, buy, sell sheets, etc). I think you wouldn't have trouble finding someone to help you build out that platform, I personally would love to do it, it sounds fun. It's fun to build something for someone like you who has such a pure vision of what you want and such a grateful attitude. You deserve all the success you have had.
I did watch the whole thing, while sipping first beer then whiskey. Thanks for sharing your mad wisdom.
No joke though, if you create that application and make look sexy and simple UI. It could turn into one of the biggest "Deep Value Investing" tool the app store has yet to see.
Trick is to make it free with donations. Kinda like Reddit and wikipedia
I will help you do this. I'm trying to figure out how he got the insider buying data into a spreadsheet. Would be so nice if this was in an app.
@@reidhommedahl2180 hey i got insider data in my spreadsheet. But im German there is a Site where daily insider buyings are listed. I just grab them with xPath and Sum the "Buys" up for last 6 months and output is an integer. if the number is high i manually research volume and things like that.
But i have no idea which Database he has connected to his sheet to get all this earnings and so on ???
@@crazytraintv4988 @Reid Hommedahl @Mats Norway @Unit In Tow @Jeff Gran - I am TOTALLY down. Lets do this. We need a spot to chat, how about someone starting a Reddit community? Or, if someone has a better idea/spot - post it below. I would start one but my account is not old enough yet. As a group, we can do this. It has to be done. Fingers crossed!!
The more I learn about you, the more I wonder what you were doing in the r/WSB sub. But now, the answer is clear. You always wanted to truly help others and we can see that from the appreciation you have for tools, people, etc. KG, you are an incredible person and you MUST know that you have helped a tremendous amount of people. I am so grateful that you made these videos so that one day, I may be at the position you were in when making said videos. Thank you.
Just watched part 2 with my wife at dinner - she (we) can’t believe how appreciative, humble and kind you are in giving out the site shoutouts.
Building out my tool now, and it’s fantastic to be able to see what information you are pulling into your fundamental analysis / dashboards.
Thanks man.
Amen
Bro, did you create the same tool?
God damn he is such a genuine person. I am really happy that he won big time, he did the work and it paid off. Good!
wow after watching this today I realize how u/DFK made so much money
The crazy thing is that it was only 1% of his portfolio, which would mean his porfolio was 5 million probably. The narrative will be that it was luck but he has mad skill and has probably been making good money for years
@@tomb8069 so true haha definitely going through these vids to learn from the master 💎🤲
@@UnderTheBar yep, after looking into some more i think my estimate was way too high. Sounds like he built it into a way bigger % of his portfolio. Mad props
@@tomb8069 So it was more than 1% of his portfolio? He's still a god either way just trying to clarify.
@@mfeeney87 yes, not sure exactly how much but it was a very large % of portfolio. It was 1% originally and then sized up a lot
Back in 2021 I was looking at GameStop and amc before they went up. Everything was undervalued. I switched to crypto which was exploding. I like watching roaring kitty vids. He is a smart guy
with all of this crazyness right now, i just wanna say thank you for sharing your tools, i am learning so much from this. It's sad that all the hype now revolves around GME and not the fact that you teach people for free on how to invest. So thank you!
20:20 - “I don’t even know what it means..it just works!”
this, my friends, is the way to learn how to use spreadsheets. we don’t get extra points for style; we get extra points with good decisions from good information
Great video, you never ever need to apologise for the quality of your videos! By far the most interesting and insightful I have come across in 10 years of watching youtube investing videos.
I work with spreadsheets so much at work and I love them so greatly. This is the most magnificent thing I have ever seen... I am crazy impressed.
HELL YEAH KEITH!!
We love you. Glad to see you are doing well. Excited to see what the future holds. Wishing you all the best 💜
I COMPLETELY agree with the need for "Context", conditional formatting, and MINIMAL scrolling. Spreadsheets offer these features. But most web based views do not. This guy is a humble genius.
incredibly humble and intelligent. Very entertaining to watch and learn from! Man I love this dude.
Man... I can't tell you how much I've learned. Thank you so much for doing this.
He will never read these comments, scrolling is required.
lmaooo
legends don't have time to scroll
no scroll, he roll
Coming back to these videos months after I first saw them and didn't understand heads or tails of them, then going through literal weeks worth of DD over the coming months after the spike in January and now understanding so much of this has shown me just how far I've come as an investor.
And how much further I need to go. I sincerely hope you continue making youtube videos DFV/Roaring Kitty/Keith. To call you a genuine guru would be an understatement and I sincerely want to keep learning from you. Thank you. So much. For everything.
It is so easy to go nuts with spreadsheets.. You step away for a few months and don't remember how you initially set something up..
You have to be good with the fundamentals of spreadsheets. Formulas, pointing, getting. I just don't have the patience or organizational tools.
Many have said this, he'll never read this, but... he told us to comment if we stayed till the end so here I am. Truly seems so genuine. As a father of a 2 year old, I loved the beginning (paraphrasing) "let's get crazy... OKAY wait, don't wake up my daughter."
this is incredible, for a newbie who never really entered the finance industry but still wants to do VI, you showed the way!!!
Most humble investor I've ever seen. Props to you and all of your hard work
I don't know if I'm more impressed by the GME play or the spreadsheets haha. Great context for how you operate. Also as others are saying you deserve all the success and seem like a genuinely good dude. Best of luck with the hearing and hope you decide to keep the channel going!
This dude deserves every cent earned in his time as a trader. All the hard work put into researching has payed off in dividends. Literally...
Jan 28 2021: WhoTF knew that this total unknown dudes bullishness on a shitty little stock would *ROCK THE ENTIRE WORLD!!*
A lot of us. thats how it happened.
5 months ago WSB have like more than 500k degenerates even MrBeast know them back then
Most likable dude I’ve watched in a while. You deserve all your gains bro. Thank you for this.
I can’t express how much I look forward to your future video’s
47:21 GME was only 1.18% of his portfolio in July wow
You have my utmost respect. You've earned every cent, but I am sure you appreciate the situation far beyond the monetary gains.
These videos still bring me joy and educational material. Thank you DFV
Lot of work in your spreadsheets! Cool way to watch the markets. The integration and ability to scan and see key items quickly makes for an interesting process. Nice work!
This guy is my hero. Seriously. I hope he gets bored and makes more videos after the smoke clears. Either way, roaring kitty is legendary.
DFV: “these spreadsheets are so basic”
me: omg. im v dumb 😬
Same🤷🏻♀️
I’m just as thankful, if not more, for your insightful videos as you are about other peoples site and info. Thank you sir, you are a gentleman and a scholar.
im honestly so happy that this guy made it. what a humble guy
GUYS HE HAS A PORTFOLIO! The RoaringKitty Portfolio! It's in his previous videos. $GME $RFP $RRC $TSE
With the amount of research this guy has done it was only a matter of time until he made it big on any stock, even if it wasn't GME
I watched all 2 hours of this video. Did not regret it.
Who ever said you are lucky does not realize the amount of hardwork and passion you have. This is insane !
You can tell he's a good kid. Hopefully fame and money won't ruin his life.
The guy didn't sell at 50mil. I'm pretty sure money isn't what drives him so money won't control him. I fucking ❤️ this guy!!
This is so advanced my newbie brain can't keep up
I really appreciate his humility and knowledge, thanks Roaring Kitty :)
Hey DFV, thank you for the content you made. I've learned more from your videos than any courses or whatnot, and coolest of all you were perpetually humble and open to critism. Thank you :)
The sheer number of hyperlinks and conditional formats made me feel sick thinking about how many times you had repeat and correct that. It gives me nightmares thinking about it. Its not surprising youre sick of them too. This is an amazing spreadsheet that wasnt built overnight. It could be improved but why bother when it works just fine.
Hi RK,
great use of data and I love the way you have structured the data.
2 questions: 1) May you consider doing a video in which you show a few basics on building such sheets? E.g. how you import Insider Trading information automatically, which data source for fundamentals and prices etc. you use etc.? 2) I saw how you use your spreadsheets to track your positions - how do you find new positions using your spreadsheets?
Thanks!
I don't even have a clue about how to work a spread sheet but the knowledge this guy rips in-between sessions of explaining his insane behavioral investing strategies is ... well... "GOLD".
Loved every minute of your video Keith. Tracking the insider buying is such a simple concept, and proved especially fruitful in a correcting market. I checked every ticker in the "Roaring Kitty Portfolio" and many of them have performed well since the 52 week lows in March 2020. Congrats on each of these positions, as well as GME. I look forward to watching the next Live stream!
If you ever decide to take some of your profits and design some type of analysis software for the individual investor, I will be your 1st customer. 🤣 Unreal. I get the name now. Keep crushing.
Ho LEE shiet, i watched it all and gotta say, this guy has everything in his head, so much information, knowledge, damn, wish i was as smart as him :D
It feels like my head is going to explode. I love your system, great job!
That insider buying filter on the spreadsheet in sick man! I need to build this out ASAP! Cheers and Merry Christmas!
RK, can you do a video on more background on yourself? When did you start investing? Has this always been your full time work?
This would be highly appreciated!
Nice try, SEC. get out of here with that bs
He is a CFA, he knows his shit..google.
As a college student, you are my inspiration in finance! Thank you for the humble and insightful videos. You're changing the game for us regular investors!
Hey. Im 18 and trying to learn this stuff. If you want to learn together lmk
@@coronaviruscid8202 what you into?
LEGEND. Loving these vids as well looking forward to going through all of them.
I turned on notifications in my settings just for you. Something I never thought I would do. U the best
Eternally the GOAT, these videos are so important
🔐🔑👀
How can you be so generous to expose them all
I’m very thankful though
this has been a major major help. thank you for EVERYTHING sir!
I found the real deepFvalue. It's the incredible insight and info in these early videos. Thank you!
I’m so happy we are all coming together and learning to co exist. This has been beautiful to be apart of. Thank you Mr Gil for all your hard work and dedication and really liking this stock. (HOLDING)
I completely agree, this event has been the most cheerful thing since before the pandemic but also, it has given me hope that the negativity in our country could take a back seat to something feel good like this.
Remember that any negative response from people on your last video are only negative because its the only one they've watched and likely expected this kind of video. You haven't changed other than what is possible for you to do online and neither did the thesis or the company change.
WE LIKE THE STOCK! And after it tanked i just bough more. 😁 best regards from the Netherlands Roaring Kitty
WE LIKE THE STOCK!
Yeah anyone that has something negative to say literally never really watched him or learned from him. Just jumping o the bandwagon and now mad cause they think it’s over lol
It’s ONLY just begun!!!!
This is awesome, man. I'd love to have these RK spreadsheets but you deserve to be the only ones with them! Man I would love to know as much as you. Watching all your vids and I'll continue to learn. Thank you so much, RK!!
Man if you started a hedge fund I would apply solely due to your genuine nature. I feel like he’s the boss that can talk to you about your losing positions in a way that inspires you, not rip you apart. Won’t get upset that you need to take care of a family member, or at much of anything, but you wouldn’t dare let him down out of respect.
Subbed for sure. Thanks for saving me $ on buying excel!
"We'll turn this into a marvel movie right", little did he know..
dang this guy would be an awesome product reviewer. Man tries to make everything frictionless and easy.
You make me feel very comfortable about how nerdy and lazy I am. You are an absolute legend in value trading. Historic. Some look for growth, some want a store of value, some maximize dividends with growth and compound...but value, man? Deep value? So interesting to see, and it's amazingly educational.
Thanks for the explanation! Soooo much information to take in. I personally will have to watch it again!
I'm just thrown off by the fact that he's rocking these in sheets
We like the SPREADSHEETS 🦍
Watched the whole thing. You are really entertaining because of your enthusiasm!
I watched this video. Thanks for making this. Its like you made your own stock screening software suite. Awesome work. Thanks for sharing
I watched this entire video
Sorting by insider buying is not just cool, it's fucking sick! This is so killer...... Thanks
Did you catch which site is for canadian insider buying?
I hope he doesn't stop posting videos like those. A wealth of information.
I admire you. I wish I could ctrl+c / ctrl+p your logic to my brain......You're a legend dfv, wish you the best!