StockFetcher Forums · General Discussion · Exclude OTCBB/Other<< 1 2 >>Post Follow-up
njjstocks
8 posts
msg #161173
Ignore njjstocks
6/30/2024 3:57:55 PM

Hi,

I’m new to the platform. Any recommendations on how to exclude ‘OTCBB/Other’ stocks? I’m trying to exclude all stocks except NYSE and NASDAQ.

Many thanks in advance

snappyfrog
728 posts
msg #161174
Ignore snappyfrog
6/30/2024 5:21:25 PM

market is not otcbb
market is not etf
etc

snappyfrog
728 posts
msg #161175
Ignore snappyfrog
6/30/2024 8:58:26 PM

Examples here:

https://www.stockfetcher.com/help/Stocks-of-a-market-NYSE-NASDAQ-ETF/100249

njjstocks
8 posts
msg #161177
Ignore njjstocks
7/1/2024 4:44:26 PM

I tried the following. Still seem to be getting 'OTCBB/other'. (Try sorting the exchange column)

Thanks in advance.


Fetcher[
show stocks were market is not ETF
and market is not OTCBB
and market is not AMEX
and add column exchange

]



jimvin
173 posts
msg #161178
Ignore jimvin
modified
7/2/2024 2:07:21 AM

I find this to be a common problem that requires a manual edit of the listing. Probably has something to do with a lag in StockFetcher's updating their data. It's annoying, but not a critical flaw.

njjstocks
8 posts
msg #161179
Ignore njjstocks
modified
7/2/2024 8:49:19 AM

Thank you both. Here's a potential workaround to autofilter by exchange


Fetcher[
show stocks were market is not ETF
and market is not OTCBB
and market is not AMEX
and add column exchange

sort column 5 ascending
]



push5280
201 posts
msg #161180
Ignore push5280
7/2/2024 6:22:50 PM

"where" is misspelled in the 1st line.

push5280
201 posts
msg #161181
Ignore push5280
7/2/2024 9:07:59 PM

I remember awhile back I was having the same problem in my scans, I noticed that the otcbb and ETFs had N/A for shares out. If you add a line

shares outstanding > 0

it will eliminate the ETFs and OTCBB

Fetcher[ market is not ETF
market is not OTCBB
market is not AMEX
and add column exchange
add column shares outstanding

sort column 6 ascending
]



jimvin
173 posts
msg #161182
Ignore jimvin
7/3/2024 12:13:13 AM

Looks like both methods work.

My thanks (for what they're worth) to all -
jm.v.

SAFeTRADE
645 posts
msg #161183
Ignore SAFeTRADE
7/3/2024 6:08:30 AM

Or you could just add "market is otc/bb and just hide all 2220 or so of them and be done with it. That is what I did, That brings the symbol world down to just over 6000 names. Those otcs will still show if one specifically scans for them.

All the best

StockFetcher Forums · General Discussion · Exclude OTCBB/Other<< 1 2 >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.