Integration Requirements

We are happy to integrate with any provider/clearing firm we do not currently support. The data is typically sent to PropReports daily via email(s) or made available through an FTP drop site (preferred). The file format should ideally be either CSV or column-delimited. The following information can be imported into our system:

Executions/fills
- Minimum information on each fill: Account Id, Fill Date, Type of Trade (Buy or Cover, Sell or Short), Symbol, Quantity, and Price.
- To support options, it should be easy to discover whether the instrument is a Put or Call, the maturity date, and the underlying security and contract size.
- To support futures, the value multiplier must be known.
- If foreign currency instruments are traded, the currency and exchange rate must be transmitted.
- Optional Information: Trader Id, Order Id, Fill Id, Fill Time, Exchange, Contra, Commission, Liquidity Flags, Any additional fees.
Positions (for reconciliation only)
- The minimum information on each position must include Account Id, Position Date, Symbol, Open Quantity, and Long or Short.
- Optional information: Realized Profit / Loss, Unrealized Profit / Loss, and Closing Price.
- A procedure needs to be in place for us to find out about trade breaks and away trades (this can be a manual notification if relatively infrequent).
Cash movement / adjustment activity
- Minimum information required is: Adjustment Date, Account Id, Amount of Adjustment
- To help classify transactions, a category would be helpful (e.g. transfer or fee)
- A comment or trailer for each transaction can be displayed as well
Locates
- Minimum information required: Account Id, Trade Date, Symbol, Quantity