Common stock list for NASDAQ / NYSE

Discussion in 'Data Sets and Feeds' started by rx2, Mar 5, 2012.

  1. rx2

    rx2

    Hi,

    Does anyone know where I can get a list of all common stock traded on the NYSE, NASDAQ and AMEX?

    I thought this would be a simple exercise but is proving to be a little tricky.

    Thanks in advance.

    Robert
     
  2. d08

    d08

    Nothing tricky about it. Google "stock screener".
     
  3. rx2

    rx2

    Your right d08 - After some more Googling I have found something @ http://www.nasdaq.com/reference/StockScreener.stm

    However, when I looked before the stock screeners returned all tradables for an exchange i.e. ETF etc. Based on a quick look it likes the NASDAQ stock screener only returns common stocks for NYSE/AMEX/NASDAQ.
     
  4. rx2

    rx2

    Just a follow up - does anyone know of a service that provides a list of delisted common stocks from 2000 onwards?
     
  5. rmorse

    rmorse ET Sponsor

  6. guest2

    guest2

    All current nyse/arca/amex/nasdaq tickers are available here:

    ftp://ftp.nasdaqtrader.com/SymbolDirectory/

    NASDAQ: ftp://ftp.nasdaqtrader.com/SymbolDirectory/nasdaqlisted.txt

    NYSE/Arca/AMEX: ftp://ftp.nasdaqtrader.com/SymbolDirectory/otherlisted.txt

    Lists are updating everyday. I wrote a php script to update my DB:

    PHP:
    <?php

    include("/home/david/MyData/config.php");

    function 
    market_category($mkt_cat) {
        switch(
    strtoupper($mkt_cat)) {
            case 
    'A': return 'AMEX';
            case 
    'N': return 'NYSE';
            case 
    'P': return 'NYSEArca';
            case 
    'S': return 'NASDAQ-CM';
            case 
    'Q': return 'NASDAQ-GS';
            case 
    'G': return 'NASDAQ-GM';
            case 
    'W': return 'CBOE';
            case 
    'Z': return 'BATS';
            default: return 
    'Undef';
        }
    }

    $nasdaq file(URL_NASDAQ_SYMBOLSFILE_IGNORE_NEW_LINES FILE_SKIP_EMPTY_LINES);
    $other file(URL_OTHER_SYMBOLSFILE_IGNORE_NEW_LINES FILE_SKIP_EMPTY_LINES);

    if(!
    is_array($nasdaq) || !is_array($other) || empty($nasdaq) || empty($other)) {
     
    error_log("[SymbolsUpdate:".$date."] Error: cannot fetch symbols\n"3LOG_FILE);
     die();
    }

    array_shift($nasdaq);
    array_shift($other);
    array_pop($nasdaq);
    array_pop($other);

    foreach(
    $other as $line) {
        list(
    $symbol$security_name$market_category$cqs_symbol$etf$round_lot_size$test_issue$nasdaq_symbol) = explode('|'$line);
        
    $current_tickers[$symbol] = array($security_namemarket_category($market_category));
    }
    foreach(
    $nasdaq as $line) {
        list(
    $symbol$security_name$market_category$test_issue$financial_status$round_lot_size) = explode('|'$line);
        
    $current_tickers[$symbol] = array($security_namemarket_category($market_category));
    }


    ...[..do 
    whatever u want with arrays......]
    ?> 
    Delisted symbols might be found here:
    Code:
    ftp://sampledata:datacap@ftp2.nyxdata.com
    but u need a NYXData account or brute-force some of existing logins:
    Code:
    AndreiBezdedeanu
    mlportfolio
    jeremy
    mlpnyse
    scott_redstone
    mlportfolio
    sacquant
    nysesupport
    EFT
    stuartabrahams
    nyse_ftp_acct
    pellet
    lavatrading
    sacquant
    MatthewStickley
    
    [...i ve got a full list]
    
    Using Google u can find everything but u must learn how to search. It takes time.
    greetings
    david
     
  7. Bob111

    Bob111

    RIP QP2..they use have all that info

    guest2-Thank you links!