Hi Kuldeep & Sandeep,
Visit and download the utility at
http://www.traderji.com/software/7890-stock-charts-yahoo-site-excel.html prepared by me. It helps you to get company news (incl. Bonus news, record date), price, charts etc. from BSE site with ease. I am also trying to make NSE site details to be available in same workbook. Although you can get all these details by directly visiting the NSE & BSE sites, the utility will help you to get it faster and will memorise it for the session, so that you can revisit if required.
Regards
Chachi