Thanks for the question. It's not a bug. In this model, we include the trailing twelve-month numbers as part of the score, but only when the TTM is different from the last fiscal year. Since MSFT's fiscal year ends June 30th, the last fiscal year is the same as the TTM, so we remove the TTM scores from the numerator and the denominator.
I'd be curious to hear how useful this would be to people.
This limitation is enforced by our data licensing contracts. Our data providers need to limit this to help prevent people from downloading their full databases. If we were to increase the limit, we would have to get licensed for it, which would be substantially more expensive, and we'd have to pass this cost on to you guys. It would also mean we couldn't grandfather in older (usually cheaper) plans anymore, and we'd have to charge lifetime members again.
I'm not opposed to it -- this site exists for you guys! -- but a lot of people would really have to want it to make it feasible.
In general, we tried to build our screener and other tools so that you wouldn't have to download the Excel reports for quite so many companies. I'd be happy to talk about how we could make it less necessary to have to pull data down for so many tickers.
I'll leave this as "under review" so other insiders can weigh in.
We do update portfolios when a stock split happens, but we don't alert on it. It wouldn't be that hard to add this one specific alert, but to do it right (i.e., to add a setting section that allows you to configure/enable different types of alerts) would be a good bit more work. We polled Insiders earlier this year, and this wasn't a high priority for them. But I'm open to it, if other people would find this really valuable.
Yes. Stock based compensation is on the cash flow statement (called "Employee Compensation" on ours). You can press the "%" button at the top to show it as a percent of Net Income. It will also show it in pure USD.
Hi David, this is something we can probably do. We don't currently calculate a per-company WACC, as doing this from standardized financials requires a lot of assumptions (i.e., using book value of debt and estimating an average cost of debt using the interest expense). But once we add this, it shouldn't be hard to calculate EVA and related metrics.
Hi Jeff, thanks for the kick in the butt. We packaged these updates with another data update that has turned out to be a lot more complicated than we initially thought. So, I just separated them out and pushed them live. It may take 24 hours for the cache to refresh, but by tomorrow you should be seeing many more formulas in the key stats hover-overs.
That's strange. A couple suggestions you can try:
-When you start typing a symbol, wait for the auto-search to bring up the symbol and select that
-Switch to Firefox, Chrome, or Safari if you're using Internet Explorer
-Log out and log back in and see if you can enter a symbol
-Hard refresh the page (ctrl + F5)
-Clear your browser's cache
Also, next time, you can click the "HELP & SUPPORT" menu from within the app, and select "Request Help" to submit a ticket to us directly. This is more of a forum for feedback about the product, which isn't always monitored as quickly by customer service.
Hi Brian. This idea has been batted around since I've worked here. But I think the problem is that the OSV stock analyzer use some macros that are not supported in Google Sheets.
We're definitely on board, when the time comes that Google should support this.
Take a look at Net Current Asset Value (NCAV) and Price to NCAV in the screener. NCAV is almost the same as Net Cash by your definition, it just includes all current assets, not just cash & equivalents. When Price to NCAV per share is less than 1, it's trading at a discount.
I find NCAV a much more useful metric than net cash per share, and there's more research backing up Ben Graham's use of it. Does this help you, or are you a big fan of net cash? If so, why?
Customer support service by UserEcho