This function parses a symbol custom database and returns a value of one on bars where the database field data contain a specific word.
This function accepts three parameters. The first one is the database name (Example: ' yahoo_news ' if you are using the yahoo news downloader - Yahoo News), the second one is the field name (Using the same downloader, it should be 'title') and finally the last parameter is a list of the words we are searching for. You can add one or many words by separating them with a comma.
Here is an example: (This function's name is 'ContainsWords')
indicator1 = ContainsWords('yahoo_news', 'title', 'Buy,Jump,Big,Rise');
In addition, here is a snapshot of the 'yahoo_news' database for the stock symbol 'aa':
25/09/2009 15:14 - Alcoa Stock: Time to Buy Yet?
25/09/2009 16:11 - Alcoa Announces Third Quarter 2009 Dividend
25/09/2009 12:45 - Wall to Wall Street Coverage: Upgrades and Downgrades
25/09/2009 00:01 - [$$] Alcoa Leads Decline; Red Hat Is White Hot
24/09/2009 21:33 - Will RIM Drag Down Stocks, Friday?
On 25 September 2009, the function returns 1, because at 15:14, a news item contains the word 'Buy'.
On 24 September 2009, the function returns 0.