Importing data from a website using vba

Hi Folks,

Need help with a vba code for importing data from "http://www.bseindia.com/" website.

I was trying to import data from the financials of the companies listed on the site using their "scrip codes".

for example, Importing data for "Infosys Ltd." whose scrip code 500209 sitting at the link "http://www.bseindia.com/corporates/results.aspx?Code=500209&Company=INFOSYS LTD.&qtr=80.00&RType=c"

I struggle to reading html/java written in the source code of the webpage...would appreciate if anyone can help me out with a solution to this.

Thanks in advance,

Amber

The easiest way I have found is to record a macro, then use the import data from web tool. Then you can point it (assuming the data is in tabular form) to exactly what you want. You can then tinker around with the recorded code to remove the 'fat'.

I was trying to extract the table from "http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm" using the suggested method, however the same isn't working in this case.

How can the table be extracted from the webpage given above?

Please advice.

Can somebody help me out with solution for this please???...I am finding it difficult to read the source code of this webpage as I am new to html.

this is urgent.

Thanks in advance.

Sorry, as the data you want from that website isn't tabulated it won't be possible to use the method I gave above. Without a knowledge of the sourcecode of the website, it will not be possible to retrieve data from it.

Sorry!

Did the solution work for the initial website you requested for?

yes it did...thanks for that.

Can you suggest me a wayout in this case.

I'm afraid without you picking up enough HTML (& possibly java) to understand the code of the website, there won't be a way to automate. You could of course use the 'download CSV' option on the website, if you just need the information periodically?

@Pike, very nice!

Thanks for the reply pike.

Can you suggest a way for becoming proficient in reading the source code and the way it can be used for automation using vba...any book (in laguauge that can be understood by people who are new to html/java) or article...please advice.

Thanks pike

@Pike tried to go through the suggested material on html and identify "LTP" & "Symbol" columns in the source code of "http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm" webpage.

Its seemingly difficult for me to find out way to extract the columns or table placed in the link given above.

Can you please help me out?