ExcelBanter - View Single Post

Don Guillett

goto

and look in the files section. There are several free files.
I have a couple of free files under author donalb36

GetYahooMultipleHistoryALL_P

However, it uses USD

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pradip Jain" wrote in message
...
please see the following link

http://www.nseindia.com/content/equi...iphistdata.htm

the site generates historical data of price and volume based on various
inputs as follows: scrip code, start date and end date. suppose we choose
scrip code as ACC and start date as Jan 1, 2008 and end date as April 1,
2008. the site generates a file whose name is based on the inputs and can
be
downloaded from the following url:

http://www.nseindia.com/content/equi...2008ACCEQN.csv

It is easy to write a code to generate the URL for a particular stock and
period for which data is required. for example i want to download ACC data
from Jan 1 2008 to March 1, 2008 the URL will be as under:

http://www.nseindia.com/content/equi...2008ACCEQN.csv

but the problem is if we try to staight away download this file, it is not
found on the server. reason is simple, the site generates the file based
on
the query run. thus when "get results" button is pressed, the file is
generated. thereafter the above link will work and i can download the
required file.

now my query is can we write code to make the website run query based on
inputs entered in excel sheet and generate the file on the server and then
download the same