Finance Reference

NASDAQ-Listed Securities
File Name:	nasdaqlisted.txt
FTP Directory:

Field Name	Definition
Symbol	The one to four or five character identifier for each NASDAQ-listed security.
Security Name	Company issuing the security.
Market Category	The category assigned to the issue by NASDAQ based on Listing Requirements. Values:
Q = NASDAQ Global Select MarketSM
G = NASDAQ Global MarketSM
S = NASDAQ Capital Market

Test Issue	Indicates whether or not the security is a test security. Values: Y = yes, it is a test issue. N = no, it is not a test issue.
Financial Status	Indicates when an issuer has failed to submit its regulatory filings on a timely basis, has failed to meet NASDAQ's continuing listing standards, and/or has filed for bankruptcy. Values include:
D = Deficient: Issuer Failed to Meet NASDAQ Continued Listing Requirements
E = Delinquent: Issuer Missed Regulatory Filing Deadline
Q = Bankrupt: Issuer Has Filed for Bankruptcy
N = Normal (Default): Issuer Is NOT Deficient, Delinquent, or Bankrupt.
G = Deficient and Bankrupt
H = Deficient and Delinquent
J = Delinquent and Bankrupt
K = Deficient, Delinquent, and Bankrupt
Round Lot	Indicates the number of shares that make up a round lot for the given security.
File Creation Time:	The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: 1217200717:03\|\|\|\|\|
Other Exchange-Listed Securities
File Name:	otherlisted.txt
FTP Directory:

Field Name	Definition
ACT Symbol	Identifier for each security used in ACT and CTCI connectivity protocol. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.
Field Name Change effective 2/12/2010
Security Name	The name of the security including additional information, if applicable. Examples are security type (common stock, preferred stock, etc.) or class (class A or B, etc.). Allow up to 255 characters.
Exchange	The listing stock exchange or market of a security.
Allowed values are:
A = NYSE MKT
N = New York Stock Exchange (NYSE)
P = NYSE ARCA
Z = BATS Global Markets (BATS)
V = Investors' Exchange, LLC (IEXG)
CQS Symbol	Identifier of the security used to disseminate data via the SIAC Consolidated Quotation System (CQS) and Consolidated Tape System (CTS) data feeds. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.

ETF	Identifies whether the security is an exchange traded fund (ETF). Possible values:
Y = Yes, security is an ETF
N = No, security is not an ETF
For new ETFs added to the file, the ETF field for the record will be updated to a value of "Y".
Round Lot Size	Indicates the number of shares that make up a round lot for the given security. Allow up to 6 digits.
Test Issue	Indicates whether the security is a test security.
Y = Yes, it is a test issue.
N = No, it is not a test issue.
NASDAQ Symbol	Identifier of the security used to in various NASDAQ connectivity protocols and NASDAQ market data feeds. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.
New field effective 2/12/2010

File Creation Time:	The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03\|\|\|\|\|\|
Market Participants
File Name:	mpidlist.txt
FTP Directory:

Field Name	Definition
MPID	The identifier for each market participant. In cases where a Market-Making firm trades a security from a location other than its main trading location, a fifth-letter may be appended to the Market Makers identifier for that security. Each Market Maker is free to use any letter to designate a specific branch location as desired.
MP Type	There are several types of NASDAQ participants. Listed below are the characters used with its corresponding market participant type.
A = Agency Quote
C = Electronic Communications Network (ECN)
E = Exchange
M = Market Maker
N = Miscellaneous
O = Order Entry Firm
P = NASDAQ Participant
Q = Query Only Firm
S = Specialist
Name	The firm name of the Market Participant.
Location	The geographic location or the trading desk(s) name of the firm.
Phone Number	The telephone number of the geographic location or trading desk of the firm.
NASDAQ Member	Indicates whether a Market Participant is a member of the NASDAQ Exchange. Possible values are:
Y = Yes, MP is a NASDAQ exchange member
N = No, MP is not a NASDAQ exchange member
FINRA Member	Indicates whether a Market Participant is a member of the Financial Regulatory Authority (FINRA)
Y = Yes, MP is a FINRA member
N = No, MP is not a FINRA member
NASDAQ BX Member *	Indicates whether a Market Participant is currently a member of the Boston Stock Exchange (BSE) or a market participant on the former BSE equity trading platform. It is expected that such Market Participants will continue to have trading rights on a NASDAQ BX equity trading platform.
Y = Yes, MP is a NASDAQ BX member
N = No, MP is not a NASDAQ BX member

