First use sync to see how much data is available (note the date of the earliest transaction,
then use file import to fill in older data that is not on the brokerage site. Going forward
you can use sync to maintain your history.
Before major edits remember to select File/Save As Backup to create a copy
of your data in case you want to return to a prior point in time. In addition TA creates backup copies of your
data when you select actions like Build/New. The backup files are typically stored in this location:
C:\Program Files\Sync Essentials\TradeAccountant PRO_3.7.00\ta_data_files
When downloading data from a brokerage web site use these setting to allow TA to recognize
the file and prevent another application from capturing the file. If another application
captures the file then you will not be able to save it.
- Within TAPro, select View/Properties.
- Within the Properties dialog, select Associated File Types. These file type include data formatted
using .XML or other standard record formats. Typically TA can import a file if it is
in one of the formats listed in this menu.
- Select the check boxes for Import .QIF, .QFX and
.OFX, this enables TAPro to directly receive these files during the
download process.
- Select OK
II. Download a Transaction File
Download steps are unique to each brokerage. If the instructions are not sufficient on the TA
site please check the support site for more recent information. During the year users share information
discovered while working with TA and their brokerage.
Decide on a date range so the import will not result in duplicate transactions. One alternative to
consider is importing the file into a different account so you can look at it and then later you can
use Edit/Transaction(s) - Move to Account to select only the transactions that you want in the
account that is sync enable.
Visit the brokerage site and download a data file
- Log into your account
- Look for Transaction History
- Select All Trades, if you need a full year select Custom Time Period
- Select Spreadsheet, then Download
- Select a date range that meets your needs
- If the file does not download check your browser security setting
- For help with file download, contact the Etrade team
III. Import Transactions
TAPro 3.7 includes an automatic import profile for this brokerage. After you select the file that you want to import
TAPro will determine if an existing profile can import the file. If automatic
import is possible then a menu appears with this option. Otherwise use manual import.
If you edit the file then TA may not recognize user created headings and will default to the manual
file import. However if you keep the heading unchanged then it is likely that TA will recognize
the file.
- Select File/Import/Transactions.
If guidance is needed then after starting the import, select manual and
follow the steps in the menus that appear. At the beginning of the manual process
create a new profile name or select an existing profile. TAPro will attempt
to reuse this profile for each import of the same type file to the same account
in TAPro.
If a file contains new transaction types that TAPro is unfamiliar with then an error may prevent
automatic file import and require manual file import or editing of the file to remove the exotic new
transactions.
If there is an error in the profile you may need to select manual import.
During manual import if the profile does not work you may need to remove it and repeat the import.
To remove a profile select Import Rules/Profile Manager from the File/Import
menu.
- TA can import transactions that are saved in many standard formats including .OFX, .XML,
.csv (comma delimited) and .txt (tab delimited). However such files have formats that are
different for each brokerage. TA 3.7 introduced automatic file imports for select brokerages
.csv and .txt file. In such cases TA attempts to import the file without requiring guidance.
- If a problem is encountered during import, make a note of the error and send an email to
support along with a copy of the file. Automatic import relies on knowledge of each transaction
type else the parser does not know how to categorize unexpected information.
- When an import error appears during an automatic import attempt it is also possible to edit
the file to remove the likely causes (transactions like Deposit Cash, ACH Fees, etc. then
try again. Alternatively use the manual import method.
IV. Enter Data Manually:
- You can import date from almost any .csv file into TA as long as certain columns
appear. Refer to the supported brokerage page for heading examples.
- You can manually enter trades from the Transaction Screen by
selecting the Add button.
V. Import Symbols
During import TA builds a list of unique symbols and uses that information when transactions are imported.
This means there is one central place for editing symbol information. Select Edit/Symbol(s) - Add/Modify
to directly change symbol information in TA. Alternatively use File/Export/Symbol Details to create a file
with all of your symbol information. Then you can edit the file and import it.
Training Videos (with voice):
Click Here
