5

A List of All Yahoo Finance Stock Tickers

Get the complete list of Yahoo stock ticker symbols in an Excel spreadsheet – over 58000 ticker symbols for stocks, ETFs, mutual funds 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).

This Excel spreadsheet was compiled in November 2013.  It is broken down into six sheets, one each for

  • stocks (14935 tickers)
  • ETFs (9683 tickers)
  • futures (13232 tickers)
  • indices (11860 tickers)
  • mutual funds (4919 tickers)
  • currency pairs (3613 tickers)

That’s 58242 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 for stocks, the 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.

Here’s the data in an embedded Google doc, but the download link for the Excel spreadsheet is at the bottom of this post.

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)
  • and many others

Download Excel Spreadsheet with Complete List of Yahoo Stock Ticker Symbols


5 Responses to "A List of All Yahoo Finance Stock Tickers"

  1. Louis says:

    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

  2. Louis says:

    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

    • Samir Khan says:

      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)

  3. David says:

    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

Leave a Reply

Submit Comment
What is 15 + 14 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)
© 2014 Invest Excel. All rights reserved. XHTML / CSS Valid.

Facebook