I had read this Where to download list of all common stocks traded on NYSE, NASDAQ and AMEX?.

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?

enter image description here

enter image description here

  • $\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


Your Answer

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.

Browse other questions tagged or ask your own question.