Sample of a properly formatted spreadsheet and acceptable column data:
Date
|
Time
|
O/C
|
L/S
|
Ticker
|
Sh/Contr
|
Price
|
Comm
|
Amount
|
Type/Mult
|
|
(optional)
|
|
|
|
|
|
|
|
(optional)
|
03/18/2020
|
|
B
|
|
WFC 17APR10 15 CALL
|
1
|
1.90
|
1.51
|
-191.51
|
O
|
04/07/2020
|
|
sold
|
|
WFC 17APR10 15 CALL
|
1
|
1.31
|
1.52
|
129.48
|
O
|
03/18/2020
|
|
Sell To Open
|
S
|
WFC 17APR10 16 CALL
|
2
|
1.40
|
3.02
|
276.98
|
O
|
04/07/2020
|
|
Buy To Close
|
S
|
WFC 17APR10 16 CALL
|
2
|
0.85
|
3.01
|
-173.01
|
O
|
03/19/2020
|
|
Buy
|
|
JPM
|
500
|
25.80
|
8.95
|
-12908.95
|
|
03/20/2020
|
|
Buy
|
|
JPM
|
300
|
24.77
|
8.95
|
-7439.95
|
|
03/24/2020
|
|
Sold
|
|
JPM
|
800
|
28.45
|
9.08
|
22750.92
|
|
04/23/2020
|
|
Buy to Open
|
|
AMZN
|
70
|
79.98
|
4.18
|
-5602.78
|
|
04/23/2020
|
|
Sell to Close
|
|
AMZN
|
80
|
79.98
|
4.77
|
-6403.17
|
|
04/24/2020
|
|
Sell
|
|
AMZN
|
100
|
84.80
|
6.19
|
8473.81
|
|
04/24/2020
|
|
Sell
|
|
AMZN
|
50
|
84.80
|
3.09
|
4236.91
|
|
04/30/2020
|
09:58:13
|
Sell to Open
|
S
|
C 15MAY10 3 CALL
|
20
|
0.42
|
23.03
|
816.97
|
O
|
05/12/2020
|
09:43:37
|
Buy to Close
|
S
|
C 15MAY10 3 CALL
|
20
|
0.80
|
23
|
-1623
|
O
|
05/21/2020
|
09:52:22
|
Sell to Open
|
S
|
C 19JUN10 4 PUT
|
17
|
0.79
|
20.79
|
1322.21
|
O
|
05/21/2020
|
10:07:10
|
Sell to Open
|
S
|
SPY
|
100
|
89.26
|
1.23
|
8924.77
|
|
05/21/2020
|
10:25:23
|
Buy to Close
|
S
|
SPY
|
100
|
89.50
|
1
|
-8951
|
|
05/27/2020
|
09:37:53
|
Buy
|
|
GOOG
|
10
|
408.49
|
3.58
|
-4088.48
|
|
05/27/2020
|
09:46:33
|
Buy
|
|
GOOG
|
15
|
408.49
|
5.37
|
-6132.72
|
|
05/28/2020
|
09:40:45
|
Sell
|
|
GOOG
|
25
|
410.25
|
9.22
|
10247.03
|
|
06/16/2020
|
09:46:33
|
Buy
|
|
RIMM
|
100
|
82.00
|
4.48
|
-8204.48
|
|
06/16/2020
|
09:58:16
|
Buy
|
|
RIMM
|
75
|
82.00
|
3.36
|
-6153.36
|
|
06/16/2020
|
10:13:14
|
Buy
|
|
RIMM
|
25
|
82.00
|
1.11
|
-2051.11
|
|
06/17/2020
|
09:40:45
|
S
|
|
RIMM
|
200
|
77.32
|
9.35
|
15454.65
|
|
Acceptable Column Data Formats
Date
Month, day, and year (ex. 12/28/2020).
Separators must be forward slashes ("/"). Alpha-numeric date formats are not acceptable (ex. March 11, 2020).
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 converted to hh:mm:ss.
O/C
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.
L/S
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 only be entered using the TradeLog standardized option symbol format (ie: "NOC 18JAN19 285 CALL").
Futures can be entered using future symbols (ie: "ESM6" or "ESM06") or the TradeLog standardized option symbol format (ie: "ES DEC06")
Futures Options can only be entered using the TradeLog standardized futures option symbol format (ie: "ES DEC06 1030 CALL")
Shares
Can be 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)
|
|
Comments
0 comments
Please sign in to leave a comment.