A List of All Yahoo Finance Stock Tickers

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.

Complete list of Yahoo Stock Symbols in an Excel spreadsheet

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.

Market capilization of Exxon Mobil in Excel

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


72 thoughts on “A List of All Yahoo Finance Stock Tickers”

  1. 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

    Reply
      • 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.

        Reply
  2. 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

    Reply
    • 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)

      Reply
      • 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

        Reply
  3. 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

    Reply
  4. 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

    Reply
  5. 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.

    Reply
  6. 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.

    Reply
  7. 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

    Reply
  8. 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!

    Reply
  9. 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.

    Reply
  10. 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!

    Reply
    • 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…

      Reply
    • 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

      Reply
  11. 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

    Reply
  12. 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?

    Reply
  13. 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,

    Reply
  14. Hi Samir,
    I am having trouble finding Japanese companies, and their stock tickers. do you have any understandings regarding these tickers?

    Thanks!

    Reply
  15. 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.

    Reply
  16. 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.

    Reply
  17. 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

    Reply
  18. 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

    Reply
  19. 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,

    Reply
  20. 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 !

    Reply
  21. 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.

    Reply

Leave a Comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.