|
Name |
Position |
Description |
|
SERIAL_NUMBER |
1 |
Run date, YYYYMMDD |
|
LEDGER |
2 |
Account number |
|
SALESREP |
3 |
Sales rep number |
|
HOST_CURRENCY |
4 |
Currency code (must match code from currency file) |
|
CASH |
5 |
End cash balance, minus sign (-) = debit |
|
OPTION_VARIATION |
6 |
UPL (Unrealized P/L) on premium-style options (option variation) |
|
FUTURES_VARIATION |
7 |
OTE (futures variation) |
|
INITIAL_MARGIN |
8 |
Initial margin |
|
SECURITIES |
9 |
Collateral on deposit |
|
EQUITY_TOTAL_11 |
10 |
End total account value |
|
MKT_VAL_OPTIONS |
11 |
MVO (market value of options) |
Sample
20150112,ACCT01,SLSRP01,AUD,36907.73,-1562.5,800,-18210,0,36145.23
20150112,ACCT02,SLSRP01,AUD,314.05,0,0,0,0,314.05
20150112,ACCT02,SLSRP01,EUR,896.38,0,0,0,0,896.38
20150112,ACCT02,SLSRP01,GBP,123809.31,0,0,0,0,123809.31
20150112,ACCT02,SLSRP01,SGD,944.83,0,0,0,0,944.83
20150112,ACCT02,SLSRP01,USD,115385.67,0,0,0,0,115385.67