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