EOD Price for Selected scripts in excel sheet

Hi

I keep track of about 100 Scripts.
I want to import the EOD prices for my selected 100 companies in my excel sheet every evening from BSE/NSE.
I shall be grateful if the members can recommend a method to do the same
I am presently doing it using the Web data query function of Excel and then giving the link to the yahoo finance site but for the past few days i am getting an error message saying that it is an invalid web query for most of the scripts.
I do now want any fancy analysis or historical data, just plain simple closing prices for my scripts.
I am attaching my present data sheet whih i am using to update the prices for reference
Thanks

I have got the solution

Cheers

please share the solution

Hi

In the cell that you want the prices
Go import external data-web query and give the following query

http://download.finance.yahoo.com/d/quotes.csv?s=i-flex.ns&f=l1

Change the name of the script for every script u want in the new cell

The above example is for I-flex

The script code has to be as per yahoo code

Bye