1.800.372.60781.800.372.6078
Menu

User Guide

×
Menu
Index

Excel- Text File Import

 
Excel-Text Import Instructions:
 
If you are trying to import from a broker that is not currently supported by TradeLog or the data is no longer available for download via BrokerConnect or a CSV download, we do offer the excel-text file import. Compatible import files can be created using Microsoft Excel or any other word processor. Acceptable file formats are tab-delimited plain text (*.txt) or Excel (*.xls). Please click one of the links below to download a sample:
 
Click on the links below to download a sample file to your hard drive:
 
If your online broker is not supported, please contact them regarding possible report formats - if they can supply you with an Excel or text file containing your trades, you should be able to import these into a TradeLog data file after editing the spreadsheet into the proper format.
 
__________________
 
The Excel-Text import method allows a user to import  the following instruments:
  • stocks
  • bonds
  • mutual funds
  • options
  • futures
  • futures options
 
General Procedure:
 
1. Formatted the spreadsheet using the following the guidelines at the bottom of this page:
2. Select all the data in your spreadsheet. - Hit Ctrl + A on your keyboard. This will highlight the entire table of data.
 
3. Click Edit, Copy from the main menu or hit Ctrl + C on your keyboard to copy the trade data to the Windows Clipboard.
 
4. Return to TradeLog.
 
5. Create a new data file that will receive the transactions, or open an existing data file to import into. Be sure to manually enter any open positions before importing, if necessary.
 
6. If you have not done so already, the import filter must be set. Click Accounts, Edit. From this list select Excel-Text. Click OK
 
7. Click the Excel-Text Imp button to begin the import.
 
8. A Confirm window will appear, asking you to confirm the total number of records to be saved. Click YES to save the imported trades in the data file.
 
Users wishing to import from an Excel or text file must strictly follow the guidelines below or import errors will result.
 
 
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/2010
 
B
 
WFC 17APR10 15 CALL
1
       1.90
1.51
-191.51
O
04/07/2010
 
sold
 
WFC 17APR10 15 CALL
1
       1.31
1.52
129.48
O
03/18/2010
 
Sell To Open
S
WFC 17APR10 16 CALL
2
       1.40
3.02
276.98
O
04/07/2010
 
Buy To Close
S
WFC 17APR10 16 CALL
2
       0.85
3.01
-173.01
O
03/19/2010
 
Buy
 
JPM
500
     25.80
8.95
-12908.95
 
03/20/2010
 
Buy
 
JPM
300
     24.77
8.95
-7439.95
 
03/24/2010
 
Sold
 
JPM
800
     28.45
9.08
22750.92
 
04/23/2010
 
Buy to Open
 
AMZN
70
     79.98
4.18
-5602.78
 
04/23/2010
 
Sell to Close
 
AMZN
80
     79.98
4.77
-6403.17
 
04/24/2010
 
Sell
 
AMZN
100
     84.80
6.19
8473.81
 
04/24/2010
 
Sell
 
AMZN
50
     84.80
3.09
4236.91
 
04/30/2010
09:58:13
Sell to Open
S
C 15MAY10 3 CALL
20
       0.42
23.03
816.97
O
05/12/2010
09:43:37
Buy to Close
S
C 15MAY10 3 CALL
20
       0.80
23
-1623
O
05/21/2010
09:52:22
Sell to Open
S
C 19JUN10 4 PUT
17
       0.79
20.79
1322.21
O
05/21/2010
10:07:10
Sell to Open
S
SPY
100
     89.26
1.23
8924.77
 
05/21/2010
10:25:23
Buy to Close
S
SPY
100
     89.50
1
-8951
 
05/27/2010
09:37:53
Buy
 
GOOG
10
    408.49
3.58
-4088.48
 
05/27/2010
09:46:33
Buy
 
GOOG
15
    408.49
5.37
-6132.72
 
05/28/2010
09:40:45
Sell
 
GOOG
25
    410.25
9.22
10247.03
 
06/16/2010
09:46:33
Buy
 
RIMM
100
     82.00
4.48
-8204.48
 
06/16/2010
09:58:16
Buy
 
RIMM
75
     82.00
3.36
-6153.36
 
06/16/2010
10:13:14
Buy
 
RIMM
25
     82.00
1.11
-2051.11
 
06/17/2010
09:40:45
S
 
RIMM
200
     77.32
9.35
15454.65
 
 
 
Acceptable Column Data Formats
 
Date
Month, day, and 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.
 
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 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)