Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Name

Description

Example

afterHours

Execution occurred on or after 4pm EST

afterHours=true

capacityTrading capacity of the order (when available). A = Agency, C = Agency Cross, P = Principal, R = Riskless Principal.capacity=P

contra

MPID / identifier of the counterparty.

contra=PFSI

ccy

An ISO 4217 (3-character) currency of the trade. (v1.5.97.13 or greater)

ccy=EUR

exch

Listing exchange for the security being traded (see list of exchange codes).

exch=NYQ

execBrokerMPID / identifier of the executing broker.execBroker=PFSI
internalContraIndicates the actual MPID / identifier of the counterparty when an order is routed via an order desk or another intermediary (when available). (v1.5.98.19.16 or greater)internalContra=PFSI
internalLiqIndicates the actual liquidity flag when an order is routed via an order desk or another intermediary (when available). Note: This value is case-sensitive.internalLiq=A
internalRouteIndicates the actual destination when an order is routed via an order desk or another intermediary (when available).internalRoute=EDGA

liq

Liquidity flag (see flags for various destinations). Note: This value is case-sensitive.

liq=A

lot

Considers quantity of trade:   (ODD = if quantity < 100 on an execution) 
(EVEN = if quantity divisible by 100) 
(MIXED = if > 100 and not divisible by 100 evenly)

lot=odd 
lot=even 
lot=mixed

multThe multiplier (sometimes called "contract size" for options and "value multiplier" for futures) associated with the traded instrument and used when computing profit and loss (v1.5.97.14.13 or greater)mult=100

penny

Set to true if trade is sub-dollar

penny=true

price

Execution price.

price>2

qty

Quantity of the execution. (v1.5.92.18 or greater)

qty=100

route

Exchange, Route or ECN. Different platforms can send different values for the same venue (e.g. Sterling: NSDQ vs Laser: ISLD). Furthermore, some platforms can indicate multiple values for the same destination (e.g. Sterling: ARCA, ARCA= to mean ARCA).

route=ARCA

side

Buy or sell

side=buy

source

Where PropReports received the trade from (see list of source ids).

source=1

subType

For equities, this will be either etf or blank

subType=etf

symbol

Ticker symbol of the security being traded

symbol=IBM

tape

Trade reporting facility indicator (e.g. A, B, or C). See Tape Designations.

tape=A

timeExecution time in the format HH:MM:SS (v.1.6.5.85 or greater).time>=10:00:00

type

Type of instrument being traded (equity, option, future, index, fund, fx, bond)

type=option

underlyingSymbol

For options, the ticker symbol of the underlying security or index.

underlyingSymbol=YHOO

underlyingType

For options, the type of the underlying security (equity, future, index)

underlyingType=index

underlyingSubType

For options, the sub type of the underlying equity (etf or blank)

underlyingSubType=etf

...

Example: In the Liq field there is an eight character string of "ABCDEFGH".  The following examples of slicing could be used:

Condition examplesFee Rule Syntax

liq[1] will match against A

liq[1]=A => 0.001
liq[2] will match against Bliq[2]=B => 0.001
liq[1:2] will match against ABliq[1:2]=AB => 0.001
liq[1:5] will match against ABCDEliq[1:5]=ABCDE => 0.001
liq[4:] will match against DEFGHliq[4:]=DEFGH => 0.001
liq[:4] will match against ABCDliq[:4]=ABCD => 0.001

When multiple sliced conditions need to be true, use the AND-ing semi-colon character ";"

liq[1] will match against A  and  liq[4] will match against D


liq[1]=A;liq[4]=D => 0.001

When one sliced condition needs to be true, use the OR-ing comma character ","

liq[1] will match against A  or  liq[4] will match against D


liq[1]=A,liq[4]=D => 0.001


Fees

Positive fees are charges, negative fees are rebates. There are four ways to assess a fee or rebate:

...

ExampleDescription
max(0.003%, 0.003)Result will be the highest of :   (0.003 * trade value) or (0.003 * quantity)
min(0.003%, 0.003, 3 [3])Result will be the lowest of :   (0.003 * trade value) or (0.003 * quantity) or 3

...