May be I am missing something or the question has already been asked and clarified in some forum - in which case apologies for asking it again. But could someone explain why this mismatch?
@ayushmit@pratyushmittal Hi, Thanks a lot for providing such a valuable and efficient tool to make our lives easier. . I have a question. After downloading excel, I am building a framework to monitor stock performance. I wanted to calculate CAPEX, however, the information captured is at cash flow from Investment level. I am a novice to financial calculations and not sure if CAPEX can be derived from available numbers in P&L,Balance sheet and cash flow. Please guide how to derive CAPEX information
About the ‘Set alert’ feature that can be used with screens. Reuse the existing screens. When using a screen, sort based on various columns to see which company turns up often.
Importance of pros/cons section. Dig deeper into the cons highlighted.
To pay attention to the credit rating reports.
To use the excel feature effectively one should upload a customized excel sheet. I have realized that doing this would boost productivity.
Stop being lazy and turn as many rocks as possible (in Peter Lynch parlance).
One other thing is to report bugs on the Github page.
In the Pros section, Screener computes the “Market value of investments Rs.665.45 Cr. is more than the Market Cap Rs.218.08 Cr.” Is this a snapshot view or computed periodically ? Kindly elaborate how this figure is arrived at ?
AR 16 mentions market value of Consolidated Non Current investments at 687.50 Cr (Page 76/108).
I was looking at a stock called https://www.screener.in/company/501423/- Shaily Engineering Plastics. I was looking at ROIC of 22.33% for the stock. I couldn’t figure out how it was calculated. Its EBIT (TTM/2016) = 21.43+10.13 (PBT+iNTEREST) = 31.56 Cr. So Invested capital must be 31.56 Cr/ 22.33%. So answer is 141.33. As per 2016 results W.C. is 26.40 FC is 97.65 so Invested capital is 124.05 Cr. So what am I missing for the difference 17.28 Cr.
Looks like creating custom ratios is not supported anymore. The link mentioned in the blog (http://www.screener.in/create/ratio/) is broken. Can someone please
help me in creating a custom ratio?
When you run a screen or when viewing company peer comparison, you have the option to “Customize columns”. In the pop-up that follows, at the bottom, you get the option to “Create new ratio”.
Working Capital row is missing from the Data Sheet.
Also,some data corruption issue is happening(in Data Sheet) for some companies which does not have 10 year data(from FY07 to FY16).
For example, I customized(shared in VP) an excel using some company(TCPL) which has got 10 year data and uploaded that sheet.
But when I exported the data for Alembic Pharma, Data sheet is showing the sales details of FY07 to Mar-10 of TCPL company
Do anybody has used subscribed based service of Guru Focus (http://www.gurufocus.com/). It gives good database and fundamental analysis?
Before i pay subscription fees, I would like to know experience of member(s) who used this service.
. I have a question. After downloading excel, I am building a framework to monitor stock performance. I wanted to calculate CAPEX, however, the information captured is at cash flow from Investment level. I am a novice to financial calculations and not sure if CAPEX can be derived from available numbers in P&L,Balance sheet and cash flow. Please guide how to derive CAPEX information
