ActiveTrader 2013-01 | Google Trend Sentiment Systems
Author: Eugene
Creation Date: 12/5/2012 3:09 AM
profile picture

Eugene

#1
Code for "Google Trend Sentiment Systems" from Jan 2013 issue of ActiveTrader Mag has been published:

* Google Trends: Composite Sentiment Index system
* Google Trends: Individual Stock Keyword Rank system


We recommend downloading it directly using the convenient "Strategy Download" feature (found in Wealth-Lab's "Open Strategy" dialog).

REQUIREMENTS:

1. Installed Community Components library!

2. Don't forget to insert your own Gmail credentials in code (Gmail is REQUIRED and NO OTHER email will work):

CODE:
Please log in to see this code.


If you have two-step verification in Google, you will get an error. You have to generate a Application Specific Password and input that password. How-To.


NOTE:

When article was already submitted to the magazine, Google has suddenly changed the rules used in ranking Google Trends, causing a difference in numbers and charts. However, since the old API remains accessible, we decided to leave everything as is until it breaks.
profile picture

WEALTHPRO25

#2
I am getting this error
runtime error, index was out of range, i did put my gmail address and password for the google trends
profile picture

Eugene

#3
Don't worry, it's not you - it's Google making breaking changes: most likely to its authentication routine.

Our Google Trends solution is broken due to a sudden internal change at Google. As no workaround is found so far I'm taking down the strategies. This is where it ends.
profile picture

Eugene

#4
Good news: Google Trends has been partially restored!

The work around found is less precise as the data is only Monthly (Google typically returns Weekly data for Google Trends). But it does not require your Gmail account and password any longer! To make it work:

1. Update or install Community Components v2017.09 or newer. Restart WLP/D.
2. Download updated Google strategies from Wealth-Lab's "Open Strategy" dialog (click "Download").

Old strategies and your own works should function, too.