PSX Participant	Indicates whether a MP is currently a member of NASDAQ PHLXSM (PHLX00ae) and eligible to trade on PSX..
Y = Yes, MP is a PHLX member, eligible to trade on PSX
N = No, MP is not eligible to trade PSX
Initially, this field will be populated with the value of 201cN201d. Additional notification may occur when this field will begin populating with the value of 201cY201d.

File Creation Time:	The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03\|\|\|\|\|\| .
Mutual Funds
File Name:	mfundslist.txt
FTP Directory:

Data Field	Definition
Fund Symbol	The identifier for each mutual fund or money market.
Fund Name	The name of each mutual fund or money market.
Fund Family Name	The Name of the Fund Company that is responsible for the fund.
Type	A code used to provide the type of fund.
The allowed values are:
AN = Annuities
MF = Mutual Fund
MS = Supplemantal Mutual Fund
$$ = Money Market Fund
$S = Supplemental Money Market Fund
SP = Structured Products
US = UIT Supplemental List
UT = UIT News Media List
Category	The subcategory of the fund type.
The allowed values are:
For Annuities (AN):
M = Variable
N = Equity Indexed
For Mutual Fund (MF)
O = Open-end
C = Closed-end
For Money Fund (MS)
A = General Purpose
G = Govt. Securities
X = Tax-Exempt
For Structured Products (SP)
R = Access Transaction
S = Tax Driven Structure
T = Buffered Note
U = Principal Protected Note
V = Levered Note
W = Enhanced Income Note
For Unit Investment Trust (US or UT)
E = Equity
F = Not Used/Reserved
D = Fixed Income
Pricing Agent	The firm responsible for the pricing of the fund.
File Creation Time	The last row of each Symbol Directory text file contains a timestamp that reports the File Creation time for the corresponding file. This timestamp can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03\|\|\|\|\|.
PBOT Futures
File Name:	pbot.csv
FTP Directory:

Field Name	Definition
Commodity ID	3-character symbol identifying given product, common for all series of this product.
PBOT Product Symbol	The identifier for this particular series of the product, consists of the 3-character commodity ID + 2-character code identifying expiration date for the given series.
PBOT Product Description	The name of the given PBOT Product.
Last Trade Date	The last business day on which trading can occur for the given series, in yyyymmdd format. Depending on the product type, this day may be the same as the expiration day or the last business day before the expiration day.
Expiration Date	The date on which the given series for the PBOT product and the right to exercise it cease to exist, in yyyymmdd format.
NASDAQ Options Market
File Name:	options.txt
FTP Directory:


The list includes options traded on the NASDAQ Options Market.

Data Field	Definition
Root Symbol	Root 1-6 character identifier for options with the same underlying security.
Options Closing Type	Allowed Values:
N - Normal Hours
L - Late Hours
Options Type	Allowed Values:
P - Put
C - Call
Expiration Date	Format – mm/dd/yyyy
Explicit Strike Price	The specific price which the contract may be exercised, or acted on.
Underlying Symbol	Denotes the unique symbol assigned to the underlying security within NASDAQ Options Market System
Underlying Issue Name	The Company Name of the Issuer. In many cases, this field contains a description of the Issue, such as the Class or the Annual Percentage Rate of an Issue.
Pending	Indicates whether the options is currently trading on the NASDAQ Options Market or is in a pending state and will begin trading on the next trading day.
Y - Pending Status, the specific option will be added for trading prior to system startup on the next trading day.
N - Currently trading on the NASDAQ Options Market
File Creation Time	The last row of each Symbol Directory text file contains a timestamp that reports the File Creation time for the corresponding file. This timestamp can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03\|\|\|\| .
NASDAQ PHLX Equity Options
File Name:	phlxoptions.csv
FTP Directory:

