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 | 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 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.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 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.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 | /YKF0 |
Forwards
All forwards start with a '#'.
Bonds
All bonds start with an '&'.
Related Topics / How To