get minute bar historical data from Google finance?

ManInMoon picture ManInMoon · Dec 17, 2013 · Viewed 24k times · Source

I can get daily data easily using this link:

https://www.google.com/finance/getprices?q=LHA&x=ETR&i=60&p=1d&f=d,c,h,l,o,v

But when I try to change "1d" to "1y" I still get 1 day's data.

I am trying to get 2 years' worth.

Is there a way to do this? yahoo or bing finance would be fine too.

Answer

Conor Svensson picture Conor Svensson · Aug 11, 2014

You need to use '1Y', not '1y' on your query to get a time period stretching back 1 year. However, you will also need to change the granularity of your query, as minute data is only available for the previous 5 days.

This query will provide you with minute data for the previous 5 days.

https://www.google.com/finance/getprices?q=LHA&x=ETR&i=60&p=5d&f=d,c,h,l,o,v

The following query will provide you with the last two years of prices at the close.

https://www.google.com/finance/getprices?q=LHA&x=ETR&i=86400&p=2Y&f=d,c,h,l,o,v