Field Name	Definition
Company	Name of company issuing the security.
Cycle	This is one of the existing expiration cycles for equity options. All Equity Options products are divided into three expiration cycles where the new far-off expiration dates are picked from the first, second or third months of a quarter, called JAN, FEB and MAR, respectively. For all non-equity Options (Indexes, ETFs etc.), the OTH ("Other") expiration cycle is assigned.
Option Symbol	Root 1-6 character identifier for options with the same underlying security.
Stock Symbol	The identifier for each security (such as Equity, Index, ETF, etc) to which the given options security is based on. Identifiers are typically 1-5 characters.
Specialist Unit	Name of the trading company acting as the Specialist for this product at NASDAQ PHLX
NASDAQ PHLX Options Strike Prices
File Name:	phlxstrikes.zip
FTP Directory:

Field Name	Definition
Symbol	Root symbol of the option.
Equity Underlying	Stock symbol of the primary security that underlies the option.
Phlx Underlying	PHLX symbol of the security that underlies the option.
Maturity Year	Year portion of the option's expiration/maturity date.
Maturity Month	Month portion of the option's expiration/maturity date.
Maturity Day	Day portion of the option's expiration/maturity date.
CFI Code	Financial instrument code.
Values:
OC = Call
OP=Put
Strike Price Dollar	Dollar portion of the option's strike price.
Strike Price Decimal	Decimal portion of the option's strike price.
Put Or Call	Identifies whether the option is a put or call. Values:
C = Call
P = Put
Month Code	OPRA Code for the option's expiration
Field will be removed effective 2/15/2010.
Strike Code	OPRA code for the option's expiration price.
Field will be removed effective 2/15/2010.

File Name:

nasdaqlisted.txt

FTP Directory:

Field Name

Definition

Symbol

The one to four or five character identifier for each NASDAQ-listed security.

Security Name

Company issuing the security.

Market Category

The category assigned to the issue by NASDAQ based on Listing Requirements. Values:

Q = NASDAQ Global Select MarketSM

G = NASDAQ Global MarketSM

S = NASDAQ Capital Market

Test Issue

Indicates whether or not the security is a test security. Values: Y = yes, it is a test issue. N = no, it is not a test issue.

Financial Status

Indicates when an issuer has failed to submit its regulatory filings on a timely basis, has failed to meet NASDAQ's continuing listing standards, and/or has filed for bankruptcy. Values include:

D = Deficient: Issuer Failed to Meet NASDAQ Continued Listing Requirements

E = Delinquent: Issuer Missed Regulatory Filing Deadline

Q = Bankrupt: Issuer Has Filed for Bankruptcy

N = Normal (Default): Issuer Is NOT Deficient, Delinquent, or Bankrupt.

G = Deficient and Bankrupt

H = Deficient and Delinquent

J = Delinquent and Bankrupt

K = Deficient, Delinquent, and Bankrupt

Round Lot

Indicates the number of shares that make up a round lot for the given security.

File Creation Time:

The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: 1217200717:03|||||

Other Exchange-Listed Securities

File Name:

otherlisted.txt

FTP Directory:

Field Name

Definition

ACT Symbol

Identifier for each security used in ACT and CTCI connectivity protocol. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.

Field Name Change effective 2/12/2010

Security Name

The name of the security including additional information, if applicable. Examples are security type (common stock, preferred stock, etc.) or class (class A or B, etc.). Allow up to 255 characters.

Exchange

The listing stock exchange or market of a security.

Allowed values are:

A = NYSE MKT

N = New York Stock Exchange (NYSE)

P = NYSE ARCA

