To download the European countries' equity (stocks) data from CRSP database, I need individual stocks ticker symbols. Can anyone help me regarding how can I get the list of ticker-symbols of European countries stocks? I can manage to download ticker symbols of NASDAC, AMEX, and NYSE stocks from this link:
Have your friend give this Python library a try for you: pytickersymbols. It specifically exists to return ticker symbols. I have not used it extensively-only a brief test using the code below (which is taken from their documentation). The symbols come from Yahoo and Google finance. If you have interest in what is going on under the hood, this is the GitHub repo: pytickersymbols GitHub repo
from pytickersymbols import PyTickerSymbols stock_data = PyTickerSymbols() countries = stock_data.get_all_countries() indices = stock_data.get_all_indices() industries = stock_data.get_all_industries()
After running that code, you can view the tickers like this:
print(list(countries)) print(list(indices)) print(list(industries))
You can export the symbols to a
.xlsx file as well if you need to work with them outside of Python. This is quite easy to do and shouldn't take your friend more than a few minutes of their time. There are also slight variations that allow you to call for specific countries in case you don't want a list of all stocks. You can find that info in the documentation in the above link.
Yes, I have a database that covers all 70,000 stocks worldwide. You can download the European portion from the original table hosted on this Public Domain. The tickers comply to Yahoo Finance's version.