Intraday data download from yahoo?

Anybody know if intraday data from yahoo can be downloaded or not?
if yes, how can we do it? what's URL

Thanks

Hello D_arjun
I know two methods using which you can download data from yahoo.
You will need to pay Rs. 10,000,000 per method. I won't mind even dollars.
If you agree to it,read further...

Both of these uses excel to down load the data
1. The first of the method uses the querytables method. In this we try to get the CSV file from the webservice and then convert it into respective columns.
2. The second method uses webquery method. In this you set up a query to fetch data from a webpage.

Now, if thats confusing, and I know I sometime do confuse, I have attached an excel sheet with an examples of both.

But wait.....
Before you download, there is another Rs. 100,000....ok 10,000 Rs for the sheet.
Just kidding...

And, if this is not what you are looking for, I am sorry for wasting your time.

You may also like to look at a sample I have posted on this forum. coolworks-2.html
Best Regards
Coool.

Cooool

You are asking millions for a question and just saying sorry for wasting time????
I guess you need to compensate with equal money and i dont mind rupees
What i was asking was Intraday data. This excel provides me daily EOD data.

Anyway thanks for your reply

Hi Arjun

You can play with this url
http://in.finance.yahoo.com/d/quotes.csv?s=(write your symbols with more than one symbol added with plus sign like TATASTEEL.NS+TCS.NS)&f=sl1d1t1c1ohgv&e=.csv

The file will be downloaded as quotes.csv and you can append data by writing routine in vba. You can play with control codes in bold and see the output .
Also write a routine to download every five minutes.
Pankaj

Hi D_arjun

You should have used the sheet once or twice during market hours to see what you were getting. The idea was to point you towards a way.
What Pankaj ji has suggested is one of the methods that is demonstrated in the sheet.

Thanks for looking into the sheet.

Best Regards
Coool.

hi arjun,

$, Rs & humor apart, the sample sheet shows a way to get intraday data fom yahoo. if checked during market hours, it will get you the current price volume data. if you have a yahoo account & log-in to yahoo finance, you will get current data (updated at source at one minute intervals). so your data is to that extent up-to-date. if you are not loking for tick-wise data, this is a good technique of extracting data from yahoo site.

using this method, cooltetra has developed & made available a software available for free at the software section. this sw will retrieve yahoo quotes by this method along with a few other features/calculations.

you may find this software interesting. if so, you may use it & give your comments / suggestions / feature requests also if any.

all the best.
murthymsr