Help needed (creating VBA macro to retrieve stock info)

Hey venkat1926 I really appreciate you doing this for me this addressed exactly what I was looking for. Based on the macro that you provided me if I were to try and modify the code, would it be possible to retrieve information such as: Current price, Sector, Industry and Market Cap based on that macro. Sorry for asking all these questions fairly new to excel macro. For this project i'm basically try to run some analysis on stocks that my system recommends (i.e the email data i receive). Therefore on a nightly basis I receive the emails and then input the stock info into the excel spreadsheet. My goal is to utilize excel to see if the recommendations are working out the way they are suppose to, that's why i need to retrieve stock data from the net. Hopefully this info is more helpful, do you have skype by chance, i would be able to better communicate my goal via skype. Thanks for all your help