StockFetcher Forums · General Discussion · market is not ETF, not trust, closed end fund etc...<< >>Post Follow-up
lummy8
10 posts
msg #121116
Ignore lummy8
7/27/2014 8:12:30 AM

Good morning!

How do i filter out stocks that are not ETF, not trust, not REIT, closed end fund etc? I only want shares/stocks.

Thanks

four
3,995 posts
msg #121118
Ignore four
modified
7/27/2014 11:34:37 AM

You may want to contact Stockfetcher directly for: trust, not REIT, closed end fund

The below is taken from this excellent resource: http://yepher.com/stockfetcher/command.html

Command:
Market is
Type: market
Parameters: None
Usage: market is [MARKET]
market is not [MARKET]
Components: fundamental
market
Example:
show stocks where MA(10) crossed above MA(50) and market is OTCBB
Price is between 1 and 10 And add column sector description and add column market and sort column 5 descending
show stocks where market is AMEX
show stocks where market is QQQ
show stocks where the market is NYSE
show stocks where the market is NASDAQ

Description:

You can filter by market by it's name or by it number listed
below.

Currently Stockfetcher supports the major U.S. markets. Below
are some samples using the appropriate phrasing:

NASDAQ
NASDAQ 100
NOT LEAPS
NVI
NYSE
Not Amex
Not NASDAQ
Not NASDAQ 100
Not NYSE
Not OTCBB
Not Optionable
Optionable
Not S&P 500
OTCBB
NOT ETF





A simple way to filter for market is like this

Price is between 5 and 7
AND market equals 5
and add column market description
and add column market

where market number is:

1 - OTCBB
2 - AMEX
3 - NYSE
4 - Nasdaq / OTCBB
5 - NASDAQ / OTCBB

Thanks to xplorer for discovering markets can be filtered by
number.


StockFetcher Forums · General Discussion · market is not ETF, not trust, closed end fund etc...<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus