US Stocks: Exchange, Market, Sector, S&P 500, Optionable

This object is used to get up-to-date information for US stocks. It will create a database and download information such as the exchange, the industry, the sector and the month in which the fiscal year ends of each US stock. It will also tell you whether a stock is optionable and whether it belongs to the S&P 500.
Each time the object downloads new data; it stores them in the same database (company_desc) and associates them with the current trading day. As with other downloader (example: Broker Ratings & Recommendations, US Stocks: Size & Share Volume, EPS Estimate Revisions), this object allows you to create your own fundamental database.

Here are the different fields:
Exchange: The exchange where the stock is traded. The different values are NYSE, AMEX, INDX, PSE, NSDQ and OTC.

S&P 500: Specify whether the stock or company is included in the S&P 500 index or not.

Optionable: Specify whether this is an optionable stock or not. A stock is optionable when it has options trading on an exchange such as the Chicago Board Options Exchange. Because of some requirements, such as a minimum outstanding shares and a minimum stock price, several US stocks are not optionable.

Month of Fiscal Year End: The month in which the company's fiscal year ends. Values vary from 1 (January) to 12 (December).

Sector: The sector of the company (17 sectors).

Industry: The industry of the company (264 industries).

Here is an example on how to use the S&P 500 field using QuantShare vector-based language (This example requires that you have at least 1 month worth of data):

To get stocks that were included in the S&P 500 index during the last 30 days:
rule = GetData("company_desc", "s&p 500", LastData) == 1 and ref(GetData("company_desc", "s&p 500", LastData), 21) == 0;
First, we check that the stock is included in the S&P 500 index in the current bar, and then we check that it wasn't included 21 bars (about a month) ago.

Technical Analysis

• RSI GT 2%
• FRAMA Adaptive Strategy
• Ehler Filter Indicator
• DeMark Range Expansion Index
• Percentage of Bars a Trading rule Generates Buy/Sell Signals
• Hull Moving Average - HMA
• ATR - Average True Range Drawing Tool
• Historical Share Prices - Deutsche Börse XETRA
• Last Gap Up/Gap Down Price Size
• Trading Rules based on the Relative Strength Index - RSI Indicator
• More trading objects...

Fundamental Analysis

• All-Star Traders Outperform/Underperform Picks for US Stocks
• Identify Spilts Screener Script
• Google Trends Sentiment Indices
• Implied Volatility of iPath ETNs - IV Historical Data
• S&P 500 Earnings and Price Earnings Ratio Estimations
• News data for US companies from Google RSS feed
• Consumer Credit Historical Data
• Ownership data for US companies
• Analyst downgrades & upgrades
• Detect and Display Potential Splits on a Chart
• More trading objects...