How to get a complete list of ticker symbols from Yahoo Finance

Question

I ve googled endlessly for a method of getting a complete  and daily updated  list of all Yahoo ticker symbols available through http   finance yahoo com  Yahoo has information for stocks  futures etc for a lot of exchanges worldwide  and I d like a combined list of all the ticker symbols available through them  I ve tried YQL but they have a  where symbol    or in   clause restriction so I cannot select   from symbols   So basically  getting detailed information for a single symbol or several symbols at one time is easy but I just can t seem to find out how to get a list of all available tickers   Can anyone help  please

User · Answer

I managed to do something similar by using this URL:

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.industry%20where%20id%20in%20(select%20industry.id%20from%20yahoo.finance.sectors)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

It downloads a complete list of stock symbols using the Yahoo YQL API, including the stock name, stock symbol, and industry ID. What it doesn't seem to have is any sort of stock symbol modifiers. E.g. for Rogers Communications Inc, it only downloads RCI, not RCI-A.TO, RCI-B.TO, etc. I haven't found a source for that information yet - if anyone knows of a way to automate downloading that, I'd like to hear it. Also, it'd be nice to find a way to download some sort of relation between the stock symbol and the exchange it's traded on, since some are traded on multiple exchanges, or maybe I only want to look at stuff on the TSX or something.

User · Answer

NASDAQ Stock lists ftp   ftp nasdaqtrader com symboldirectory  The 2 files nasdaqlisted txt and otherlisted txt are   pipe separated   That should give you a good list of all stocks

User · Answer

Complete list of yahoo symbols tickers stocks is available for download excel format   at below website  http   www myinvestorshub com yahoo stock list php   List updated to january 2016  http   investexcel net all-yahoo-finance-stock-tickers

User · Answer

There is a nice C  wrapper for the Yahoo Finance API at http   code google com p yahoo-finance-managed  that will get you there  Unfortunately there is no direct way to download the ticker list but the following creates the list by iterating through the alphabetical groups           AlphabeticIDIndexDownload dl1   new AlphabeticIDIndexDownload            dl1 Settings TopIndex   null          Response lt AlphabeticIDIndexResult gt  resp1   dl1 Download             writeStream WriteLine  Id Isin Name Exchange Type Industry             foreach  var alphabeticalIndex in resp1 Result Items                        AlphabeticalTopIndex topIndex    AlphabeticalTopIndex  alphabeticalIndex              dl1 Settings TopIndex   topIndex              Response lt AlphabeticIDIndexResult gt  resp2   dl1 Download                 foreach  var index in resp2 Result Items                                IDSearchDownload dl2   new IDSearchDownload                    Response lt IDSearchResult gt  resp3   dl2 Download index                     int i   0                  foreach  var item in resp3 Result Items                                        writeStream WriteLine item ID         item ISIN         item Name         item Exchange         item Type         item Industry                                                It gave me a list of about 75 000 securities in about 4 mins

User · Answer

I have been researching this for a few days  following endless leads that got close  but not quite  to what I was after   My need is for a simple list of  symbol  sector  industry   I m working in Java and don t want to use any platform native code    It seems that most other data  like quotes  etc   is readily available   Finally  followed a suggestion to look at  finviz com   Looks like just the ticket  Try using the following   http   finviz com export ashx v 111 amp t aapl cat amp o ticker This comes back as lines  csv style  with a header row  ordered by ticker symbol  You can keep adding tickers  In code  you can read the stream  Or you can let the browser ask you whether to open or save the file   http   finviz com export ashx v 111 amp  amp o ticker Same csv style  but pulls all available symbols  a lot  across global exchanges   Replace  export  with  screener  and the data will show up in the browser   There are many more options you can use  one for every screener element on the site   So far  this is the most powerful and convenient programmatic way to get the few pieces of data I couldn t otherwise seem to easily get  And  it looks like this site could well be a single source for most of what you might need other than real- or near-real-time quotes

User · Answer

i had a similar problem   yahoo doesn t offer it  but you can get one by looking through the document write statements on nyse com s list and finding the  js file where they just happen to store the list of companies starting with the given letter as a js array literal   you can also get nice tidy csv files from nasdaq com here  http   www nasdaq com screening companies-by-name aspx letter 0 amp exchange nasdaq amp render download  replace exchange nasdaq with exchange nyse for nyse symbols

User · Answer

