Free Intraday Data From Google Finance

Wednesday, February 24, 2010


How to free download last one month intraday data from Google finance?
 In Google finance, we can view even the intra-day stock chart for last one month may be even more for 1 minute time interval. As we increase the time interval the view span can be increased significantly. But there is no link to download this data directly.  I dig into Google finance and find out something very interesting. Whatever the chart you can see for an individual symbol, you can  download it also but with a little pain than yahoo finance  For intraday or 1min, 5 min, 30 min or 1 hr interval there is no way we can download it from yahoo finance. So here comes the Google finance to help us out.
Copy the link below and paste into the browser
q= stock symbol on Google finance
x= exchange symbol
i= interval (here 1=120 means 120 sec (2 minute interval))
p= no of period
f= parameters (day, close, open, high and low)
df= difference (cpct is may be in % change , not sure)
auto =1, and ts value I don’t know.
Here I have chosen period p=1000d to get the maximum data possible. you can choose your own set of value depending upon your need.
After getting the data copy and paste the data into a spreadsheet and format little bit to make it usable.
Though I have found it works pretty well for me. IF it has any error then any comment and suggestion is invited to improve it.  Any way it is free so giving a try is worthwhile since you have nothing to lose. I hope you will like it. Enjoy the free data mining

9 comments:

Anonymous,  September 12, 2010 at 2:16 AM  

ts = time start... if you cut the last 4 digits...the rest gives the start day in seconds

viresh December 4, 2011 at 11:24 AM  

plz tell which format to use in excel to view correect date and time ,how to format it to use in metastock.

Unknown December 21, 2011 at 8:24 AM  

@viresh
The data which come out is in XML format. It is still in unusable format. I tried to code it to make usable but failed.
For intraday data You can use data downloader from Volumedigger.com ( but it is not live , you will get the data @ EOD)
Hope it helps

viresh December 21, 2011 at 12:24 PM  

thanks a lot for your kind reply, i too tried ,but could not,with trade tiger terminal iget tick data for 30 days which is more helpful just now,more managable data itis..-vireshanklesaria@gmail.com

Azouz April 24, 2012 at 4:22 PM  

You may also get data for free from other providers, here is a list:

http://www.quantshare.com/sa-426-6-ways-to-download-free-intraday-and-tick-data-for-the-us-stock-market

William May 21, 2012 at 3:57 AM  

FYI---This will only go back a MAX of 10 days

Unknown February 13, 2013 at 12:50 AM  

To make the data usable all you have to do is select the column which the data is in, go to the data tab, click text to columns, select delimited, then next, then select commas. This works for excel 2010 not sure about the other versions. Hope this helps!

SimCon July 10, 2014 at 9:43 PM  

There's an Excel spreadsheet (with open VBA) to download intraday backfill from Google at the link below.

http://investexcel.net/free-intraday-stock-data-excel/

seema November 8, 2016 at 5:25 PM  

I have read your blog its very attractive and impressive. I like it your blog.



Nifty Trading

Post a Comment

Back to TOP