Jim Dean![]() Sage ![]() ![]() Posts: 3022 Joined: 9/21/2006 Location: L'ville, GA ![]() | Sorry. Faulty memory. I thought that they had included those functions in the Zacks upgrade. Hmm. I don’t recall offhand for sure, but I think that all zacks groups have a long fixed length symbol name such as ZG12345678. Not at pc right now so I can’t check but it should be easy to. If so, you can construct a rule based either on the number of characters or the prefix or both. Here is an example but you’ll have to tweak it for the actual Zacks ID structure: To *only allow* Zacks symbols, use this: Left$(Symbol,2) = “ZG” and len(symbol) = 10 To *NOT allow* Zacks symbols, use this: Left$(Symbol,2) <> “ZG” or len(symbol) < 10 I used “MG” and it’s len = 3,4,5 to ID MG Sectors, Groups and Subgroups. IIRC, the ZG’s all are the same length - but again, easy to check from the pencil Omniscan table. [Edited by Jim Dean on 2/23/2021 3:41 PM] |