Re: Importing from TD Waterhouse/Centerpiece

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Importing from TD Waterhouse/Centerpiece posted by Mark on February 21, 2005 at 17:13:06:

Is there any way to import current positions into fund manager, from an Excel spreadsheet, a CSV file, or any other format?

: : Mark,

: : I've spent a couple of hours now looking at the software and the tutorial and I'm still confused about how to get it started when doing downloads from TD Waterhouse. Do I manually enter all current positions? What if a account is added, do I manually have to add their information as well? All of that data is in the Centerpiece download (such as all current holdings and current price) but it doesn't seem to be getting into Fund Manager. If you could give me a simple, step 1, step 2, step 3 to get me going I'd *really* appreciate it.

: : Thanks,

: : Don Steinmann

:
: Hi Don,

: Getting started can be the hardest part... Let me try to explain.
: When importing from TD Waterhouse/Centerpiece only the .TRN file(s) are used. These files contain the transactions. Fund Manager does not import current
: positions from these files. You may want to manually set up the initial accounts
: and investments as of a certain date, and then use this import for updating
: transactions going forward from that date. 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 .TRN file(s).

: When you set up your sub-portfolios you'll want to assign the account numbers
: to the properties of each sub-portfolio. Fund Manager matches up the
: account number in the .TRN file(s) with the account numbers of a sub-portfolio.
: When it finds a match, it then matches up a transaction based on the symbol
: in the .TRN file and the recorded symbol 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
: TRN Account" and "Create New Sub-Portfolios as Needed Under:".

: If no investment with a matching symbol 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 .TRN file will
: be imported into that investment.

: To set up your current positions/accounts you might want to use the
: "New Portfolio Setup Wizard" under the "File" menu. You'll also find the
: "Portfolio Editor" window helpful in managing your sub-portfolios.

: Let me know if you have any other questions. I noticed the online help is a little sparse here, I will plan to add some of the above to that topic.

: Thanks,
: Mark
: --
: Mark Beiley
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003
:

Replies:

• Re: Importing from TD Waterhouse/Centerpiece Mark 09:38:53 02/28/05 (0)
• Re: Importing from TD Waterhouse/Centerpiece Faith 15:18:10 02/24/05 (0)