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

Ask Question

Asked 3 years, 1 month ago

Modified 3 years, 1 month ago

Viewed 80 times

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?

asked Apr 16, 2020 at 13:20

huang

1011 bronze badge

$\begingroup$ 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? $\endgroup$
– nbbo2
Apr 16, 2020 at 13:45
$\begingroup$ @noob2 Although you are right, but how can I filter equity from nasdaqlisted.txt? I only need equities. $\endgroup$
– huang
Apr 16, 2020 at 13:55
1

$\begingroup$ 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). $\endgroup$
– Kevin
Apr 16, 2020 at 20:26
$\begingroup$ 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. $\endgroup$
– nbbo2
Apr 16, 2020 at 22:30
$\begingroup$ @KeSchn Can anyone access them? $\endgroup$
– huang
Apr 17, 2020 at 2:37

| Show 1 more comment

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.