Dear all, I have built an Excel-based stock screener for Indian stocks. It gets data from Value Research and allows the user to screen capitalization-wise and sector-wise. I request forum members to evaluate the sheet and let me know how to improve it.
I have always wanted to build a stock screener and hence this sheet. I am well aware that they are pretty good online screeners available. My aim is to develop a simple screen which new stock investors can use to quickly eliminate duds.
This will work only on Windows Excel versions 2007 upwards. If you are on such a platform, then it could be a firewall issue (typically from workplaces). I just checked the sheet and it runs fine (as of now, until VR changes its layout!)
Though it is opening, I am not able search with other stocks , I tried Control print, Tatasteel,but it is not loading only it is showing Colgate Palmolive
No one makes money or become a good investor by using screeners. I tried screener.in so many times but I am not able to get a good/attractive investment anytime. The key to successful investing is keep your ears and eyes open and zero in on a stock. As far as possible, after this step, get all the data directly from the company/nse . Screeners are automated tools and they dont think. An investment is more to do with future than past. If you turn upside down 100 or more pebbles one can get/not get attractive investments.
For example, take the case of Navin Fluorine. How screeners would have helped in identifying the scrip.
May be I didnât put the question right.Here is what I wanted to achieveâŚ
Remove default filters like Altman Score,EV/EBITDA,Market Cap,Sector,etc (which are already there on your excel sheet) & list out all the 6000+ companies listed in BSE/NSE on to the excel sheet which matches a simple criteria like âroe > 20 & Debt/Equity < 2â.
If u donât mind please advise which TAB I should put these values inâŚ
The reason I am asking is because I see only 2457 companies listed by default on the list under tab âAll Data MarketCapâ. I guess I donât know how to use this wonderful tool properly
You can ignore the black buttons in the main page, head over to the data sheet. remove existing filter - look for the shape of the small grey square at the top. Then you can add your own filters. See the video here for a demo.
People dont make money of screeners because the screener has been made in a generic way. But if the screener was made so that it can be customized for each and every individual. It it was possible to quickly and efficiently search for companies. If extra information about the shortlisted companies was quickly available then I am sure a screener would help people make money. I was frustrated with the screeners available and ended up creating http://investr.co.in Please do try it and tell me if it helps you!
âŚ