Importing Etrade Data
Posted by Henry Gage on 15 October 2010 07:13 PM
Importing Etrade Data:
We corresponded with Etrade and they said they already have a solution. They are also changing their file formats. It seems there may be another file format that some would like to import.
Here is the Etrade gain/loss report format:
Here is an example of the heading from a file:
Symbol,Qty,Opening Date,Opening Price,Opening Net Amount,Order,Closing Date,Closing Price,Closing Net Amount, Gain (Loss),Gain Term |
,, Here is an example of the data from a file: ABC,10, 01/01/2009,20.00,200.00, S, 01/02/2009,22.00,220.00,20.00, Short
,, If you have the engineering release of TAPro and if you have a copy of the Etrade transaction history file then TA can import the file. Here is an example of the heading from a file: Trade Date,Order Type,Security,Cusip,Transaction Description,Quantity,Executed Price,Commission,Net Amount Here is an example of the data from a file: 1/2/2009,Sell To Close,MPWAA,,2 MPW JAN-09 $5 CALLS (MPWAA) MEDICAL PPTYS TRUST INC COM JAN-09 $5 CALL,2,1.45,11.49,278.5 1/5/2009,Buy Open,ILTML,,2 TLT JAN-09 $116 PUTS (ILTML) ISHARES TR BARCLYS 20+ YR JAN-09 $116 PUT,2,2.85,11.49,581.49 Regarding: TAPro engineering update, with a) Symbol Type Editing Enabled b) Reconciliation Features When symbols are first imported TAPro learns their type from the data provided. Sometimes that initial information is not correct. In the engineering release of TAPro we have enabled symbol editing. This means you can go to the Edit/Symbols Add Modify and change the type of a symbol. When reconciling data there are times when it is easier to look that the Transaction View and make adjustment to the Time of a trade of an Action (Short vs. Long). We have created a new view to support reconciliation. See Transactions Screen "Display View: Positions - Reconciliation" Here is the engineering release. 1. Download this file (copy this url into your browser): http://www.tradeaccountant.com/downloads/TAPro_3_6_02_10_09_26_beta.zip 2. Open the zip file. 3. Read the .txt file for installation steps.