Importing Positions from Scottrade


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


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


Position data can be imported from Scottrade.  As an investment advisor with Scottrade you will be emailed pricing, transaction, security, and position data files each day.  To make sure these files are formatted properly, inform Scottrade you are using Fund Manager Advisor, and wish for your data files to be sent in this format.


You can import the YCAPPS.PS1 position file into Fund Manager.  During the position import Fund Manager will also automatically look for a YCAPSC.SE1 file in the same folder as your YCAPPS.PS1 file to obtain security names for the imported positions.


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


PS1 File to Import

Select which *.PS1 file to import.

Accounts to Import

Choose whether to import all accounts in the selected file, or only a particular account.  Use the "Scan PS1" 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 CUSIP.  If an existing investment match could not be found, a new investment will be created.

Advanced:  If you would rather have Fund Manager match on 'symbol' instead of 'CUSIP', create a string registry value for 'scottrade_match' equal to '0' at the following location:

HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\miscprefs



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:

Scottrade does provide cost basis information in the position file, and Fund Manager will use this to record the position at the specified cost basis.

See Also

Importing Positions

Importing Scottrade Transactions

Importing Scottrade Prices

Importing Transactions

Retrieving Transactions

Preview Importing Positions Dialog

Tutorial on Importing Position/Transaction Files


Fund Manager Home