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
Subscribe to our News letters to get our regular updates to your email inbox...
9 comments:
ts = time start... if you cut the last 4 digits...the rest gives the start day in seconds
plz tell which format to use in excel to view correect date and time ,how to format it to use in metastock.
@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
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
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
FYI---This will only go back a MAX of 10 days
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!
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/
I have read your blog its very attractive and impressive. I like it your blog.
Nifty Trading
Post a Comment