I had same problem  but I think I have simple solution code is from my RoR app   Extract industry ids from yahoo finance sectors and add it to db       select    select   from yahoo finance sectors      generate query select      data each do  data        data  industry   each do  ind          unless ind kind of  Array            unless ind  id   nil              id   ind  id   to i             if id  gt  0               Industry where id  id  first or create name  ind  name    update attribute  name  ind  name                end           end         end       end     end   Extract all comanies with their symbols with industry ids       ids   Industry all map  ind      ind id to s      join          select    select   from yahoo finance industry where id in      generate query select  ids      data each do  ts        unless ts kind of  Array     ts  company   nil          if ts  company   count    2  amp  amp  ts  company   first 0      name            t   ts  company             Ticket find or create by symbol symbol  t  symbol    name  t  name     update attribute  name  t  name            else           ts  company   each do  t              Ticket find or create by symbol symbol  t  symbol    name  t  name     update attribute  name  t  name              end         end       end     end   end   Connection hellper   def generate query select  ids   nil      if params  form     params  action      sectors     params  controller      tickets        if params  action      sectors     params  controller      tickets          if ids nil            query  select         else           query     select     ids            end       else         if params  form   ids             conditions   params parse params  form   ids            query      select      conditions            end       end       yql execut query      end   end    def yql execut query        TODO  OAuth ACCESS  http   developer yahoo com yql guide authorization html      base url    http   query yahooapis com v1 public yql  amp format json amp env store 3A 2F 2Fdatatables org 2Falltableswithkeys amp q       dirty data   JSON parse HTTParty get base url    URI encode query   body      if dirty data  query    results      nil        data   count   table head   nil     else        data   dirty data  query    results   to a 0  1  to a        count   dirty data  query    count         if  count    1          table head    data map  h  h 0  capitalize        else          table head    data to a first to a map  h  h 0  capitalize        end     end   end   Sorry for mess  but this is first testing version for my project and I needed it very fast  There are some helpers variabels and other things for my app  sorry for it  But I have question  Have many symbols do you have  I have 5500

User · Answer

I may be able to help with a list of ticker symbols for  U S  and non-U S   stocks and for ETFs   Yahoo provides an Earnings Calendar that lists all the stocks that announce  earnings for a given day   This includes non-US stocks   For example  here is today s  http   biz yahoo com research earncal 20120710 html  the last part of the URL is the date  in YYYYMMDD format  for which you want the  Earnings Calendar   You can loop through several days and scrape the Symbols  of all stocks that reported earnings on those days   There is no guarantee that yahoo has data for all stocks that report earnings  especially since some stocks no longer exist  bankruptcy  acquisition  etc    but this is probably a decent starting point   If you are familiar with R  you can use the  qmao package to do this    See this post  if you have trouble installing it   ec  lt - getEarningsCalendar from  2011-01-01   to  2012-07-01    this may take a while s  lt - unique ec Symbol  length s    1  12223 head s  20   look at the first 20 Symbols    1   CVGW      ANGO      CAMP      LNDC      MOS       NEOG      SONC        8   TISI      SHLM      FDO       FC        JPST PK   RECN      RELL       15   RT        UNF       WOR       WSCI      ZEP       AEHR       This will not include any ETFs  futures  options  bonds  forex or mutual funds   You can get a list of ETFs from yahoo here  http   finance yahoo com etf browser mkt That only shows the first 20   You need the URL of the  Show All  link at the  bottom of that page   You can scrape the page to find out how many  ETFs there are  then construct a URL   L  lt - readLines  http   finance yahoo com etf browser mkt     Sorry for the ugly regex n  lt - gsub      w    s            1              gsub       Showing 1 - 20 of            3                    L grep  Showing 1 - 20   L     URL  lt - paste0  http   finance yahoo com etf browser mkt c 0 amp k 5 amp f 0 amp o d amp cs 1 amp ce    n   http   finance yahoo com etf browser mkt c 0 amp k 5 amp f 0 amp o d amp cs 1 amp ce 1442   Now  you can extract the Tickers from the table on that page  library XML  tbl  lt - readHTMLTable URL  stringsAsFactors FALSE  dat  lt - tbl  tail grep  Ticker   tbl   1    -1    colnames dat   lt - dat 1    dat  lt - dat -1    etfs  lt - dat Ticker   All ETF tickers from yahoo length etfs    1  1442 head etfs    1   DGAZ   TAGS   GASX   KOLD   DWTI   RTSA    That s about all the help I can offer  but you could do something similar to get some of the futures they offer by scraping these pages   These are only U S  futures   http   finance yahoo com indices e futures  http   finance yahoo com futures t energy  http   finance yahoo com futures t metals  http   finance yahoo com futures t grains  http   finance yahoo com futures t livestock  http   finance yahoo com futures t softs  http   finance yahoo com futures t indices   And  for U S  and non-U S  indices  you could scrape these pages  http   finance yahoo com intlindices e americas  http   finance yahoo com intlindices e asia  http   finance yahoo com intlindices e europe  http   finance yahoo com intlindices e africa  http   finance yahoo com indices e dow jones  http   finance yahoo com indices e new york  http   finance yahoo com indices e nasdaq  http   finance yahoo com indices e sp  http   finance yahoo com indices e other  http   finance yahoo com indices e treasury  http   finance yahoo com indices e commodities

User · Answer

One workaround I had for this was to iterate over the sectors which at the time you could do   I haven t tested that recently      You wind up getting blocked eventually when you do it that way though  since YQL gets throttled per day     Use the CSV API whenever possible to avoid this

[yahoo-finance] How to get a complete list of ticker symbols from Yahoo Finance?

Examples related to yahoo-finance

Examples related to stocks