Z = BATS Global Markets (BATS)

V = Investors' Exchange, LLC (IEXG)

CQS Symbol

Identifier of the security used to disseminate data via the SIAC Consolidated Quotation System (CQS) and Consolidated Tape System (CTS) data feeds. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.

ETF

Identifies whether the security is an exchange traded fund (ETF). Possible values:

Y = Yes, security is an ETF

N = No, security is not an ETF

For new ETFs added to the file, the ETF field for the record will be updated to a value of "Y".

Round Lot Size

Indicates the number of shares that make up a round lot for the given security. Allow up to 6 digits.

Test Issue

Indicates whether the security is a test security.

Y = Yes, it is a test issue.

N = No, it is not a test issue.

NASDAQ Symbol

Identifier of the security used to in various NASDAQ connectivity protocols and NASDAQ market data feeds. Typical identifiers have 1-5 character root symbol and then 1-3 characters for suffixes. Allow up to 14 characters.

New field effective 2/12/2010

File Creation Time:

The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03||||||

Market Participants

File Name:

mpidlist.txt

FTP Directory:

Field Name

Definition

MPID

The identifier for each market participant. In cases where a Market-Making firm trades a security from a location other than its main trading location, a fifth-letter may be appended to the Market Makers identifier for that security. Each Market Maker is free to use any letter to designate a specific branch location as desired.

MP Type

There are several types of NASDAQ participants. Listed below are the characters used with its corresponding market participant type.

A = Agency Quote

C = Electronic Communications Network (ECN)

E = Exchange

M = Market Maker

N = Miscellaneous

O = Order Entry Firm

P = NASDAQ Participant

Q = Query Only Firm

S = Specialist

Name

The firm name of the Market Participant.

Location

The geographic location or the trading desk(s) name of the firm.

Phone Number

The telephone number of the geographic location or trading desk of the firm.

NASDAQ Member

Indicates whether a Market Participant is a member of the NASDAQ Exchange. Possible values are:

Y = Yes, MP is a NASDAQ exchange member

N = No, MP is not a NASDAQ exchange member

FINRA Member

Indicates whether a Market Participant is a member of the Financial Regulatory Authority (FINRA)

Y = Yes, MP is a FINRA member

N = No, MP is not a FINRA member

NASDAQ BX Member *

Indicates whether a Market Participant is currently a member of the Boston Stock Exchange (BSE) or a market participant on the former BSE equity trading platform. It is expected that such Market Participants will continue to have trading rights on a NASDAQ BX equity trading platform.

Y = Yes, MP is a NASDAQ BX member

N = No, MP is not a NASDAQ BX member

PSX Participant

Indicates whether a MP is currently a member of NASDAQ PHLXSM (PHLX00ae) and eligible to trade on PSX..

Y = Yes, MP is a PHLX member, eligible to trade on PSX

N = No, MP is not eligible to trade PSX

Initially, this field will be populated with the value of 201cN201d. Additional notification may occur when this field will begin populating with the value of 201cY201d.

File Creation Time:

The last row of each Symbol Directory text file contains a timestamp that reports the File Creation Time. The file creation time is based on when NASDAQ Trader generates the file and can be used to determine the timeliness of the associated data. The row contains the words File Creation Time followed by mmddyyyyhhmm as the first field, followed by all delimiters to round out the row. An example: File Creation Time: File Creation Time: 1217200717:03|||||| .

Mutual Funds

File Name:

mfundslist.txt

FTP Directory:

Data Field

Definition

Fund Symbol

The identifier for each mutual fund or money market.

Fund Name

The name of each mutual fund or money market.

Fund Family Name

The Name of the Fund Company that is responsible for the fund.

Type

A code used to provide the type of fund.

The allowed values are:

AN = Annuities

MF = Mutual Fund

MS = Supplemantal Mutual Fund

$$ = Money Market Fund

$S = Supplemental Money Market Fund

SP = Structured Products

US = UIT Supplemental List

UT = UIT News Media List