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 23 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

PropReports

Stock Classes

Berkshire Hathaway Inc Class A

BRK-A

BRK.A

BRK/A

BRK.A

BRK/A

Warrants

Adcare Health Syst Warrants

ADK-WT

ADK+

ADK/WS

ADK.WS

ADK-WT

Mirant B

MIR-WTB

MIR+B

MIR/WS/B


MIR-WTB

When-Issued






Post Holdings

POST-WI
POSTw
POST-WI
Warrants When Issued




Kinder Morgan, Inc

KMI/WSw
KMI-WTWI

Restricted Units

Energy Services Acquisition Corp Unit

ESA-U

ESA=

ESA/U

ESA.U

ESA-U

Rights

Oilsands Quest Inc Rights expiring August 15, 2011

BQI-RI

BQI^



BQI-R

When-Issued Rights






Brookfield Office PropertiesBPO-RWI
BPOrwBPOrwBPO-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.AX

Canadian

Baffinland Iron Mines Corp

BIM.TO


BIM.TO


BIM.TO

Advanced Proteome Therapeutics

APC.V


APC.VN


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.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

PropReports

QQQQ Jul 2010 54.000 Call

QQQQ100717C00054000

QQQQ 100717C54000

QQQQ1710F005400#

+QQQQ100717C00054000

QQQQ Jul 2010 54.000 Put

QQQQ100717P00054000

QQQQ 100717P54000

QQQQ1710R005400#

+QQQQ100717P00054000

JNJ Aug 2012 88.000 Call European


+2JNJ120824C00088000
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.

Name

Yahoo!

PropReports

Mini Soybean Futures,Jan-2010

YKF10.CBT

/YKF10

Forwards

All forwards start with a '#'.

Bonds

All bonds start with an '&'.

Related Topics / How To

Correcting an invalid ticker symbol

  • No labels