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?
5 Answers
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.
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.
-
$\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
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)
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
-
$\begingroup$ That URL is out of date, the new URLs are oatsreportable.finra.org/OATSReportableSecurities-SOD.txt and oatsreportable.finra.org/OATSReportableSecurities-EOD.txt from finra.org/filing-reporting/oats/oats-reportable-securities-list $\endgroup$– crowCommented Oct 27, 2019 at 19:40
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.