Sensex |
Thursday, March 18, 2010
Re: [sharetrading] request for kind guidance.
| ||||||
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!.
Happy Trading,
United we grow!!!
Re: [indianstockmarket] Weekly share data with 80+ fields in Excel sheet for 2800+ companies
[Attachment(s) from Joseph Wesley included below]
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.
-----------------------------------------------------
Blog & Register for free letter http://crnindia.blogspot.com/
[sharetrading] request for kind guidance.
| ||||||
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!.
**[investwise]** Heidelberg Cement-Investor Ignorance Cannot Continue For Too Long
Heidelberg Cement-Ignorance Cannot Be Bliss BSE 500292 Three years ago, Heidelberg of Germany, bought out the stake of SK Birla group in the erstwhile Mysore Cement. Through a capital infusion of roughly Rs 500 crore, Heidelberg was made debt free. Three years later, that is 2010, Heidelberg has returned to payment of full tax after recovering all accumulated losses and unabsorbed depreciation, and yet has Rs 490 crore of cash in hand. If this is not serious cash flow generation then what? Today, Heidelberg operates cement capacities of 3.01 mn tpa which the market is valuing at roughly USD 40 per tonne of installed capacity. Replacement cost for a new Cement plant is USD 100 per tonne. On this valuation benchmark alone Heidelberg stock should quote at 3 times today's price. More importantly, with Rs 490 crore in cash and zero debt any further proposed expansion will cost about half the amount that any other competitor will have to fork out. Additional 3 mn tpa of capacity will cost only Rs 1000 crore on a net basis, while in CY12 operating capacity would be rising to 6 mn tpa, and on existing margins after tax profits of Heidelberg would have risen to Rs 300 crore per annum or an EPS of Rs 13 per share. Heidelberg has aggressive growth and acquisition plans which include acquisitions of grinding capacities in the Western states, raising existing capacity to 6 mn tpa by 2012 March, and ultimately raising Cement capacity to 15 mn tpa by 2015. Thus, Heidelberg would have raised it's installed capacity to double by 2012 and then more than double over the next three years ie 2015. In all total manufacturing capacity would have risen 5 times in the next 5 years. Investors have long ignored the stock, but how long can a corporate with cash of Rs 490 crore on it's books and valuation at a mere $ 40 per tonne be ignored. If Heidelberg is not a growth stock, then what else is? BUY Safe Harbor Statement: Some forward looking statements on projections, estimates, expectations & outlook are included to enable a better comprehension of the Company prospects. Actual results may, however, differ materially from those stated on account of factors such as changes in government regulations, tax regimes, economic developments within India and the countries within which the Company conducts its business, exchange rate and interest rate movements, impact of competing products and their pricing, product demand and supply constraints. Nothing in this article is, or should be construed as, investment advice. |
http://in.groups.yahoo.com/group/investwise/
INVESTMENTS IN INDIA
We are low-risk, long-term investors.
Stocks, mutual funds and the entire investment gamut. Only financing/investment avenues in India will be discussed.
For any assistance, questions or improvement ideas, contact investwise-owner@yahoogroups.co.in
****************************************************************
NEW! ==== Check our LINKS and FILES sections for a world of information. REGULARLY UPDATED.
NEW! ==== Check "Tracklist" in Links and Files sections for Investment Ideas.
****************************************************************
Re: [sharetrading] ALKALI
Insider Trading
Date Acquirer/Seller Type Qty 04/03/10 YSR Krishna Rao S 4,000 04/03/10 YSR Krishna Rao S 4,000 03/02/10 YSR Krishna Rao S 5,000 03/02/10 YSR Krishna Rao S 5,000 11/01/10 Dr YVSS Murty S 18,000
Insider Trading
Date | Acquirer/Seller | Type | Qty |
04/03/10 | YSR Krishna Rao | S | 4,000 |
04/03/10 | YSR Krishna Rao | S | 4,000 |
03/02/10 | YSR Krishna Rao | S | 5,000 |
03/02/10 | YSR Krishna Rao | S | 5,000 |
11/01/10 | Dr YVSS Murty | S | 18,000 |
Chk out this scrip. Worth an exp
BV 63.IV 80+. Fut IV 160.
CMP 118. 52W low 98. Div 40PC even in last year.
Enter at ur own choice
Abe
--
Regards,
Chintan Patel
Happy Trading,
United we grow!!!
Bonus Issues, Stock Splits, Rights Issues, IPO Updates: Indian Stock Market Calendar - 19-March-2010 to 23-March-2010
Bonus Issues, Stock Splits, Rights Issues, IPO Updates: Indian Stock Market Calendar - 19-March-2010 to 23-March-2010 |
- Indian Stock Market Calendar - 19-March-2010 to 23-March-2010
- Record Date - Chromatic India Bonus Issue
- IPO - Shree Ganesh Jewellery House Limited
- IPO Listing - United Bank of India
- Well Pack Papers & Containers Bonus Shares Allotment
- Record date - Poly Medicure Bonus Issue
Indian Stock Market Calendar - 19-March-2010 to 23-March-2010 Posted: 18 Mar 2010 04:22 PM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL As you have been reading by now, this updates on stock market calendar is good source of information to know the board meetings for the purpose of EGMs, Bonus issue discussions, bonus share allocations and other company matter. Each day has been detailed with company name and [...] Read More... |
Record Date - Chromatic India Bonus Issue Posted: 18 Mar 2010 04:16 PM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL Chromatic India Ltd has informed the market that it has fixed record date for the proposed Bonus Issue , The company told it has fixed March 23, 2010 as the Record Date for for the proposed Bonus issue in the proportion of Five new fully paid equity [...] Read More... |
IPO - Shree Ganesh Jewellery House Limited Posted: 18 Mar 2010 04:02 PM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL Shree Ganesh Jewellery House Limited is entering in the capital markets with an initial public offering, IPO of 14,269,831 Equity Shares of Rs. 10 for cash, at a premium to be decided through a 100% Book Built Issue. Jewellery maker and exporter Shree Ganesh Jewellery House has set [...] Read More... |
IPO Listing - United Bank of India Posted: 18 Mar 2010 03:59 PM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL United Bank of India IPO (BSE Script Code: 533171) is listed on Thursday, March 18, 2010. Issue price of this IPO has been fixed at Rs 66/- per share. Shares of the state-run United Bank of India (UBI) debuted at Rs 77, a 16.66% premium over its [...] Read More... |
Well Pack Papers & Containers Bonus Shares Allotment Posted: 18 Mar 2010 03:48 PM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL Well Pack Papers & Containers board in its meeting on 18 March 2010 has allotted 3,50,26,650 equity shares as bonus shares in the proportion of 3 new fully paid up equity shares of Re. 1 each for every 4 equity shares as we discussed in the Well [...] Read More... |
Record date - Poly Medicure Bonus Issue Posted: 18 Mar 2010 11:45 AM PDT The password to see buy calls is: LIFEISCOLOURFUL The password to see buy calls is: LIFEISCOLOURFUL Poly Medicure has fixed 29 March 2010 as the record date for the purpose of issue of bonus shares to the members of the company in the ratio of 1:1. Poly Medicure's net profit jumped 587.7% to Rs 4.47 crore on 22.4% increase in net sales to Rs [...] Read More... |
You are subscribed to email updates from Stock Market India Bonus Issues, Stock Splits, Right Issues and Market News To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |