StockFetcher Forums · General Discussion · Filters<< 1 2 >>Post Follow-up
rustyknight
7 posts
msg #139404
Ignore rustyknight
modified
11/20/2017 2:00:18 AM

Greetings,

How can I get the previous trading days close? In other words so I can filter like so: "previous close > 5" for a stock.

How can I filter on market? In other words so I can filter like so: "market = DIA" and get a list of stocks for only the DIA market.

Please advise.

Thanks

dwiggains
441 posts
msg #139412
Ignore dwiggains
11/20/2017 10:24:37 AM

??????

Fetcher[
close 1 day ago > 5
]



dwiggains
441 posts
msg #139413
Ignore dwiggains
modified
11/20/2017 10:29:04 AM

Fetcher[
market is NYSE
]



Fetcher[
market is s&p 500
]



Fetcher[
market is not ETF
]




examples
see ya
david

rustyknight
7 posts
msg #139416
Ignore rustyknight
11/20/2017 9:58:52 PM

Thank you, that got me further.

I still have an issue. I don't believe the following line is working as intended. I am trying to divide the result of the art(14) function by that of the prior days close and include if result is greater than 5 It is not working thought because I am returning stocks with less than 5 for atr. Please advise. Thanks...

And (atr(14) / close 1 day ago) > 5

Kevin_in_GA
4,599 posts
msg #139417
Ignore Kevin_in_GA
11/20/2017 10:14:55 PM

Not sure if the daily range can actually be 5 times larger than the price. Think about it ...

dwiggains
441 posts
msg #139435
Ignore dwiggains
11/21/2017 5:01:27 PM

These are the wildest stocks for movement today.

Fetcher[
set{wild, atr(14) / close}
add column wild
sort column 5 descending
close > 2
average volume (20) > 456000
]



rustyknight
7 posts
msg #139437
Ignore rustyknight
modified
11/21/2017 7:23:09 PM

Great, getting closer, thanks.

Next question,

how can I filter on just one ticker/symbol or market index like the market symbol/Index for NYSE?

For example: select stock where symbol = ^GSPC

Thanks in advance for everyone's help.

Kevin_in_GA
4,599 posts
msg #139440
Ignore Kevin_in_GA
11/21/2017 8:49:32 PM

SF will not return indices as the result of any filter. However, you can use them as part of a filter, and graph them if you want. Just use syntax like this (change to whatever index you want) - this will create a variable that can be used/plotted that is the closing price data for the index:

set{VIX, ind(^VIX, close)}

or

set{SP_RSI, ind(^SPX, rsi(2))}

in the second example, you can plot or use the RSI(2) value (or any other value) for the index.

rustyknight
7 posts
msg #139462
Ignore rustyknight
11/22/2017 4:06:33 PM

"Select stocks where market is NYSE" works fine for NYSE but I cannot seem to make it work for the S&P 500, the NASDAQ, the Dow or any others for that matter.

Please advise, thanks in advance.

rustyknight
7 posts
msg #139470
Ignore rustyknight
11/23/2017 12:19:21 PM

Greetings all,

Firstly, happy Thanksgiving to all!

Admittedly I am new at trading. What is the difference between a "market" and an "exchange"?

Please advise.

Thanks...

StockFetcher Forums · General Discussion · Filters<< 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.