Correcting a Ticker Symbol

Owned by Noah Keats
Last updated: Jan 17, 2020 by Brent Bergh
3 min read

When importing data, PropReports will attempt to "normalize" ticker symbols to make them consistent.  However, periodically trading activity may be received and processed with a ticker symbol that does not comply with PropReports Symbology. This can happen due to:

  1. Missing, stale or incomplete data at the source.
  2. Mis-keyed manual order entry
  3. The source formats symbols differently from PropReports. 

If the issue is #3, please let us know at support@propreports.com and we will update our import process to ensure proper conversion. In other cases, a one-off correction may be desired. To correct a ticker symbol please follow the steps below:

Important Tip

Because closing prices and instrument specifications can change, making a ticker symbol correction may update historic balances for any accounts that traded those instruments. 

If you wish to update the instrument as of a more recent date, make sure to use the "Effective From" date checkbox.  This may help prevent a potentially lengthy balance re-computation going back to first date the symbol was traded.

Step 1: Navigate to the Audit / Symbols page.

Step 2: Enter the Symbol/CUSP/ISIN you would like to correct and click "Find".

Step 3: Click "Edit" under the actions header.

Step 4: Enter a new ticker symbol and click "Correct" to change the symbol.

When correcting a symbol from ABC to XYZ PropReports does the following:

  1. Changes all trade records from ABC to XYZ.  This includes executions, positions, locates and reconciliation data. For options, any underlying symbol ABC will change to XYZ.
  2. Moves any imported closing prices from ABC to XYZ for prices not already defined for XYZ.
  3. If XYZ is not already in the system, fetches the description, listing exchange, etc. from our market data server and adds XYZ to the symbol list.
  4. A ticker rename rule will be created renaming any activity in symbol ABC to XYZ at the time of upload. Note that the rename rule will only be created if ABC was imported from a single source and there is no rename rule already in place for ABC or XYZ.
  5. Removes ABC from the symbol list.

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.

Escaping special characters

  • Certain characters need to be escaped with a \ (a backslash) placed in front of them in order for those characters to be accepted as literals.  If the backslash is followed by a non-alphanumeric character, it takes away any special meaning that character may have.
  • Characters that require the use of the \ character.       ” ^ [ $ ( ) | * + ? { \ /” .     
  • Example: A manually entered ticker rename rule for symbol VALE.P would need to be inserted as VALE\.P as the MATCH value for the particular source you are receiving the symbol from.  The SET value does not need the escape character.