StockFetcher Forums · General Discussion · Fetch ETF's and Stock in same scan?<< >>Post Follow-up
Smpoll
79 posts
msg #159599
Ignore Smpoll
9/19/2022 11:48:36 AM

Hi, I'm having difficulty finding both in the same scan. When I write "Find stocks and etfs" or the other way around I still just get etfs not both.

Thanks for your help.

xarlor
587 posts
msg #159600
Ignore xarlor
9/19/2022 11:54:53 AM

No need to specify either. By not specifying, both stocks and ETFs are included. Here is an example:

Fetcher[
symlist(SPY,AMZN,QQQ,NVDA)
]



Only Stocks:
Fetcher[
not etf
symlist(SPY,AMZN,QQQ,NVDA)
]



Only ETFs:
Fetcher[
etf
symlist(SPY,AMZN,QQQ,NVDA)
]



Smpoll
79 posts
msg #159601
Ignore Smpoll
9/19/2022 12:12:03 PM

Here's my script that's not working and when I tried to do yours it's not working either.

Fetch stocks and etfs where the close is less than 10 percent below the 52 week high
price is above 10
volume is above 50000

Thanks

xarlor
587 posts
msg #159602
Ignore xarlor
9/19/2022 12:55:06 PM

Again, no need to specify stocks nor ETFs if you want both.

Fetcher[
close is less than 10 percent below the 52 week high
price is above 10
volume is above 50000
]



Smpoll
79 posts
msg #159603
Ignore Smpoll
9/19/2022 1:07:13 PM

I understand what you're doing and have tried it multiple times adding addt'l commands and it does not work on my machine.

Is Stockfetcher less compatible with Macs than PCs?

Smpoll
79 posts
msg #159604
Ignore Smpoll
9/19/2022 1:09:17 PM

When written this way I get both results which doesn't make sense either:

Show stocks where the average day range is above 1.5%
and price is greater than 20


xarlor
587 posts
msg #159605
Ignore xarlor
9/19/2022 1:33:38 PM

"Stocks" command in SF means the entire universe of tickers it contains in its database. Really, the only filters that matters are:

is ETF
not ETF

The first shows only ETFs, no stocks.
The second shows stocks, no ETFs.

Don't know about the Mac question. I imagine it's no different as the processing is performed on the server, not your local PC.

Smpoll
79 posts
msg #159606
Ignore Smpoll
9/19/2022 1:58:50 PM

Ok, thank you, I’m going to try it out on a different computer later.

Smpoll
79 posts
msg #159608
Ignore Smpoll
9/20/2022 11:14:05 AM

To followup, it finally worked after rebooting, thanks for your help.

StockFetcher Forums · General Discussion · Fetch ETF's and Stock in same scan?<< >>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.