Simple Generic Price/Distribution Import Question

[Septaj]

I used to know how to do this in one easy import. Has something changed?

2012/03/12,25.1,0.01

yyyy/mm/dd,NAV,distribution per share.

Thx

[Mark]

Hi Septaj,

Which import command are you using? The Generic Price Import only imports pricing, not distributions. The Generic Transaction Import command can import transactions, including distributions or distributions per share when you don't own any shares.

In both commands the keywords to match that date string would be: YY/MM/DD, not yyyy/mm/dd. The keywords are capital, and only 2 characters, not 4 for the year. The YY keyword matches either a 2 or 4 digit year.

[Septaj]

Was it not previously the case that one could import prices and distributions in one go?

[Mark]

Hi Septaj,

You've never been able to do this in Fund Manager. Importing prices and transactions are separate, and distributions are considered transactions.

[Septaj]

OK, I just cannot see how to do this.

I do not own any shares. I have this data in my CSV files:

MM/DD/YY,NAV,Distribution per share.

I have been able to import the prices.

What is the string for importing the distributions per share?

I have tried many things. For example:

MM/DD/YY,XX,TRAN,ANUM,BNUM,CNUM where I have entered DIST_D for TRAN, 1 for BNUM, and 0 fo CNUM ...

Thx

[Mark]

Hi Septaj,

Your CSV file needs some more fields. You have to have a field for the transaction, ANUM, and BNUM. You don't need the NAV for this, so you can either remove it, or skip that field. So, make your CSV file look something like this:

01/02/2012,DIST_D,0,1,0.25

where this is going to import as a dividend of 0.25/share on Jan 2, 2012.

For your generic transaction import format string, use:

MM/DD/YY,TRAN,ANUM,BNUM,CNUM

and since you don't have a symbol, you must choose the "Import Destination" option to import into a specified investment.