SocialPicks Analysis

by Patrick Fonce, 1426 days ago

Share |

SocialPicks is a community for stock traders and investors to share investment ideas, rate stocks and track other users' investment decisions and performance. Each investor can express his opinion regarding a particular stock; he can then decide whether his is bullish (initiate a buy) or bearish (initiate a sell) on that stock.

The current item downloads RSS feeds from the SocialPicks.com website. The feeds contain users or investors bullishness or bearishness on a particular stock.

Each ticker symbol has its own feed, the RSS content is downloaded, parsed and finally inserted into a custom database. The database name is 'socialpicks' and it has 2 columns: title and link.

After downloading some data, here is how a row will look like:
Symbol: AAU - 11/06/2009 02:03:49 - Almanden Minerals Ltf (AAU) is a BUY - http://www.socialpics.com/ideas/show/....

To plot or to create trading rules using this data, use the 'GetDataStringCount' function.
This function loads the provided database and field data and returns a time-series containing the number of elements found on each bar (date) that match the regular expression used as argument.

The following line of code will return a time-series that contain a value of 1 on bars where the word 'BUY' is found.
GetDataStringCount('socialpicks', 'title', 'BUY');
If you are looking for bearish comments, then search for the word 'SELL' within the comments using the following formula:
GetDataStringCount('socialpicks', 'title', 'SELL');

To get the number of elements or comments from SocialPicks for each bar, use the following formula:
GetDataCount('socialpicks', 'title');