> Table of Contents

Ameritrade CSV

This page reflects my current understanding of the Ameritrade CSV file format. It is not comprehensive or authoritative.

There are 9 fields, each separated by a comma. The first field is the date in mm/yy/dddd format. The second field is the transaction ID which is not used by Icarra. The third field is the description which determines the type of transaction (see more below). The fourth field is quantity which is the number of shares purchased/sold. The fifth field is the symbol. The sixth field is the price per share. The seventh field is the commission for buy transactions. The eight field is total amount including fees. The ninth and final field is the fee for sell transactions.

The following descriptions (transaction types) are supported. Uppercase and lowercase is important:

Bought: If the description begins with Bought it is a buy transaction
Sold: If the description begins with Sold it is a sell transaction
STOCK SPLIT: A stock split. The quantity field is the number of shares received due to the split.
ACCOUNT TRANSFER INCOMING, PERSONAL CHECK RECEIPT, CASH RECEIPTS THIRD PARTY, CASH RECEIPT: All synonyms for Deposit.
ORDINARY DIVIDEND, LONG TERM GAIN DISTRIBUTION, QUALIFIED DIVIDEND: Dividend.
DIVIDEND REINVESTMENT: A dividend reinvestment transaction, equivalent to a Dividend and a Buy.
DIVIDEND OR INTEREST: If the ticker is present it is a Dividend, if not it is an Adjustment.
FREE BALANCE INTEREST ADJUSTMENT: A cash Adjustment (interest).
QUARTERLY MAINTENANCE FEE: A negative cash Adjustment.

Here is a sample .csv file: