|
Name |
Position |
Description |
|
SERIAL_NUMBER |
1 |
Run date, YYYYMMDD |
|
LEDGER |
2 |
Account number |
|
SALESREP |
3 |
Sales rep number |
|
MARKET |
4 |
Exchange name |
|
MARKET_CODE |
5 |
Future code or option code |
|
PROMPT_DATE |
6 |
Prompt date (not expiry date), YYYYMMDD For monthly contracts, DD is ignored, usually sent as '01' |
|
TRADE_TYPE |
7 |
FT = future TP & TC = options FX = Forex (fut/call/put) |
|
SERIES |
8 |
Option Series Price (Strike) |
|
ENTRY_DATE |
9 |
Trade date, YYYYMMDD |
|
LOTS |
10 |
Lots traded Amount traded for FX trades NB minus sign (-) indicates a sale |
|
MARKET_RATE |
11 |
Settlement/closing price |
|
PREMIUM_RATE |
12 |
Trade price for option |
|
PRICE |
13 |
Trade price for future |
|
DESCR |
14 |
Product description |
|
MTM |
15 |
Mark to market/open trade equity |
|
HOST_CURRENCY |
16 |
Currency code (must match code from currency file) |
Sample
20150112,ACCT01,SLSRP01,SFE ,ASPI,20150331,FT, ,20081218,1,3588,0,3556,SFE ASPI MAR09,100.0,AUD
20150112,ACCT01,SLSRP01,SFE ,ASPI,20150331,TP,3200.0,20081222,-1,168.5,150,0,SFE ASPI MAR09,200.0,AUD
20150112,ACCT01,SLSRP01,SFE ,ASPI,20150331,TC,3600.0,20081223,-1,297.5,218,0,SFE ASPI MAR09,300.0,AUD