Get the complete list of Yahoo stock ticker symbols in an Excel spreadsheet – over 158000 ticker symbols for stocks, ETFs, mutual funds, warrants and more, across many international exchanges.
You can use this list for stock screening, downloading bulk stock quotes, researching company financial information and more.
It’s a fantastic resource that is difficult to find elsewhere (certainly not on Yahoo’s website).
Use the tickers with the MarketXLS addin for Excel for live financial quotes in your spreadsheet.
This Excel spreadsheet was updated in September 2017. It is broken down into eight sheets, one each for
- stocks (106332 tickers)
- ETFs (21196tickers)
- futures (9294 tickers)
- indices (80017 tickers)
- mutual funds (24926 tickers)
- currency pairs (4019 tickers)
That’s 245784 tickers symbols in total.
The spreadsheet is filtered with respect to the exchange, category name, category number and country. This means you can drill down to get get a list of all the Aerospace & Defense companies in the UK, Germany, US or elsewhere. This is useful for investment research.
You get tickers across all international exchanges, including
- Chicago Board of Trade (CBT), Chicago Merctantile Exchange (CME) and New York Stock Exchange (NYSE)
- Toronto Stock Exchange (TSX)
- Sao Paolo Stock Exchange (BOVESPA)
- London Stock Exchange (LSE)
- Bombay Stock Exchange (BO) and National Stock Exchange of India (NSE)
- Hong Kong Stock Exchange (HKG) and Chinese stock exchanges (SHZ, SHH)
- European exchanges (including Germany, France, Amsterdam etc)
- Melbourne Stock Exchange (ASX)
- and many others
Now that you have the entire set of Yahoo ticker symbols, you can use the MarketXLS addin for Excel for live financial quotes; simply use the ticker symbol as an argument in one of over 80 functions.
Let’s say you want the market capitalization of Exxon Mobil.
Just enter =MarketCapilization(“XOM”) function into a cell, and hit enter. MarketXLS then imports the live financial data. If you recalculate the spreadsheet, the market cap is updated. Click here to learn more and use coupon code investexcel for an exclusive 20% discount.
Download Excel Spreadsheet with Complete List of Yahoo Stock Ticker Symbols
Hi Sir,
Fantastic work, I had hard time finding a list for BOVESPA listed stock.
I was wondering how you did find the raw data to built such an excel sheet.
…Let say that I want to refresh the list sometime somewhere in 2015, is there a way to do that?
Thx very much for this, amazing.
L
I used my own software to scrape tickers from Yahoo. To update the tickers, I need to rerun the software.
samir your work is outstanding. Could you please develop some resources for Middle east stock index such as saudi arabia tadawul index. Your yahoo ticker list doesnt include the tickers of saudi arabia.
Hi Samir,
Thanks for the reply, I’m very curious on the ”philosophy” of your scrapping methodology, do you run a code that basically try every combination of characters designating possible stock symbols on a given exchange and add them loop after loop to a list if a positive response is given by yahoo when querying?
Of course I’m not expecting you to give me your code! But I’m just very curious as I was thinking not long ago on how could I do just that and I haven’t find a way yet… so maybe you could just give a hint on how to do this?
Kindly
L
Your premise is correct. I test every combination of characters against every exchange, progressively adding them to a list if they are valid. The entire program takes a day to run (there are lots of combinations, and restrictions placed by Yahoo on the number of queries per hour)
Hello
My name is Samuel Van Ransbeeck. I am doing my PhD on sonofication of stock markets and this sheet will be handy. I am making a software toolbox to use stock market data for uses in algorithmic composition. Do you mind if I include a copy in the appendix of my thesis? It would be great for the user if he can see what symbols exists (most people who will use the app will be artists, so they will not have much knowledge about which symbols exist).
I have a question regarding the queries: how many are you allowed to make during an hour? Do you have a number on that because I cannot find anything concrete on that matter.
Anyway, thank you for this work
Yours sincerely
Samuel Van Ransbeeck
Great VB application! Made use of the multi-ticker application. Thank you Samir. I have added to it a bit to calculate MACD, SMA, EMA, and RSI/RS and dusted off my VB knowledge in the process. Thank you for the impetus to learn again.
Best wishes, David
Hi Samir;
Could you run your software to update the tickers again.
thanks
Hi Samir,
Thanks for your amazing body of work. Could you add JSE (Johannesburg Stock Exchange) to your scraper for the next run. The South African stocks are now available on Google finance.
Many thanks. Jon
Dear Samir,
This is great idea and quite good result – thank you a lot. Unfortunately, many companies (at least from Hong Kong) are missed (e.g. 0002.HK. 0003.HK). Also – what is the Category Number means?
Thanks
J.C.H.
Hi – the list currently on the website has 277 Hong Kong tickers. I’ve recently updated the list, and I now have 677 Hong Kong tickers. If I find time I might upload the new list.
The category number refers to the Yahoo Finance category number (look at https://biz.yahoo.com/ic/ind_index.html)
please post when you can Samir. great work!
This is very useful. Do you still update the list?
For my own purposes, yes. But not often because it takes days to compile.
Hello,
I am doing a project that runs web queries on Russell 1000 companies to get information for stock screening. Your symbol list is how I get company names assigned to yahoo tickers. The following yahoo symbols are not on the spreadsheet.
ATHN athenahealth, Inc.
BRKR Bruker Corporation
CDW CDW Corporation
CELG Celgene Corporation
CFN CareFusion Corporation
CI Cigna Corp
CMCSA Comcast Corporation
COMM CommScope Holding Company, Inc.
COTY Coty Inc.
CPA Copa Holdings SA
CR Crane Co.
CTAS Cintas Corporation
CTRX Catamaran Corporation
EPE EP Energy Corporation
GHC Graham Holdings
GWR Genesee & Wyoming Inc.
HLT Hilton Worldwide Holdings Inc
IEX IDEX Corporation
IMS IMS Health Holdings, Inc.
JBL Jabil Circuit Inc.
KATE Kate Spade & Company
KMT Kennametal Inc.
KN Knowles Corporation
LAZ Lazard Ltd.
LB L Brands, Inc
LPT Liberty Property Trust
MD MEDNAX, Inc.
MHK Mohawk Industries Inc.
MRO Marathon Oil Corporation
MSCI MSCI Inc.
NAVI Navient Corporation
PAH Platform Specialty Products Corporation
PINC Premier, Inc.
PRA ProAssurance Corporation
PTC PTC Inc.
QGEN Qiagen NV
RICE Rice Energy Inc.
ROL Rollins Inc.
SABR Sabre Corporation
SC Santander Consumer USA Holdings Inc.
TCO Taubman Centers, Inc.
TSS Total System Services, Inc.
USM United States Cellular Corporation
WHR Whirlpool Corp.
WLK Westlake Chemical Corp.
WYN Wyndham Worldwide Corporation
ZU zulily, Inc.
Add there names to the list and you are covered (for now) when using the Russell 1000 universe of stocks.
Thanks! That’s very helpful
Samir, will you put a fresh ticker list? There is a lot of 404 ‘no page found’ errors from Yahoo for Nov 2013 list now
OK, I’ll start preparing one. It takes hours and hours and hours (and then some) to scrape Yahoo and present the information. I’d appreciate a link from your blog or website in return 🙂
I’ve uploaded a new list (updated in January 2015)
Samir, it would be great also, if you add a worksheet with directory of Exchanges, whose codes are used in your ticker list (fields: exchange code, exchange name, country). Otherwise, could you provide a link to such a dictionary on the web, please. It’s like codes that of Google Finance, not Yahoo. Any comments of yours are welcome and appreciated
Hi Samir,
Are there BSE and NSE (Indian sensex) in your ticker list. IF not, can you pls include them.
Thanks a lot in Advance.
It’s only what Yahoo Finance offers. If it’s not there, then I can’t include them.
Really help ful information for Indian Stock Market but it’s not showing all result.
Please share if you can.
This is a huge help! Thanks so much!
Dear Samir, can you share a fresh Dec 2014 ticker list by now? I think, that all visitors would appreciate it
I’ll publish an updated list in January 2015.
New list published!
A lot of stock symbols are still cannot find. e.g. 5238.KL, 5257.KL
Can you give me the missing symbols? I’ll add them to the spreadsheet.
Hi Samir,
Thanks for sharing such a great excel.
However, there are still quite a few Hong Kong stock ticker symbols that are missing too beside the Kuala Lumpur stock codes that Henry mentioned in another post.
Your coding should pick up all stock codes from Hong Kong and Kuala Lumpur especially when they consist of numbers only.
Here’s a list of stock codes from the Hong Kong Stock Exchange for your reference.
https://www.hkex.com.hk/eng/market/sec_tradinfo/stockcode/eisdeqty_pf.htm
Thanks~and hope your excel gets even better!
Holy mother of goodness, Thank you, Thank you, thank you. I had been developing my own scraper for personal research. looking at the number of possible symbols even for just the us market 27^5 crashed the memory in my program. Not to mention the web parsing to follow. Very valuable, thank you.
Taiwan market is not complete, .TWO is the Taiwan OTC market, the main Index, the Taiwan Stock Exchange tickers are in .TW, would be great to add these in future, thanks for a great work!
I see that the .TW is in TAI Exchange category, but it still missing many tickers
the Exchange “FRA” section is not France Stock Exchange, it is Germany Frankfurt Stock Exchange
my mistake, FRA stands for Frankfurt then…. 🙂
KAILASAUTO.BO, RASOYAPROTEINS.NS, REIAGRO ETC. ARE NOT PRESENT
RASOYPR.BO Rasoya Proteins Limited Bombay
RASOYPR-EQ.NS RASOYA PROTEINS LI INR1 NSE
RASOYPR.NS Rasoya Proteins Limited NSE
The name isn’t equal to Yahoo notifications…
Hi samir….
Thanks for the work you did. I tried it for Australian stocks, but there are many missing tickers. If you want to update, a full list from ASX is here
http://www.asx.com.au/asx/research/ASXListedCompanies.csv
Hey Mark,
how did you find this list of ticker numbers and is it possible to find it for exhanges other than the Australian one (NYSE etc.)
Thanks
Hi Samir
Did you search only for 5 digits? I guess thats the reason why you dont get all symbols and also the reason why you need only 1 day 😉
I’ve tried it with 6 digits and i takes really long (only 1 server/ip)…but I think it should be 7 to get really all symbols (there are some with 10 chararcters – 7 for the symbol 1 dot and 2 for the exchDisp)
Just my suggestions for this topic 🙂
Best luck,
Mike
Hi Samir
any chance of a version with JSE data?
Thank you Sir
Hi Samir,
Thanks for a great piece of work that I needed to work on analysis comparisons . I tried copy pasted all the tickers by alphabets to the tickers per worksheet and run . Each time the Failed list is about 20-30
per 150-200 tickers ; and about 200+ if each ticker list is about 1000. On repeat runs of same tickers, the Failed list is about the same number with some differences on failed & success tickers. Is there a solution to reduce Failed list or am I doing it wrongly by copy & paste ticker list or is run size too big for what Yahoo allows.
Tickers with the colon : are also rejected as active worksheet names cannot contain colon . Any workarounds?
Hi Khan,
great work! How is it with dividend or stock split adjustment? I need not only the chart I the total return of the stocks(Dividend adjustment, preferred rights, stock splits etc.) Can I do this with Yahoo! Finance?
Kind regards,
Hi Samir,
I am having trouble finding Japanese companies, and their stock tickers. do you have any understandings regarding these tickers?
Thanks!
this is wonderful, Samir.
does anyone know where to find a lookup table of the 3-letter exchange codes yahoo is using? for example, like FRA, PNK etc. ?
thanks.
Samir,
Can you pull a fresh list of yahoo stock tickers? I’d be happy to add a link to your site in my blog.
Refreshing the ticker list takes four days 🙂 If you link first, then I’ll start work 🙂
Samir,
great work!
I don’t know if it is practical but I am in the UK investing in funds on the LSE so I could run this on my home server for LSE once a week or month or possibly one exchange a week/month.
There’s your link —> http://www.stockrockandroll.com/blog/investing-2/it-is-time-to-start-averaging-into-oil-stocks/
Looking forward to that fresh ticker list 😉
This is absolutely amazing!
I think you should receive donations and think to upload it at monthly frequency.
Hi Samir,
Great work by you. I found this after a lot of search. The following doesn’t take away anything from my sincere appreciation for your work.
However, the list only has appx 500 tickers for BSE and nothing for NSE (national stock exchange).
I know BSE has over 3000 listed stocks and NSE about 1500
Is this all there is in yahoo.?
I will be using a stock trading software called Amibroker. I need BSE and NSE code list which will be updated through yahoo or google finance and I need a few index data in txt file as needed.
I can pay for this data if needed. You can also write directly to me.
Thanks
Dear Samir, thanks, thanks, thanks!!! The excel list was very helpful indeed. Of course, with 2016 approaching really looking forward to a newly refreshed list as I’m sure so if everyone else here 🙂
For people trying to connect exchange symbols to a particular country, some help from internet here (might not be 100% accurate!):
BUE Argentina
ASX Australia
NCM Australia
SHH Australia
VIE Austria
EBS Austria
BRU Belgium
SAO Brazil
VAN Canada
PAR France
BER Germany
DUS Germany
FRA Germany
HAM Germany
HAN Germany
MUN Germany
STU Germany
CBT Germany
EUX Germany
ATH Greece
HKG Hong Kong
MCX India
JKT Indonesia
VTX International
MIL Italy
TOR Italy
TLV Izrael
KSC Korea
KLS Malaysia
MEX Mexico
AMS Netherlands
NZE New Zealand
OSL Norway
LIS Portugal
BSE Romania
SES Singapore
MAD Spain
MCE Spain
NGM Sweeden
STO Sweeden
TAI Taiwan
TWO Taiwan
BTS Thailand
ISE UK
IOB UK
LSE UK
ASE USA
NAS USA
NMS USA
OBB USA
PCX USA
CPH Denmark
GER Germany
I’m currently preparing a new list for January 2016. Check back in a few days.
Hi Samir,
First of AMAZING work, this is beyond awesome. I wanted to ask you if you can add a “Sector” column with the top level sector. Finviz is a good example, they have 9 Sectors.
I will gladly donate to your site if we can achieve this.
Thanks in advance,
Love this data. Any update for the new year?
I’m preparing a fresh update. Check back in a few days…
New update available for January 2016
Hi Samir, grey work! Any updates planned for Dec 2016/Jan 2017? Thanks.
Yahoo are not playing well with my scraping code. I’ll need to looking into this before an update is released
New update FINALLY posted for September 2017. Yayyy!!
This is the best! Would love to see an update!
I might post an update soon
Great contribution to the community ! I have used your codes to download Yahoo finance historical prices for select stocks . But I am unable to trace any of the unit trusts distributed in Singapore which are listed in MorningStar Singapore’s website for onshore and offshore names. (onshore link below) to your list.
http://sg.morningstar.com/ap/fundselect/results.aspx?onshore=1
I need urgently to find the tickers (yahoo or Google) for these unit trusts to get historical prices. Any help is deeply appreciated !
Any updates for the 2017 year?
September 2017 update posted
Hi Samir, could you post the updated list please.
Appreciate your work and help on this.
Thanks
Hi Samir,
Why are none of the NYSE stocks included in the Yahoo ticker list?
Thanks!
Regan
Do you have any updates ?
I’ve uploaded a new, freshly scraped spreadsheet for September 2017
Hi,
Is there an easy way to convert Yahoo tickers to Google tickers pls?
Samir Khan, Great efforts but i checked randomly for Argentina tickers non of the data is available. I think your list is old or those symbols are eliminated by Yahoo.