Most Brokerages offer .QIF (Quicken® Format) and .OFX (Money® Format) files. TAPro and TA Online can import these files.

TAPro includes a file import utility.  During file import TAPro remembers your decisions and creates an Import Template for the selected broker and file type.  During the next import of the same file type, for the same broker, you can reuse a template and apply prior decisions automatically.  TAPro maps import field names to standard field names.  Fields that are not mapped are assigned the name "extra" and not imported. 

During import TAPro confirms symbol types (stocks, Calls, Puts etc.).  If the data includes Exercise/Assign/Expire events then also define the option's underlying details after the import (using File/Add Modify Symbols).

Here is a video with more details - click here.

Here is a list of field names that TAPro can import:

Date Transacted, Date Settled, Action, Quantity, Symbol, Description, Price, Commission, Sec. Fee, Misc. Fee, Fed. Tax, Ex./Assign Basis Adj, Basis Adj, Amount, Account, ID, Note

Below are suggestions of how to import various file types.

A. QFX/OFX Import:
Downloads to Quicken(tm)/Money(tm) often use .QFX/.OFX.  Remember to save the file with an extension of .QFX or .OFX so TAPro can identify it correctly.  Within TAPro select File/Import/File.

Here is a video with more details - click here.

B. QIF Import:
Downloads to Quicken(tm)/Money(tm) also use .QIF format.  Remember to save the file with an extension of .QIF so TAPro can identify it correctly.  Within TAPro select File/Import/File.

C. TAB Delimited Import:
Download the file in an Excel format offered.  Open the file and save the file as TAB Delimited (using Excel, File/Save As/...).  Within TAPro select File/Import/File.

If you edit the file with Excel or Notepad, consider the following simplified format:

Date Transacted, Action, Quantity, Symbol, Price, Commission
03/20/2006  Buy  100.00  CSCO  22  9.95

D. CSV Delimited Import:  
Download the file in an Excel format offered.  Open the file and save the file as Comma Delimited (using Excel, File/Save As/...). 

Here is a video of .CSV import with more details - click here.

If you edit the file with Excel or Notepad, consider the following simplified format:

Date Transacted, Action, Quantity, Symbol, Price, Commission
03/20/2006, Buy, 100.00, CSCO, 22, 9.95

Data is sometimes provided as one long quoted row that looks like the example below. 

"03/20/2006, Buy, 100.00, CSCO, 22, 9.95"

This will cause an error because the quotes at the end of the string define it as one field instead of comma separated fields.  The file does not follow the .CSV standard.  This is easily corrected with Notepad, search for " and replace it with nothing.

03/20/2006, Buy, 100.00, CSCO, 22, 9.95

Watch for commas hidden in number fields.  The example below will cause and error because the thousands separator is a comma. 

09/20/2006, Buy, 1,000.00, CSCO, 22, 9.95

In Excel, select all columns with numbers, select "Format Cells", select "Number" and remove the check mark from the "Use 1000 Separator" box, see below.

3. Request Import Help: