This is a trading item or a component that was created using QuantShare by one of our members.
This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...
You can use this item and hundreds of others for free by downloading QuantShare.
Top Reasons Why You Should Use QuantShare:
Works with US and international markets (stock, forex, options, futures, ETF...)
Offers you the tools that will help you become a profitable trader
Allows you to implement any trading ideas
Exchange items and ideas with other QuantShare users
Our support team is very responsive and will answer any of your questions
We will implement any features you suggest
Very low price and much more features than the majority of other trading software
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: