Filter REITS

BobV

Is there a way to exclude REITs from a scan?
I have searched using filter reits and exclude reits .
I have a simple scan looking for Canadian stocks making new 52 week highs and would like to exclude REITs and Income trusts>

markd

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.

BobV

Thank you mark. All stocks I want to exclude contain "/un"
What would be the proper syntax to exclude all symbols that contain "/un" ?

BobV

Can you say [symbol does not contain/}

BobV

[NAME NOT CONTAINS "INVESTMENT TRUST"]
This seems to work.

markd

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".

BobV

I tried that but syntax doesn't seem to recognize [ / ]

markd

Do you have some actual symbols and names?

Or, if you want, post the scan and I'll look at the results.

BobV

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.