I need to pull data from Moneycontrol.com with input in excel sheet. the data should be fetched with this input which is Stock name. E.g. if I need info on nestle then i would put stock code in the cell in excel and it should fetch all info from this page "http://www.moneycontrol.com/india/stockpricequote/foodprocessing/nestleindia/NI". can some one help me with this. (data from web query doesnt work)
Hello nitin.s@itm.edu,
Welcome to the Forum!
Which information you want and where should it go?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Yes, I agree with Leith... you didn't specify exactly what data you wanted, or how you wanted it presented.
If web query doesn't work, one solution is to simply parse the data yourself.
For example, the following small piece of code retrieves the live BSE and NSE prices that are listed on the page. A message box pops up, giving you the figures.
You can retrieve additional data on the page in a similar fashion.
Please Login or Register to view this content.
(I wish I had a few shares of that stock.)
12.jpg
Hi,
Thanx for the reply.
i have circled the items that are required from this page. I want to keep company name as input on excel to fetch these nos. on same or separate sheet. I hope i have specified properly this time. e.g. with input of company name = infosys- the nos. that i would need are - prev closing, today Closing, high, low price for BSE and nse in separate cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks