# How to check if a symbol is a Common Stock (Equity)?

I know the ETF field of nasdaqlisted.txt indicate whether it is an ETF, but it is not always correct.

For example: DGLD - VelocityShares 3x Inverse Gold ETN Linked to the S&P GSCI Gold Index ER

It's an ETF on Yahoo Finance, but it's NOT an ETF in nasdaqlisted.txt.

So, what's the correct(best) way to check if a symbol is a Equity or not? In other words, check if it's a ETF or not?

• It is an ETN which strictly speaking is not an ETF (although many people mix the two up). So I would say on this one it is Yahoo Finance which is wrong. Do you have other examples of discrepancy? Apr 16, 2020 at 13:45
• @noob2 Although you are right, but how can I filter equity from nasdaqlisted.txt? I only need equities. Apr 16, 2020 at 13:55
• If you have access to WRDS ad CRSP, you can download all stock data and keep items with share code 10 and 11 (common equity) and exchange code 1, 2 and 3 (NYSE, AMEX, NASDAQ). Apr 16, 2020 at 20:26
• If you are going to use this data, you might need a Blacklist (exclusion list) of things which are not equities, you could start by including in it all things which have ' ETN' in the name, but you might discover other things later that you also want to exclude. ADRs? REITs? Unfortunately you will have to maintain this list manually when new bad things pop up. Apr 16, 2020 at 22:30
• @KeSchn Can anyone access them? Apr 17, 2020 at 2:37