Re: FM7 Beta4 *.dat file Issues with subportfolios - Importing Transactions

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

In Reply to: FM7 Beta4 *.dat file Issues with subportfolios - Importing Transactions posted by George on December 12, 2004 at 02:13:17:

Hi George,

See my replies below:

: Hi Mark
: Ive set up two sub-portfolios, one for each of my broker accounts.

: Ive set up a group of investment files for each set of share prices. Then I imported the respective share price history into each from my ascii data files from my local HD.

: I am about to retry and reimport the transaction history for each of the two brokers. I think I need to set the active sub-portfolio just before I do this - so that the transactions are assigned to the correct sub-portfolio ?

No, you don't have to set the active sub-portfolio, this doesn't affect
importing. I'm guessing you are using the Generic transaction import.
When you import you pick the destination sub-portfolio, so all your
transactions will go into that sub-portfolio.

: Do I have to create duplicate investment *.dat files for the two seperate
: sub-portfolio Transaction imports ? Or is FM able to track which transactions belong to which sub-portfolio accounts , using the one common investment data file for a common share transaction ?

If you have the same security in 2 different brokerage accounts, you would
want to create an investment file (*.dat) for each one, so you can track
the transaction history separately. Investment files contain the price
and transactions, so to track separate transactions you need separate investment
files.

: Example there are instances where I traded the same share but at different times with the two different brokers.

: Otherwise Im confused as to how FM handles knowing which investment file to assign the transactiosn for each sub account without getting conflicts.

See above, hopefully that clarifies it...

: I tried copying and dragging common share investment files to the two seperate sub-portfolios via the portfolio editor page. I managed to pull conflicts for the cash accounts used (sub-portfolio 1 sees transactions made for cash account 2, sub-portfolio 2 and vice versa).

You can have the same investment file in multiple sub-portfolios, but from
what you've described you wouldn't want to do that. As an example, say you
owned IBM in 2 brokerages. You would create one investment file (IBM1.dat)
and put it in one sub-portfolio, and a second investment file (IBM2.dat)
and put that in your other sub-portfolio.

: To fix the problem - is the easiest way to delete all transactions, but leave the price data. Then re-import the transaction file histories for about 4 years and the two sub-portfolios.

I'm not sure where you're at, hopefully my explanation of how this works will
help you decide the best way to straighten it out.

: There are about 100 investment files full of price data and mixed sub-portfolio transactions now.

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

Replies: