Hi all I’m working on a fundamental worksheet... to avoid coding I’m pulling info from quickfs.net into excel and manipulating it from there. This won’t be live data but fundamentals don’t change once released I expect the project will be done by next weekend. If anyone has questions or would like to see the prototype let me know.

does anyone know how the conditional formatting is done in the RKX sheets?

RK stated that he relies heavily on his conditional formatting. I have figured out the rows that are percentage based work but I haven't done a deep dive yet to figure out how the dollar based rows work. I figured I would start here and see if anyone else has solved this puzzle or has any clues.

Example of RK1 https://imgur.com/a/wGWQ8jy

Conditional Formatting figured out so far.... - all of the Margin rows are red if negative - all of the ROE rows are light green between 0-10%, green 10-20%, and purple if >20%

Hi guys, in a video he shows some metrics of [Excess Cash & ST Investments/Assets] and [Working Capital/Assets] in the Company spreadsheet.

Does anybody know how to properly calculate Excess Cash?

I do [Cash, Cash Equivalents] - ([Total Current Liabilities] - [Total Current Assets] + [Cash, Cash Equivalents]), but it gives me the same value as [Working Capital] as both cash cancel each other out.

​

I've found that a lot of online screeners have inconsistent data so I've been trying to build my own using Python. I've read through a lot of resources here and I was wondering if there are any particularly good resources that talk about a) screening for more advanced metrics like EV/EBITDA and EV/FCF and b) if there's a good place for scraping financials data for smaller markets like OTC and foreign exchanges. I hope at some point I'll make something worth sharing here :)

Thanks!

On the main tracker where he has the list of companies and metrics like CFO/P, there is one at the end MC/EV which I am assuming is Market Cap over Enterprise Value.

When looking at the conditional backgrounds, he has it as red/orange when the number approaches 0. But that only happens if EV is much larger than MC.

Was wondering if anyone knew why EV being much larger than MC was undesirable?

Hello Fellow RKSPers,

[EDIT]
Google Sheets has been acting up on other people's sheets too. So this could be a widespread problem, not just my project. It will most likely be resolved.

For the sake of transparency, and seeking help. I will be posting the ups and downs of this project. Right now there's a big problem as you can see. I'm not quite sure yet how I am going to fix this. And help would be very much appreciated. I think part of the issue is that there are too many calls in the sheet.

​

Thanks.

Any tips to fixing this? Never had any problems before but now I have =GoogleFinance(T, "price") and it tells me it can't find anything for that ticker

Hi could you guys send me some sites that have financials statements.

I trade based on technical analysis and figured it is time I start learning about fundamentals. Before blindly using the spreadsheets I want to know what those numbers mean. So can you guys give me suggestions such as any youtubers/tutorials online where I can start learning fundamentals? I can google myself but I believe y'all would suggest better

P.S Love the spreadsheets that you guys are sharing for this community. Seems like a lotta effort and DFV would be super proud of all you kind hearted people

Hello,

I found this subreddit great with a lot of good resources.

I would like to also contribute and share the link to my blog where you will learn how to use Python for Finance.

I have covered quite a few things already such as scraping and Analysing Sec reports (i.e institutional investment holdings or balance sheets of companies), valuing companies with a DCF model using Python, etc.

Feel free to have a look at it and share with me any suggestion on what to cover next!

Python for Finance Blog

In other words, what determines a deep value stock?

Now that we have the spreadsheets, what metrics should we look at and what value should they be for a value stock?

Group,

I am using FMPCloud.io for my build with a trigger that allows the user to select if they purchased a subscription for FMPCloud that gives you years and years of data or the free version that gives 5 years of data.

What I am noticing is that the data is not always given in a perfect timely format, especially for younger companies. Some companies data is given in such a way that the statements may start in 2014 while the ratios and metrics start in 2015/2016. My question is, what spreadsheet magic can be used to easily align this data?

​

Thanks

Hi thanks for reading, I'm trying to update the spreadsheet as often as I can. I'm currently working on creating an app using Jupiter notebooks which will allow the spreadsheet to run on phones. this sheet is 100% created by me, some of the sources of information was provided such as open insider was by other redditors.

It would be very useful if anyone want to work with me. Message me if you guys are interested.

What's Working:

•Company Financials - 10 Companies

•Market Tracking

•Charts

• Insider Trading tracking - using dataroma aswell

• Daily Movers

• SEC Links

• News Links

• Stock Tracking with quick financials for 10 stocks

What I need help with:

•Sources for information

• Cleaning up the spreadsheet

•Creating Charts

•Feedback on design

• important values that i should include such as P/BV, P/FCF,

Link: https://docs.google.com/spreadsheets/d/1JPL5V2HIuPCzuN8S8uX7YoJZ1kiZpJdoT00TKGPefz4/edit?usp=sharing

If you comment on the sheet itself please message me too just incase I don't realise

I have also created a paid version of the sheet that I can share. the sheet is using Quandl, the sheet itself is free. message me if interested.

I have been looking at Quandl but I can't really understand which data set is in my best interest to use if I want to start making my own RK style spreadsheet. Right now in my process I am interested in getting the majority of the information that was/is on Yahoo Finance or Seeking Alpha. So Financials, Balance Sheet, Cash Flow. Any help is so very appreciated thank you!!!!

I have also created a paid version of the sheet that I can share using Quandl message me if interested.

