Mapping US Equities to CTA and UTP Tapes

# Quick way to check what 'tape' a stock belongs to?


# Quick way to check what 'tape' a stock belongs to?












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?

## Answer by Louis Marascio (score 11, accepted)

https://quant.stackexchange.com/a/7332

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.

## Answer by chrisaycock (score 8)

https://quant.stackexchange.com/a/7331

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.

## Answer by LazyCat (score 1)

https://quant.stackexchange.com/a/7330

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)

## Answer by Quinton Pike (score 0)

https://quant.stackexchange.com/a/41741

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

## Answer by Watt (score 0)

https://quant.stackexchange.com/a/57063

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.