Common stock list for NASDAQ / NYSE

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

 

Nothing tricky about it. Google "stock screener".

 

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.

 

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

 

You can download the list here:

http://www.nasdaq.com/screening/company-list.aspx

 

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_SYMBOLS, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
$other = file(URL_OTHER_SYMBOLS, FILE_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", 3, LOG_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_name, market_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_name, market_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

 

RIP QP2..they use have all that info

guest2-Thank you links!