|
Acceptable Column Data Formats
Date
Two digit month and day, and a four digit year (ex. 12/28/2009).
Separators must be forward slashes ("/"). Alpha-numeric date formats are not acceptable (ex. March 11, 2009).
Time (this column is optional)
Format is hh:mm:ss, but formats such as 11:30AM or 12:00:00PM are also acceptable and will be convertd to hh:mm:ss.
Buy/Sell
Any one of the following, in upper or lower case, are acceptable: Buy, Bought, B, Purchase, or P, or Sell, Sold, or S for stocks. You may also use: Buy to Open, or Sell to Close, Sell to Open, Buy to Close for options only.
Long/Short
Can be blank, or simply use "S" for short, and "L" for long (for stocks and options only)
NOTES:
1. A properly formatted short sale will have "S" in the Buy/Sell column and "S" in the Long/Short column.
2. A properly formatted buy to cover a short sale will have "B" in the Buy/Sell column and "S" in the Long/Short column.
3. If you have short sales in the Excel or text file you will be importing, you need to confirm that the "sell" (opening transaction) is listed before the "buy to cover short" (closing transaction) for each short sale in the file.
Ticker
Alpha-numeric, with a maximum of 40 characters (additional characters will be truncated).
Please note that when manually entering multiple transactions for the same security into an import file, you must enter an identical ticker description for each of these transactions. TradeLog cannot match two transactions with different tickers together - even if they vary due to one special character (ex. %, &, -, /) or a space.
Mutual Funds are entered the same as stocks.
Options can be entered using option ticker symbols (ie: "DLQKF" or using TradeLog standardized option symbol format (ie: "DELL NOV06 30 CALL").
Futures can be entered using future symbols (ie: "ESM6" or "ESM06") or TradeLog standardized option symbol format (ie: "ES DEC06")
Futures Options can only be entered using TradeLog standardized futures option symbol format (ie: "ES DEC06 1030 CALL")
Shares
Whole numbers only, positive or negative. (TradeLog converts all share quantities to positive during the import process.)
Price
Can be decimal (with a single decimal point) or fraction (fractional part must be separated from whole by a space).
Comm (Commissions and SEC Fees)
Must be decimal, positive or negative. (TradeLog converts the value to positive during the import process.) If left blank, the commission will be calculated from the Amount (providing the Amount includes commissions and fees).
Amount
Can be positive or negative. (TradeLog converts the value to appropriate positive or negative amount during the import process.) If left blank, TradeLog uses the following calculation, depending on whether the transaction is a "buy" or "sell":
Amount = Shares x Price +/- Commissions & Fees
Type (this column is optional if only importing stocks and mutual funds)
O or o = option, F or f = Future (leave blank for stock or mutual fund)
|