0

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

huang
  • 101
  • 1
  • 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? – nbbo2 Apr 16 '20 at 13:45
  • @noob2 Although you are right, but how can I filter equity from nasdaqlisted.txt? I only need equities. – huang Apr 16 '20 at 13:55
  • 1
    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). – Kevin Apr 16 '20 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. – nbbo2 Apr 16 '20 at 22:30
  • @KeSchn Can anyone access them? – huang Apr 17 '20 at 02:37
  • @JokeHuang no unfortunately not. Many universities provide access to wrds. If you’re in a job, your employer may do? I don’t know. But CRSP is the data source for US stock data for academic research. – Kevin Apr 17 '20 at 08:23

0 Answers0