This dialog is available from the File / Import / Transactions / Scottrade... menu command.
Transaction 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. Scottrade also refers to this format as their "fixed-width" format.
You can import these Y<DATE>TR.TR1 transaction files into Fund Manager. During the transaction import Fund Manager will also automatically look for a *SC.SE1 file in the same folder as each *TR.TR1 file to obtain security names for the imported transactions. These security names will be used when it is necessary to create new investments.
Video Tutorial: See the Tutorial on Importing Position/Transaction Files.
Getting Started Tip:
When first getting started, you may want to import positions as of a certain date, and then import transactions from that date forward. If you have all the transaction data available back to inception, you can skip importing positions, and just import all the transaction data.
|
TR1 File(s) to Import |
Select which file(s) to import. You can either import a single file, or all the files in a single folder. |
|
Accounts to Import from TR1 File(s) |
Choose whether to import all accounts in the selected files, or only a particular account. Use the "Scan TR1" button to fill in the list of available accounts in the importing file(s). |
|
Date Range to Import |
Choose the date range to import transactions. |
|
Import into Fund Manager Portfolio |
Specifies the portfolio where transactions will be imported into. Select a specific portfolio, or have Fund Manager match the account numbers from the importing file with the assigned portfolio account number. When this "matching" option is selected you can choose the "Create New Sub-Portfolios as Needed" option to have new portfolios created when a matching portfolio account number cannot be found. |
|
Import Options |
Specify whether to skip transactions that are already recorded. Also specify if new investments should be created when a matching investment could not be found. Fund Manager matches investments based on the CUSIP investment property, and the CUSIP in the importing file. 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(s) will be read in, and you will be taken to the Preview Importing Transactions page to see what transactions will be imported.
Notes:
When you have a new account, or investments in an account, Fund Manager can/will create these for you automatically when it finds them in your .TR1 file(s).
Fund Manager matches up the account number in the .TR1 file(s) with the account numbers of a sub-portfolio. When it finds a match, it then matches up a transaction based on the CUSIP in the .TR1 file and the recorded CUSIP of investments in the sub-portfolio which matched up the account number.
If no sub-portfolio with a matching account number could be found, Fund Manager will create a new sub-portfolio. On the import dialog you specify under what existing sub-portfolio this new sub-portfolio should be created. See the options: "Import Into Fund Manager Portfolio: With Matching Account Number As TR1 Account" and "Create New Sub-Portfolios as Needed Under:".
If no investment with a matching CUSIP is found in the previously matched sub-portfolio, then Fund Manager will create a new investment file. Make sure the "Create New Investments As Needed" option is turned on when you do the import. Also, check the "Options..." button next to it to assign a folder for the newly created investments.
Once a matching investment is found, the transaction in the .TR1 file will be imported into that investment.
Preview Importing Transactions Dialog
Tutorial on Importing Position/Transaction Files