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:
- Each instrument must have a unique ticker symbol
- All symbols are UPPERCASE only and have no spaces.
- All instrument types other than equities have a unique single-character prefix (see below).
- 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 US | POST-WI | ||
Warrants When Issued | ||||||
Kinder Morgan, Inc | KMI/WSw | KMI/WSw US | KMI-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 Properties | BPO-RWI | BPOrw | BPOrw | 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.375 | ATT-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 Inc | BPO-PN.TO | BPO-PN.TO | ||||
Turquoise Hill Resources LTD RI | TRQ-RT.TO | TRQ-RT.TO | ||||
Argent Energy Trust 6.00 PCT DE | AET-DB.TO | AET-DB.TO | ||||
Atlantic Power Corp. 6.25 Conv | ATP-DBA.TO | ATP-DBA.TO | ||||
Franco-Nevada Corporation Warrants | FNV-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