Re: Splitting transactions between portfolios

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

In Reply to: Splitting transactions between portfolios posted by Dave Planting on January 04, 2005 at 18:26:18:

: Just upgraded to Version 7. In past versions I've simply combined any like stock/fund purchases in the one master portfolio, even though the stock or fund was purchased in two different broker accounts (IRA vs Keogh). I'd like to now use the new sub-portfolio feature and separate the transactions by their correct broker account. I know which transaction belongs where because I've used the memo field of the transaction editor to record the correct broker account.

: So far I've been able to duplicate the holding in the sub-portfolio by using the copy/paste function, but when I try to delete a specific transaction in one sub-portfolio it deletes it in all others at the same time. Is there any way to tell a specific transaction which portfolio it belongs to without having to go back and manually reinventing history? If I do have to delete and then re-enter transactions, will I have to create a new investment file, i.e. GE#1 and GE#2?

: Thanks

Hi Dave,

When you used copy/paste to copy an investment to multiple sub-portfolios
you created another instance of the same investment file (*.dat). What you
will want to do is create unique investment files for each investment that
has its own transaction history, i.e. GE1.dat and GE2.dat. Given that you
already have the transactions entered into 1 investment file, I'd suggest
making a copy of that investment file in Windows Explorer, or however you
like to copy files, and then opening that copy into the other sub-portfolio.
You can then just delete the transactions that don't belong in that
investment. This way, you don't have to re-enter any transactions, just
delete the appropriate ones out of each of your investment files.

To help see what is going on, use the Portfolio Editor, and look in the
"Location" and "Filename" fields to know for sure which investment you are
editing.

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

Replies: