StockFetcher Forums · Filter Exchange · Simple query. Does not work<< >>Post Follow-up
clam61
92 posts
msg #43674
Ignore clam61
5/12/2006 2:49:23 PM

Fetcher[Show stocks where market is not OTCBB and close is below 1]



Still shows stocks that are OTCBB


TheRumpledOne
6,362 posts
msg #43680
Ignore TheRumpledOne
5/12/2006 7:26:58 PM

Fetcher[
market is not OTCBB
and close is below 1

add column market
sort column 5 descending
]



Blank market value is the culprit.

Here's the fix:

Fetcher[
set{ xm1 , count( market is nasdaq , 1 ) }
set{ xm2 , xm1 + count( market is nyse , 1 ) }
set{ xm3 , xm2 + count( market is amex , 1 ) }

xm3 above 0
and close is below 1

add column market
sort column 5 descending
]



HTH.




StockFetcher Forums · Filter Exchange · Simple query. Does not work<< >>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