Waise way back, I did promote the site here… http://www.poweryourinvestment.com/forum/fundamentals/www-screener-545.html
So if you have give out commissions… they are welcome 
Hi Anuprem,
I rechecked the figures for the company. The Screener figures are correct.
The difference you see is because other websites might be showing the PE based on Standalone basis. I also checked the ratios on Google Finance, Yahoo Finance and Reuters. All correctly show the PE of 8.
Google Finance:https://www.google.com/finance?q=NSE%3ATATAMOTORS Link: https://www.google.com/finance?q=NSE%3ATATAMOTORS
Yahoo Finance:http://in.finance.yahoo.com/q?s=TATAMOTORS.BO&ql=1 Link: http://in.finance.yahoo.com/q?s=TATAMOTORS.BO&ql=1
Do leave us a feedback (at http://www.screener.in/feedback/ ) if you have any doubts or need anyclarification. We would love to help and fix the problem if any.
Regards,
Pratyush
Hi Krishna, thanks a lot for spreading the word.
The peer comparison is currently shown in the Screener based on trailing 12 months profit after tax. It comes handy as a quick glance at the market cap column shows the undervalues stocks in the sector.
I will try to include an option to increase the number of peers. In the meantime, you can use the search at the top to see all the companies in particular sector. In the top search, type the sector name and select the last option of full search. Example, for Pharmaceutical companies:http://www.screener.in/company/?q=Pharmaceutical Link: http://www.screener.in/company/?q=Pharmaceutical
Hope that helps,
Pratyush
Thanks Pratyush… You guys are great thumbsup
Regards,
Krishna.
Hi Pratyush,
Thanks for the clarification. I admit I should have double checked the ratio’s from various sources before making the comment. Will take of this going forward.
I had commented in a harsh manner as I could not find a single match with moneycontrol figure and doubted the way the calculation is done by the screener. My intention was not to hurt valuepickr users feelings towards screener.
My intended effort is to improve the accuracy of the system. Since the screener is doing lot of ratio calculation I felt there might be some bug.
I am testing the figures of screener with my own calculations and hence forth would directly clarify with Pratyush/Ayush going forward.
)–Anuprem
Yahoo Finance:http://in.finance.yahoo.com/q?s=TATAMOTORS.BO&ql=1 Link: http://in.finance.yahoo.com/q?s=TATAMOTORS.BO&ql=1
**We all at Valuepickr respect the hardwork and good gesture of Ayush & Pratyush and such harsh comments in public domain was really hurting(for they are not charging anything for the use of screener.in). Hope you respect the same and oblidge. Thanks Ayush/Pratyush for taking it gamely. Let the better sense prevails. **
Would like to add one suggestion for the developers…add how much ever screens and tabs and features you want, but please keep the interface clean
Remember, why people moved from Orkut to Facebook, Orkut was cluttered with ads and Facebook was clean (then, now it too is cluttered)
Remember, why people prefer google over yahoo and msn…Google provides you with a very clean interface unlike other sites.
I got attrached to Screener for the same…it displayed the information in a very clean spacious manner not in a cluttered manner…i did’nt have to search for information i needed
Thanks.
I am not sure why hasn’t anyone brought this question up till now, but some of the balance sheets items have been ignored/removed which makes the cross ratios like ROCE,ROA artificially high (not completely sure but I think provisions and other CA/CL have been ignored)
Is there any specific reason for doing the same?
www.screener.in is a boon for value investors, creating a watchlist help one keeping updates of different developements of the watchlist companies. Redeveloping own screeners and also subscribing to the other screeners designed by others help one to keep track of different potential investment opportunities…Thankx dalaal street blog for their innovative yet helpful innovation
Ayush,Pratyush,
I have been using the screener.in for quite some time now. I think since it came out. I find it very useful in my overall research process. I use it to zero in on small manageable set of companies for further research and also to get a snapshot of particular chosen company. This one page snapshot is great. I have option to customize the columns for my needs and I get most of what I need. I am glad here I can get Pitroski score for the stocks I am looking at. This screener allows me to do the first round of research before I head down to annual reports for more digging.
I have found information like promoter holding (chart) over the years very valuable. Couple of times it caught my attention and let me do more research than i would haveotherwisedone looking at the other numbers.
Overall great screener in my experience. I have used other screeners too and still come to screener.in regularly.
One suggestion I would like to make …is it possible to show FCF for each year in the cash flow table at the end? That will allow us to see how FCF is changing over the years. It will also help us quickly compute FCF for say last 5 years and get the normalized figure etc. If you can show couple of other data in cashflow table then that would be even better
a. investment section- investment in PP&E. i.e. CAPEX.
b. In finance part- new debt issued or paid year wise. Also new stocks issued or bought back, if any, each year.
Good job and Thanks a lot for very good screener.
1 Like
Thanks Donald. This is a great feature. Do you mind sharing your personalised excel sheet?Am sure lot of learning will be there in that sheet as well.
Screener is an excellent tool. Thanks Donald
Does anyone know how to refer to operation cash flow for a particular year. For e.g if i want to refer to operating cash flow for FY10 which variable do i use?
unable to locate the upload feature. Can someone point me to it? Thanks.
Can Screener incorporate qualitative factors such as market share, new product launch, scope of the market for certain products ?
Re: Export to Excel facility
Can someone help to sort this out.
I downloaded the Ambika Cotton Mills spreadsheet from this site and tried to upload it onto the Export to Excel facility (via screener/excel).
When trying it with one of my watchlist stocks (eg ajanta pharma) to get an analysis as per the Ambika format I get an error which says 'file conversiion not done’
Thereafter even after using the reset facility I can download the original data which I could do earlier.
I am using Windows XP which converts any xlsx file whilst uploading but no results are forthcoming
Please help.
Thnx for screener…Been a blessing!!
1 Like
I have uploaded the Ambika file, downloaded a file from my watchlist and Excel opens. Then, I still keep getting an error message saying “convertor failed to open file”.
Hi,
I am a new member on this forum and to investing in general. I tried screener and found it to be an amazing tool. The export to excel and the ability to customise the spreadsheet and uploading it as a template is like a dream come true. I just have one question. Is there any way to calculate the free cash flow from the available dataset?
Search for “Calculating Free Cash Flow” there’s a discussion on that with pointers.
Most questions that occur to Learners - might have been addressed as we learnt a few tricks - use the excellent search functionality
1 Like