11
$\begingroup$

For the SIP feeds, there is the CTA and the UTP plan and they cover Tapes A,B and Tape C respectively. Is there an easy way to check on google what tape a stock would belong to? Particularly when it comes to disambiguating A and B?

$\endgroup$

5 Answers 5

11
$\begingroup$

You can pull a list of all stocks easily. See this question. You can get nasdaqlisted.txt and otherlisted.txt from here. nasdaqlisted.txt is clearly Tape C. otherlisted.txt contains an Exchange column which can be used to determine Tape A or B. If it is N it's listed at NYSE and therefore Tape A, otherwise it's Tape B.

Also, NYSE publishes a symbol list these days as well. FTP to ftp.nyxdata.com and look at the NYSESymbolMapping and ARCASymbolMapping directories.

$\endgroup$
0
8
$\begingroup$

Tape A is NYSE-listed stocks. Tape C is NASDAQ-listed stocks. Tape B is the regionals, ie. everything else. Most of Tape B is on ARCA now days, though some of it is still on the NYSE MKT, formerly known as AMEX.

If you want to use Google Finance, just note that they prepend every symbol with the exchange its on. For example, if I search for "AAPL", Google will change this to "NASDAQ:AAPL" automatically, which means its on Tape C. Likewise, "SPY" becomes "NYSEARCA:SPY" (Tape B) and "BAC" becomes "NYSE:BAC" (Tape A).

A fun fact: most of ARCA's products are exchange-traded funds (ETFs), and most ETFs are listed on ARCA. So ETFs and Tape B have become synonymous. (A glaring exception is that QQQ is listed on NASDAQ.)

Also, up until a few years ago, all NYSE-listed symbols had three or fewer letters, while all NASDAQ-listed symbols had exactly four characters. This has changed recently and now all exchanges allow any symbology (to poach competitors' listings), but the trend is still pretty common.

$\endgroup$
2
  • $\begingroup$ Thanks for all that info! I'm a bit confused when something like NYSEARCA is not NYSE-listed..or you say "Most of Tape B is on ARCA nowadays, though some of it is still on the NYSE MKT" - if it's on the NYSE MKT wouldn't it be Tape A? $\endgroup$ Commented Feb 21, 2013 at 16:54
  • 1
    $\begingroup$ @PalaceChan ARCA isn't NYSE. It's owned by NYSE, and hence why it's called "NYSE ARCA". But it isn't NYSE. Likewise, "NYSE MKT" is not NYSE; it's the former AMEX and is merely owned by NYSE. Only NYSE proper is tape A. Anything that isn't NYSE or NASDAQ specifically is tape B, even if those exchanges are owned by NYSE. $\endgroup$ Commented Feb 21, 2013 at 17:17
1
$\begingroup$

As far as I know, Tape A, if it's a NYSE proper stock, Tape C, if listed on NASDAQ, else Tape B (e.g. including those, which finance.google.com shows as NYSEARCA)

$\endgroup$
0
$\begingroup$

FINRA also has a list of symbols with their related exchanges. It's updated twice a day and includes OTC symbols.

http://www.finra.org/industry/oats/oats-reportable-securities-list

$\endgroup$
1
0
$\begingroup$

Try this API endpoint to lookup tickers https://rapidapi.com/logicione/api/stock-ticker-security-and-company-search-database?endpoint=apiendpoint_aac710aa-f501-497e-8cc7-8c552d40f955

For AAPL it returns:

{
"security_name":"Apple Inc. - Common Stock",
"ticker":"AAPL",
"exchange":"NASDAQ",
"financial_status":"Normal"
}

For BA it returns:

{
 "security_name": "Boeing Company (The) Common Stock", 
 "ticker": "BA", 
 "exchange": "NYSE" 
}

Using "exchange" value, you can figure out Tape. If exchange="NYSE" then Tape A, otherwise Tape B.

p.s. the API is free for 50 calls per day.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.