Symbology

General Notes

When importing data, PropReports will attempt to "normalize" ticker symbols to make them consistent. This is done in order to:

  • Match up instrument specifications and pricing information with our market data sources.
  • Provide a consistent presentation when aggregating trading activity from multiple sources of data.
  • Facilitate reconciliation versus the clearing firm.

Naming rules:

  1. Each instrument must have a unique ticker symbol 
  2. All symbols are UPPERCASE only and have no spaces.
  3. All instrument types other than equities have a unique single-character prefix (see below).
  4. All non-US-traded equities have a unique suffix.  Please refer to the following list of exchanges and suffixes.
Equities

Equity symbols do not have a prefix.  Use a '/' as a class designation separator and '-P' to indicate preferred stocks.

Name

Yahoo!

NASDAQ IP

Sterling

Lightspeed

Bloomberg

PropReports

Stock Classes

Berkshire Hathaway Inc Class A

BRK-A

BRK.A

BRK/A

BRK.A

BRK/A US

BRK/A

Warrants

BYTE Acquisition Corp

ADK-WT

ADK+

ADK/WS

ADK.WS

ADK/WS US

ADK-WT

Mirant B

MIR-WTB

MIR+B

MIR/WS/B


MIR/WS/B US

MIR-WTB

When-Issued







Post Holdings

POST-WI
POSTw
POSTw USPOST-WI
Warrants When Issued





Kinder Morgan, Inc

KMI/WSw
KMI/WSw USKMI-WTWI

Restricted Units

Energy Services Acquisition Corp Unit

ESA-U

ESA=

ESA/U

ESA.U

ESAu US

ESA-U

Rights

Oilsands Quest Inc Rights expiring August 15, 2011

BQI-RI

BQI^




BQI-R

When-Issued Rights







Brookfield Office PropertiesBPO-RWI
BPOrwBPOrw
BPO-RWI

Preferred Stock

ABC Bancorp 9.00% Pfd Sec

BHC-P

BHC-

BHCp

BHC'


BHC-P

Alabama Power 5.20% Pfd Stk

ALP-PN

ALP-N

ALPpN

ALP'N


ALP-PN

Senior Note







AT&T Inc. Senior Note 6.375ATT-CL



ATT-CL

Australian Securities Exchange

Iluka Resources Limited

ALU.AX




ALU AU

ALU.AX

Canadian

Baffinland Iron Mines Corp

BIM.TO


BIM.TO


BIM CN

BIM.TO

Advanced Proteome Therapeutics

APC.V


APC.VN


APC CJ

APC.TV

4Front Ventures CorpFFNT.CN
FFNT.TC
FFNT.CNFFNT.CN

Central Fund of Canada Limited Class A

CEF-A.TO





CEF/A.TO

Australian Banc Capital Sec Tru

AUZ-UN.TO





AUZ-UN.TO

Brookfield Office Properties IncBPO-PN.TO



BPO-PN.TO
Turquoise Hill Resources LTD RITRQ-RT.TO



TRQ-RT.TO
Argent Energy Trust 6.00 PCT DEAET-DB.TO



AET-DB.TO
Atlantic Power Corp. 6.25 ConvATP-DBA.TO



ATP-DBA.TO
Franco-Nevada Corporation WarrantsFNV-WTA



FNV-WTA

London Stock Exchange

Lloyds Banking Group

LLOY.L


LLOY.LN


LLOY LN

LLOY.L

Autonomy Corporation PLC

AU.L


AU/.LN



AU.L

Options

Options begin with a '+' followed by the OSI symbol for the option (Underlyer + Expiration YYMMDD + C or P + strike price).  FLEX symbols are also supported.

Name

Yahoo!

Sterling

Instaquote

Bloomberg

PropReports

QQQQ Jul 2010 54.000 Call

QQQQ100717C00054000

QQQQ 100717C54000

QQQQ1710F005400#

QQQQ 07/17/10 C54

+QQQQ100717C00054000

QQQQ Jul 2010 54.000 Put

QQQQ100717P00054000

QQQQ 100717P54000

QQQQ1710R005400#

QQQQ 07/17/10 P54

+QQQQ100717P00054000

JNJ Aug 2012 88.000 Call European



+2JNJ120824C00088000

/EWK20.CME May 2019 3100.000 Call





+EWK20.CME200529C03100000
Indexes

Name

Stricknet

Yahoo!

PropReports

Volatility S&P 500

VIX.XO

^VIX

^VIX

Mutual Funds

All mutual funds start with an '!'.

Name

Yahoo!

PropReports

Vanguard 500 Index Investor

VFINX

!VFINX

F/X Currency Pairs

All pairs begin with an '@' followed by the three-letter (ISO 4217) codes for each of the two currencies (the base currency followed by the counter currency).

Name

Yahoo!

PropReports

EUR/USD

EURUSD=X

@EURUSD

Futures

All futures start with a '/' followed by the root symbol, expiration month code and expiration year and ends with a suffix that represents the Exchange that the contract is traded on. Daily futures include the expiration day after the expiration month (two digits, 0 padded).

Name

Yahoo!

PropReports

Cbot Mini Soybean Futures,Jan-2010

YKF10.CBT

/YKF10.CBT

LME Daily Zinc Futures, Mar-06-2023
/ZSDH0623.LME
CFD

All CFDs start with a '%'. 

  • You can opt to use the underlying symbol directly in PropReports, if you do not need the CFD type designation.  This will allow any overnight position to receive the standard closing price for the underlying symbol, if applicable.  eg. use AAPL instead of %AAPL if CFD type does not need to be associated with symbol.

Name

PropReports

Apple%AAPL

UK100 (FTSE 100)  CFD

%UK100

Forwards

All forwards start with a '#'.

Bonds

All bonds start with an '&'.

NamePropReports
US TREASURY N/B 7.125000% 02/15/2023 &US912810EP94

Related Topics / How To

Correcting an invalid ticker symbol