Hi All,
Everyone will not have time to analyze shares since there are many companies and we are not able to view data of all companies in a particular format where we can filter out the best ones as per our choice. Parameters are varying every trading day, every quarter and every year.
I have now consolidated all the necessary data in an excel sheet and any one who know little basics about the market can pick the right stocks by applying necessary filters.
Ex: with the data available you can add up June'09, Sep'09 and Dec'09 profit of a company and can compare with the Mar'09 year result. If the total of the 3 quarters are more than last year total then the company might post a better yearly figures, better dividend payment, etc.
Excel sheet contains information of about 2800 companies which contains basics like "Open Price", "Day High, "Day Low", "Close Price", "Last traded price", "Previous Close" and "Volume" for both NSE and BSE. Other information like "Market Capital", "PE (Price Earnings)", "Dividend" (percentage and dividend yield %), "EPS (Earnings per share)", "Face Value", "Book Value", "Industry PE", "52 week high", "52 week low", "Group" (does the company belongs to A,B, etc), "Debt", "Total Assert", "30 DMA", "50 DMA (Day Moving Average)", "150 DMA", "200 DMA", Quarterly data for max last 5 quarters ("Sales", "Net Profit", "EPS"), Yearly data for max last 5 years (05 to 09) ("Sales", "Net Profit", "EPS", "Reserves", "Face Value"), field which shows "YES/NO" (depending upon whether the total of the 3 quarters result (EPS) is more than the last year EPS) and the combined volume of NSE and BSE.
Suggestions are welcome.
I have attached a sample sheet prepared last week which has data for 1000 companies.
If this data interests you please contact me at "joseph.wesley@ gmail.com" for the excel sheet so that I can send Mar 19th data on Mar 20th night.
Regards,
Joseph.
No comments:
Post a Comment