TLDR on those streams: it was Shkreli just opening excel spreadsheets and going super deep on analysis of corporate financials, in the most plain unemotional way possible. He even did fun exercises to show his viewers how he works things: the audience would vote for a random public company ticker that Shkreli never analyzed betore, and he would just spend the next few hours populating his excel spreadsheet from scratch and trying to make some conclusions. With the preference for picking companies that he actually knows absolutely nothing about in terms of their finances. Literally just gathering all relevant publicly available information and analyzing it, with lots of hard numbers and excel magic involved. No joking, no non-sequiters, no guests, just lazer-focused on financial analysis. Not going to lie, it blew my mind when i was first trying to follow along at the time.
If you aren’t into that type of a thing, i imagine it would be extremely boring to watch, as it was nothing like his “more known” livestreams focused on trolling and ragebaiting. It was just cold “thinking outloud and populating spreadsheets” type of content. The viewership numbers reflected that too, with the financial analysis streams having magnitudes less views (with most people not even knowing they existed, despite being posted on the same channel as his more popular and controversial streams).
The trolling is uninteresting except maybe the Wu Tang thing.
I'm only after pure Excel-fu here. It is actually weird for me that people use it to analyze stocks instead of Python but I probably don't know what I'm missing.
Edit: The first few minutes seem neat, I'm biting the bullet
While looking for it, I also re-discovered his chemistry lessons playlist[1]. Which i totally forgot about until now, but can recommend almost just as much to those interested in the topic. Just looking at the video titles, you can tell it is legit.
Personally, I am extremely thankful for those, as chemistry has been my own largest knowledge gap in terms of science fundamentals. At any point in HS or college where I had to pick more science classes, I always picked physics over chem, because I wasn’t really into chem at all back then (and maybe a bit self-conscious about my lack of pre-existing knowledge of it, as everyone at my college seemed to have taken AP Chem beforehand, which I didn’t).
0. https://youtube.com/playlist?list=PLJsVF3gZDcuTxcdH5FmQRTd6M...
1. https://youtube.com/playlist?list=PLJsVF3gZDcuQ_MijwAR113CdJ...
I find these types of analysis very helpful at work and building strong fundamentals has never left me regretting the time investment.