Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

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

Adcare Health Syst Warrants

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

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

eFutures

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.

Name

Yahoo!

PropReports

Mini Soybean Futures,Jan-2010

YKF10.CBT

/YKF10.CBT

Forwards

All forwards start with a '#'.

Bonds

All bonds start with an '&'.

Related Topics / How To

Correcting an invalid ticker symbol

  • No labels