How to filter only normal stocks?

liu.chen · November 2024

Hi.

I am trying to search all stocks rics from an exchange, but the return many are not stocks such as in screenshot iShares Trust - iShares Core S&P 500 ETF. And many lot of rics for the same stock for CBA there are 7 rics, but only CBA.AX is the normal one, how can I filter out those during retrieve? I don't want to drop duplicate by company name after retrieve as they increase number of rows where the maximum retrieve is limited to 10,000. Thank you!