Import Data from web-sites

M

Mandeep Dhami

Hi,

Is it possible to import data into excel from web-site.
I refer to a web-site to get data and do some analysis. This is regarding
share market data. I have got the URL of the web site which is as follow:
http://www.nse-india.com/content/equities/eq_scriphistdata.htm
On the web-site we need to enter few details like scrip code, from and to
dates of the data and then click submit to get the data on the web site. This
data can also be downloaded is .csv format.

Let me know if some macro could be written to get this data from the
web-site. I know how to create a macro for doing some analysis.

Cheers,
Mandeep Dhami
 
D

Dallman Ross

Mandeep said:
Is it possible to import data into excel from

Data / Import External Data / Import Data and click on the
Internet globe in the menu bar to set up a new Web Query.

=dman=
 
J

JW

Try Data-->Import External Data-->New Web Query

Dallman said:
Data / Import External Data / Import Data and click on the
Internet globe in the menu bar to set up a new Web Query.

=dman=
 
M

Mandeep Dhami

Hi Dallman/JW,

Not able to import data the way you informed below. Can you have a look and
let me know how it can be done in the case of the web-site that I have sent.

Cheers,
Mandeep Dhami
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top