File Formats
Instructions
File formats for Brokerage and Bank account historical data are different. Please be sure to use the correct format for the selected account type upload.
Upload File Format for Brokerage Data
The brokerage upload file can contain three types of records: Position, Asset Transaction and Cash Transaction. You can include multiple record types in the same upload file.
Open the sample file for brokerage upload data.
Brokerage - Position Record Layout
| Field Name | Sample | Required | Format |
|---|---|---|---|
| Record Type | P | Y | CHAR(1); Must be "P" |
| Symbol | VZ | Y | CHAR(30) |
| Security ID | 92343V104 | N | CHAR(12) |
| Description | Verizon Communications Inc. | Y | CHAR(255) |
| Currency | USD | Y | CHAR(3) |
| Asset Type | STK | Y | CHAR(8); Must be one of the allowed asset types |
| Quantity | 4 | Y | NUMBER(22,6) |
Brokerage - Asset Transaction Record Layout
| Field Name | Sample | Required | Format |
|---|---|---|---|
| Record Type | A | Y | CHAR(1); Must be "A" |
| Symbol | VZ | Y | CHAR(30) |
| Security ID | 92343V104 | N | CHAR(12) |
| Currency | USD | Y | CHAR(3) |
| Date | 07/10/2019 | Y | CHAR(10); Format: Must be one of the accepted date formats |
| Transaction Type | SELL | Y | CHAR(30); Must be one of the allowed asset transaction types |
| Description | Sell 2 Shares | Y | CHAR(255) |
| Asset Type | STK | Y | CHAR(8); Must be one of the allowed asset types |
| Quantity | 2 | N* | NUMBER(22,6); Required for Trades and INCOME_DIV. |
| Price | 125.00 | N* | NUMBER(22,6); Required for Trades and INCOME_DIV. |
| Dividend | 1.00 | N* | Quantity * Price |
| Commission/Fees | 2.00 | N* | NUMBER(22,6); Required for trades |
Brokerage - Cash Transaction Record Layout
| Field Name | Sample | Required | Format |
|---|---|---|---|
| Record Type | C | Y | CHAR(1); Must be "C" |
| Date | 07/10/2019 | Y | CHAR(10); Format: Must be one of the accepted date formats |
| Transaction Type | CREDIT | Y | CHAR(30); Must be one of the allowed cash transaction types |
| Description | Credit 1 | Y | CHAR(255) |
| Amount | 56.75 | Y | NUMBER(22,6) |
| Currency | USD | y | CHAR(3) |
Upload File Format for Bank Data
The bank upload file has only one record type called Transaction. Open the sample file for bank transaction upload data.
| Field Name | Sample | Required | Format |
|---|---|---|---|
| Record Type | T | Y | CHAR(1); Must be "I" |
| Date | 07/10/2019 | Y | CHAR(10); Format: Must be one of the accepted date formats |
| Transaction Type | DEBIT | Y | CHAR(30); Must be one of the allowed cash transaction types |
| Description | Debit 1 | Y | CHAR(255) |
| Amount | 120 | Y | NUMBER(22,6) |
| Currency | USD | Y | CHAR(3) |
Upload File Format for Credit Card Data
| Field Name | Required | Format |
|---|---|---|
| Record Type | Y | CHAR(1): Must be "T" |
| Date | Y | CHAR(10) Must be one of the accepted date formats |
| Transaction Type | Y | CHAR(5) |
| Description | Y | CHAR(255) |
| Amount | Y | NUMBER(22,6) |
| Currency | Y | CHAR(3) |
Open the sample file for credit card data.
Upload File Format for Other Asset and Liability
| Field Name | Required | Format |
|---|---|---|
| Record Type | Y | CHAR(1): Must be "T" |
| Date | Y | CHAR(10) Must be one of the accepted date formats |
| Transaction Type | Y | CHAR(5) |
| Description | Y | CHAR(255) |
| Amount | Y | NUMBER(22,6) |
| Currency | Y | CHAR(3) |
Additional Resources
Learn About PortfolioAnalyst External Accounts at IBKR Campus