Importing Positions from TD Ameritrade

This dialog is available from the File / Import / Positions / TD Ameritrade... menu command.

Position data can be imported from "TD Ameritrade" generic formatted ADyymmdd.POS files, available for download from TD Ameritrade. During the position import Fund Manager will look for corresponding *.SEC and *.PRI files with the same base filename as the *.POS file. These additional files contain closing pricing and additional security information, such as the security names and types. If they are found, this additional information will also be imported.

Video Tutorial: See the Tutorial on Importing Position/Transaction Files.

POS File to Import

Select which *.POS file to import.

Accounts to Import

Choose whether to import all accounts in the selected file, or only a particular account. Use the "Scan POS" button to fill in the list of available accounts in the importing file.

Import Options

Choose options for creating the new investments.

Choose whether to import all positions into a new sub-portfolio:

When this option is on, type the name of the new sub-portfolio where all the positions will be placed. No existing sub-portfolios will be modified in this case. When importing positions for reconciliation purposes, you should import into a new sub-portfolio.
When this option is off, Fund Manager will look through your existing sub-portfolios to try and find a match based on account number. If no matching account number is found, the new sub-portfolio will be created at the top level of the portfolio hierarchy. If a matching sub-portfolio is found, the positions will be updated in there. When the sub-portfolio is already existing, Fund Manager will look for matching investments in that sub-portfolio based on symbol. If an existing investment match could not be found, a new investment will be created.

Press the "Next" button after filling in all of the above fields. The importing file will be read in, and you will be taken to the Preview Importing Positions page to see what transactions will be imported.

Important Note on Cost Basis:

When importing positions there is no cost basis data available. Therefore, all positions will be created with a cost basis of zero. To adjust the cost basis, use the Data Register and edit the initial purchase price and value.

See Also