Filter REITS
Comments
-
I don't think there is a perfect way, but here are some "hacks".
You may be able to exclude a lot of them using
and [name not contains "REIT"]
But there will probably be others that don't have REIT in the name, or else have a variation of REIT, like R.E.I.T or RE Trust, etc.
If that's the case, then you need a separate statement for each variation, or some part of the variations might be common, like
and [name not contains "Trust"]
But then, you may also exclude stocks that are not REITs but just have Trust in the name, like say a bank.
For the few that might elude these conditions, you can specifically exclude symbols:
and [symbol is not "ABC"]
or whatever.
Don't use "contains" on symbols, because a lot of letter combinations are shared by many symbols. You have to specify the complete symbol and say "is not".
It will probably take several tries to eliminate them all.0 -
Thank you mark. All stocks I want to exclude contain "/un"
What would be the proper syntax to exclude all symbols that contain "/un" ?0 -
Can you say [symbol does not contain/}0
-
[NAME NOT CONTAINS "INVESTMENT TRUST"]
This seems to work.0 -
if the NAME includes "/un" then you would write
and [name not contains "/un"]
if the SYMBOL includes "/un" then you would write
and [symbol not contains "/un"]
Note there is no "does", just the operator "not".0 -
I tried that but syntax doesn't seem to recognize [ / ]0
-
Do you have some actual symbols and names?
Or, if you want, post the scan and I'll look at the results.0 -
I got a scan to work using [NAME NOT CONTAINS "INVESTMENT TRUST"]
Thank you for your help. I wouldn't have got there on my own.0
Categories
- All Categories
- 2.4K StockCharts
- 397 SharpCharts
- 146 Other Charting Tools
- 69 Saved Charts and ChartLists
- 1.5K Scanning
- 74 Data Issues
- 177 Other StockCharts Questions
- 224 Technical Analysis
- 155 Using Technical Analysis
- 6 InterMarket and International
- 19 Market and Breadth Indicators
- 44 Market Analysis
- 109 Trading
- 109 Trading Strategies
- 162 S.C.A.N the StockCharts Answer Network forum
- 64 Using this StockCharts Answer Network forum
- 98 s.c.a.n. archives
- 7 Off-Topic
- 7 The Cogitation & Rumination Emporium
- Forum Test Area
