Intraday data download from yahoo?

D_arjun · #1 21st June 2006, 06:21 PM

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

Thanks

cooltetra · #2 22nd June 2006, 01:44 AM

Quote:

Originally Posted by D_arjun

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.

D_arjun · #3 23rd June 2006, 08:51 PM

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

pkjha30 · #4 23rd June 2006, 09:21 PM

Quote:

Originally Posted by D_arjun

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

cooltetra · #5 24th June 2006, 12:26 AM

Quote:

Originally Posted by D_arjun

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 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.

murthymsr · #6 24th June 2006, 07:03 PM

Quote:

Originally Posted by cooltetra

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

Similar Threads for: Intraday data download from yahoo?
Thread	Thread Starter	Forum	Replies	Last Post
Yahoo Data Download OK	shrees	Data Feeds	13	8th April 2008 11:33 AM
download historical data for bse/nse	hardevsokhi	Data Feeds	0	3rd May 2006 05:54 AM
data download	a_n_i_l	Software	9	25th May 2005 09:17 AM

The Following User Says Thank You to murthymsr For This Useful Post:
gemsuraj (20th October 2009)