Google Trends; Automated download; Strange result

Hi,

please copy this link into your browsers address bar: http://www.google.com/trends/explore#cat=1104

Your are now able to download the visualized time series in csv format, by clicking the top right gear wheel looking button.
I use the following code to do this via vba:

Please Login or Register  to view this content.

I you now open report.csv, you will see that it just contains the sites source code.

By pasting http://www.google.com/trends/viz?q=e...&graph=all_csv into the browsers addressbar, report.csv shows the expected results.

How do I build the url in a proper manner? I can't find any hints in the pages source code!

You have to copy this code into vba editor, to make the above lines executable:

Please Login or Register  to view this content.

Thank you very much!
Lloyd

Any ideas?

Because the link that produces the csv uses the title, not the id

How do I trigger the csv download via the id?

You don't, you do it by the title, the code I gave you before gets you both

Kyle,

Please Login or Register  to view this content.

your code produces a list looks like:

Celebrities & Entertainment News | http://www.google.com/trends/explore#cat=184

I don't see how to construct the url via the title!

I build the following url: http://www.google.com/trends/explore...ainment%20News

It is obviously the wrong syntax.

Lloyd

PHP Code: 

"http://www.google.com/trends/viz?q=" & replace(range("a1").value,"&","%2C%")  & "&cmpt=q&graph=all_csv" 


Would do it - you need to escape the & signs since they are reserved in urls

So how is it the wrong syntax? - If you'd said originally that this is what you were trying to do it would have been much easier

Now I got it!!!

Thanks Kyle!

Lloyd,

Would you mind sharing your final code please? I am working on a similar project to loop through Google's geographic codes but am running into trouble.

Thanks

DAK,

I don't have the code with me at the moment. I will upload some stuff in the coming days.

Lloyd

Thanks, Lloyd. In the meantime here's my code and where I am lost:

Please Login or Register  to view this content.

The macro sometimes comes to an error on the save to part, but I'm not sure if that has to do with the CSV files being empty or what. Any help is appreciated.

Thanks,
DAK

Lloyd,

I know you're busy running Goldman, but did you happen to find that code?

Thanks

Nevermind. I'm an idiot and forgot and & in front of my q= part of the code! It works now.

Hi,
I am writing a VBA for downloading a csv file from google trend.
I have tested the code in #1 .It runs but cannot return a proper csv file just like Lloyd said.
I do not understand what Kyle said. What do title and id refer to ?

I do not understand and cannot run the code in #6.
What is the input and ouput of this code?
When I run this, I face a Run- time error '-2147024891(80070005)'.

I am new in vba and sorry for my stupid questions.

really sorry about that

could anyone please give us the final code?

I am new on using VBA and I find it a bit tough to create a macro that will dowload google trends data straight to excel..

Thanks

could anyone please give us the final code?

I am new on using VBA and I find it a bit tough to create a macro that will dowload google trends data straight to excel..

Thanks