| 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 448 posts
 msg #139412
 - Ignore dwiggains
 | 11/20/2017 10:24:37 AM 
 ??????
 
 
 
 
 
 | 
| dwiggains 448 posts
 msg #139413
 - Ignore dwiggains
 modified
 | 11/20/2017 10:29:04 AM 
 
 
 
 
 
 
 
 
 
 
 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 448 posts
 msg #139435
 - Ignore dwiggains
 | 11/21/2017 5:01:27 PM 
 These are the wildest stocks for movement today.
 
 
 
 
 
 | 
| 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...
 
 
 |