StockFetcher Forums · Filter Exchange · Why are ETFs not excluded from results when "market is not etf"<< >>Post Follow-up
alexchambers
8 posts
msg #160459
Ignore alexchambers
8/1/2023 5:31:37 AM

Hi, I would like to exclude ETFs from the results - but ETFs are shown in my filter (below). Any suggestions? Thanks

Fetcher[
set{3YRhi,high 3-year high}
set{var1,close / 3YRhi}
set{PercentFromHi,1 - var1}
set{hp, 3YRhi * 0.85}
PercentFromHi < 0.15 // x% of 3yrNH

close>10
average volume(50)>250000

draw price line at 3YRhi
draw price line at hp

set{roc3m, close / close 60 days ago}
set{roc6m, close / close 125 days ago}
set{roc12m, close / close 250 days ago}
add column roc3m
add column roc6m
add column roc12m
sort column 6 descending

market is not ETF
]



wantonellis
154 posts
msg #160460
Ignore wantonellis
8/1/2023 10:29:36 AM

Good question. "market is not otcbb" doesn't seem to work anymore either.

Mactheriverrat
3,127 posts
msg #160463
Ignore Mactheriverrat
8/1/2023 11:03:11 AM

Market is not OTCBB
and
Market is not ETF

are working for me

glgene
613 posts
msg #160464
Ignore glgene
8/1/2023 3:30:15 PM

Try replacing your wording “Market is not ETF” with the following

<> ETF

This works for me.

Gene in FL

glgene
613 posts
msg #160465
Ignore glgene
8/1/2023 3:32:40 PM

Oops. I still got some ETFs. Sorry.

Gene in FL

jimvin
170 posts
msg #160468
Ignore jimvin
modified
8/1/2023 10:07:17 PM

For what it's worth (apologies to Buffalo Springfield circa 1967) I ran some tests on my models and the problem seems to be model dependent; it works on some of my models but not others.

This would underscore the Captain's note that the function works for him.

I sent the StockFetcher crew an email with an example of a model in which the command doesn't work...

jm.v.

jimvin
170 posts
msg #160471
Ignore jimvin
modified
8/2/2023 10:30:39 PM

Reply from StockFetcher Support:

"Thank you for the feedback. Please provide any symbols that appear misclassified and we will look into the issue further.
If you have any additional questions, please do not hesitate to send us an email."

I sent some "misclassifications" and got a quick response:

"Thank you for the feedback. We have passed this along to our data integrity team for further investigation."

Stay tuned - jm.v.

Chiqmagnet
7 posts
msg #160484
Ignore Chiqmagnet
8/4/2023 12:34:59 PM

On the same lines, I'm also seeing a lot of symbols having their exchange marked incorrectly as OTCBB/Other instead of NYSE or NASDAQ. META for example. Can others here confirm the same?

Chiqmagnet
7 posts
msg #160486
Ignore Chiqmagnet
8/4/2023 2:32:28 PM

I think they fixed some of this now! I see more symbols showing up on my screens with the filters applied

StockFetcher Forums · Filter Exchange · Why are ETFs not excluded from results when "market is not etf"<< >>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.