Security Master
Because stock tickers can vary from source to source, PropReports attempts to gather complete security information directly from your providing DMA platform or clearing firm. If complete information is provided by one of your DMA platforms or clearing firms, PropReports will store that information as the Security Master.
If we are unable to gather complete information for a security via your DMA platform or clearing firm, the first time an unknown security is traded and your data is uploaded into your instance, we will attempt to fetch the securities information from a central market data server which aggregates the data from multiple vendors.
Below is a screenshot of the security "QQQ". You can see that the security information considerably differs from source to source. 
To view a securities complete information, navigate to the Audit > Symbols page and type in a symbol.
Instrument Timeline
PropReports records and maintains a timeline of all changes done to security information (e.g. a listing exchange or a company name change). It is important to note that changes will effect any fee plan that calls the exchange code or tape, etc. The plans that are effected will apply the changes and recompute all data from the date the change occurred externally to the security, not from the date the plan was updated in PropReports.
Below is a screenshot of security "AQLV". The security was removed from the national listings and placed on the OTCBB exchange.
To view your market data timeline, navigate to he Audit > Symbols page, type in a security and click the Edit link.
Incomplete symbols:
Any security type missing a multiplier (set to 0).
Equities: missing listing exchange, missing tape if currency is USD
Options: Missing strike price, missing maturity date, unknown whether call or put, missing underlying symbol, missing strike price.
Bonds: Missing maturity date or coupon.
To view incomplete symbols, navigate to the Audit >Symbols page and search for "Incomplete". All incomplete securities appear with a red background, as seen in the screenshot below.
"Material" Fields
These are fields that when changed require a recompute of trade fees if that symbol trades on the date(s) on which the change applies. For example, changing a CUSIP does not trigger a recompute whereas changing the multiplier can affect P/L.
Any Security: Multiplier, Currency, Listing Exchange
Equities: is ETF, Tape
Options: Call or Put, Strike Price, Maturity, Underlying Symbol
Equities
Determining Default Tape: (only if unspecified from any of our data sources)
non-USD, tape is blank
Exchange Code NYQ, tape is A
Exchange code NAS, tape is C
Exchange code ASE or PCX, tape is B
Exchange code is not set and symbol length is 3 characters or less, tape is 'A'
Tape is C
Determining Default Exchange Code / Currency
Automatically set CAD as currency if symbol suffix is .TO or .TV. Listing Exchange is set to TOR if suffix is .TO and VAN if suffix is .TV.
Options
If no other information is provided and the option follows a standard OSI format, we will attempt to determine the Strike Price, Call or Put, and Maturity from the symbol. The contract is set to 100 by default and the underlying security is blank.
Currency Pairs
We initialize the instrument currency to be the "to" currency of the pair. So @EURCAD will have the currency automatically set to CAD.
Futures
Default multiplier is 0
Receiving Data From Multiple Sources
You can see a timeline for all sources for an instrument by pulling up the symbol on Audit / Symbols list and clicking edit then "Show Data Sources".
Changes are made under the following circumstances:
- If any material change is received and we only have only one source for historic data, the active timeline is updated a/o the date changes are received.
- If the current symbol is an incomplete option and we are receiving option specifications that were missing (e.g. underlying security), we will update the option with the change regardless of the number of sources for historic data.
- If the current symbol is missing a multiplier, we will update the multiplier regardless of the number of sources for historic data.
- If the Cusip/Isin or description are missing we will set those once received from any source.
Note: Merged data can be overridden manually.