Excel/Text Import - General Guidelines and Procedure – TradeLog Software

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.

Please see My broker is not supported - can I import?

__________________

The Excel-Text import method allows a user to import the following instruments:

stocks
bonds
mutual funds
options
futures
futures options
cryptocurrency (digital currency)

Important: your Excel/Text data must be formatted using our guidelines (later on this page).

1. Format 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 Baseline Positions before importing, if necessary.

6. Go to the Account tab at the top and click the from Excel button.

7. 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.

We provide sample templates to help, click here to download a template file.

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/2017		B		WFC 17APR10 15 CALL	1	1.90	1.51	-191.51	O
04/07/2017		sold		WFC 17APR10 15 CALL	1	1.31	1.52	129.48	O
03/18/2017		Sell To Open	S	WFC 17APR10 16 CALL	2	1.40	3.02	276.98	O
04/07/2017		Buy To Close	S	WFC 17APR10 16 CALL	2	0.85	3.01	-173.01	O
03/19/2017		Buy		JPM	500	25.80	8.95	-12908.95
03/20/2017		Buy		JPM	300	24.77	8.95	-7439.95
03/24/2017		Sold		JPM	800	28.45	9.08	22750.92
04/23/2017		Buy to Open		AMZN	70	79.98	4.18	-5602.78
04/23/2017		Sell to Close		AMZN	80	79.98	4.77	-6403.17
04/24/2017		Sell		AMZN	100	84.80	6.19	8473.81
04/24/2017		Sell		AMZN	50	84.80	3.09	4236.91
04/30/2017	09:58:13	Sell to Open	S	C 15MAY10 3 CALL	20	0.42	23.03	816.97	O
05/12/2017	09:43:37	Buy to Close	S	C 15MAY10 3 CALL	20	0.80	23	-1623	O
05/21/2017	09:52:22	Sell to Open	S	C 19JUN10 4 PUT	17	0.79	20.79	1322.21	O
05/21/2017	10:07:10	Sell to Open	S	SPY	100	89.26	1.23	8924.77
05/21/2017	10:25:23	Buy to Close	S	SPY	100	89.50	1	-8951
05/27/2017	09:37:53	Buy		GOOG	10	408.49	3.58	-4088.48
05/27/2017	09:46:33	Buy		GOOG	15	408.49	5.37	-6132.72
05/28/2017	09:40:45	Sell		GOOG	25	410.25	9.22	10247.03
06/16/2017	09:46:33	Buy		RIMM	100	82.00	4.48	-8204.48
06/16/2017	09:58:16	Buy		RIMM	75	82.00	3.36	-6153.36
06/16/2017	10:13:14	Buy		RIMM	25	82.00	1.11	-2051.11
06/17/2017	09:40:45	S		RIMM	200	77.32	9.35	15454.65

Acceptable Column Data Formats

Date

Month, day, and year (ex. 12/28/2019).

Separators must be forward slashes ("/"). Alpha-numeric date formats are notacceptable (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 samesecurity 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 standardized option symbol format (ie: "DELL 15NOV19 30 CALL"). This format consists of: TICK DDMMMYY $$$ C/P, where

TICK = Underlying ticker symbol

DD = Day of the expiration

MMM = Expiration month

YY = Expiration Year

$$$ = Strike Price

C/P = CALL or PUT

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")

Cryptocurrency (Digital Currency) transactions should be entered using a standardized symbol such as BTC (Bitcoin), ETH (Ethereum), etc. Consistent symbols must be used to properly match transactions.

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)

D or d = Cryptocurrency (Digital Currency)

Excel/Text Import - General Guidelines and Procedure

General Procedure:

Formatting Your Data

Comments

Promoted articles

General Procedure:

Formatting Your Data

Related articles

Promoted articles