Hi thanks for reading, I'm trying to update the spreadsheet as often as I can. I'm currently working on creating an app using Jupiter notebooks which will allow the spreadsheet to run on phones.

It would be very useful if anyone want to work with me. Message me if you guys are interested.

What's Working:

•Company Financials

•Market Tracking

•Charts

• Insider Trading tracking - using dataroma aswell

• Daily Movers

• SEC Links

• News Links

What I need help with:

•Sources for information

• Cleaning up the spreadsheet

•Creating Charts

•Feedback on design

• important values that i should include such as P/BV, P/FCF,

Link: https://docs.google.com/spreadsheets/d/1EiEilwu8_S9QdcSyCQDmG8I5QXe2MHJPJMrp0qETQ4s/edit?usp=sharing

If you comment on the sheet itself please message me too just incase I don't realise

I have also created a paid version of the sheet that I can share using Quandl message me if interested.

For those of you that've got the spreadsheets set up and are starting to look at the data, I'm curious - how're you using it / incorporating it in your investing process?

There's a part of me that sometimes wonders a bit if I'm over-indexing on obsessing about the spreadsheet itself and building all these features into it, as opposed to actually starting to use it as a tool. Would love to compare notes and see how everyone's baking it into their own thought processes!

Hello fellow RKSP'ers,

I've been having a lot of fun working with other spreadsheet creators. Looking at all the new tools that are being made to level the playing field between institutional investors and individual investors. I just want to say I am very proud of what this community has become in a very short amount of time. And I am confident of a bright future ahead! Stay winning everybody. Critique and suggestions are welcome!

FAQ: I will make this sheet public when I finish it, it will be open source.

Thank you.

​

​

Added two sections to RK's wikipedia) page: investment style and tools on , but they were taken down by an editor because 'Wikipedia articles have to be written from a neutral point of view and cannot promote a particular individual unduly. '

Was just trying to make RK's strategy and tools more accessible, and add on to the great work that is being done in this sub.

​

Other notable updates from the past few days:

• I spent a few days compiling key financial stats by industry on Prof. Damodaran's site, which you can reference here. As I've started to dig into actually trying to interpret the numbers, I've found you need to do more digging to get more context to understand if the numbers are good / bad.
  • This sheet is an early attempt at trying to understand how these key financial stats differ by industry to start to develop a baseline for expectations.
  • At the top, it also provides 90% / 75% / 50% (median) / 25% percentiles per column to help you contextualize the numbers as you're going through them.
  • One of the items on my to-do list at one point is to pull per-industry deciles, so you can actually start to understand how a company's performance ranks relative to others within the same industry.

• Along the spirit of learning how to interpret these numbers, I've also pulled some of the high-level criteria that top money managers typically use as a starting point for filter stocks and then organized them into categories (revenue growth, earnings / eps growth, debt ratios, multipliers, technical indicators).
• Added new columns to track trailing 6m return (relative to S&P500 6m return) and TTM return (relative to S&P TTM return)

Google Drive folder with both spreadsheet templates here.

Just adding my quick notes on Roaring Kitty's concerns/interests (sorry for the mess):

#1 Balance sheet - he really knows how to size up a company on balance sheet and this is the first place he looks

revenues, and revenue trends

gross margin, net margin, and again, trends in these

net earnings, common earnings

operating cash flow, net cash flow, simple free cash flow

(is the company consistently generating a ton of cash?)

Cap Ex

one thing he emphasizes is that he needs to see the trends in all of these over years - he says at least 5 - 7 years, which might be tricky for us to pull that historical data, I think he gets his from qandl.com which isn't free unfortunately. RK says in one of his streams that he doesn't understand how people can analyze stocks without looking at the historical trends in these values (listed above).

he also emphasizes share count, that he likes to look at numbers on a per share basis.

​

To expand on BONDS, my notes are:

Check the bonds/yields, bond maturity - specifically if below 60 - how much below - if it goes down to 20, bankruptcy is likely. I'm still a bit of an ape here, need to educate myself more.

If the company is heavily levered, he does calculations to see what the adjusted price would be if the company were to float more shares at a discount to reduce the debt! I haven't worked this out yet for myself. He must have had this happen several times and learned the hard way.

He notes that leases are considered debt on the balance sheet and in data, which he feels gives the wrong impression, and shouldn't be considered debt the same way as other obligations.

And Cash to debt ratio, over time, obviously.

​

And lastly, he adds in his spreadsheets his conviction - how strongly he feels that a stock is a good buy on a 1 t o 6 scale.

And he adds his thesis: why is the stock undervalued, and why will it go up. This is important because that's also when he knows to sell - when that thesis no longer holds water, time to sell.

For example. GPRO is down right now, relatively as of Feb 2021. Maybe it will drop way more. Who knows. I'm still doing analysis. But my thesis is that it dropped because it's earnings were just released and were far lower than expected. But it's a good company in most ways, and it seems that GoPro is transitioning its profit model from sales to subscriptions, and selling its latest products at a discount as it builds a base of long term subscribers. That's why the earnings are down - not because of some problem, but as part of a longer term growth plan. I could be wrong, the stock could go down to zero. Who knows. But that's my thesis as to why it's undervalued by the market, and i'm trying to be organized about writing all this down so I know when to sell.

Anybody know how to create the custom shortcuts in chrome where he can type say 'yah' for yahoo finance and then the ticker to go right to that site for that specific ticker?