manual price entry for security in several accounts

[ethanyale]

I'm a new user (personal version). I have six 529 accounts with my state. No online transaction or price updating available. I imported from quicken using QIF, and automatically created new accounts. Every account contains the same two securities. When I manually update the price of one of the securities, it does not cascade through all of the accounts. I assume this is because when the new investments were created I used the <symbol>_<account #>.dat format, so each account has a security that is considered unique. How to I teach FM that the securities are the same so pricing data is consistent? Thanks for your help.

[Mark]

Hi ethanyale,

When manually updating prices for an investment, it only updates that one investment, even if there are other investments in different accounts with the same symbol. The filenames do not matter.

Since your prices aren't available online you could use the generic price import, so that you only have to do 1 import to update everything. When importing, all investments with a matching symbol are updated. See "File / Import / Prices / Generic...". Press the "Help..." button for instructions.

The file could be something simple like:

INTC,22.50
IBM,97.50

and then you would "specify" the date in the dialog during import, and use a format string of:

SYMB,NAV

for this example. Each day you could use the same file, but just change the prices and specified date.

[MDAnderson]

Glad I had a look around this board before posting, this is perfect for my issue with preferreds and bonds when I'm updating multiple subportfolios several days after the end of the month. Several of my sub-portfolios contain the same investments, and I wanted to be able to update them all at the same time. I'll give this a try. Thanks!