Re: No edit/copy for distribution data

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

In Reply to: No edit/copy for distribution data posted by Marden Seavey on November 29, 2005 at 08:25:48:

: I've been searching for a way to capture monthly and/or quarterly distributions to a file. This would be as a function of the date. It appears that from the report function one can do this, but that only gives the totals. I want to be able to work with distributions as a function of time in excel, say.

: Guess there's no way to do this except by hand at present?

: Thanks,
: Marden

Hi Marden,

You can use the "File / Export / Transactions / Fund Manager Text..." menu command. Each investment gets exported to 3 files:

.PRC - contains pricing information
.INV - contains buy/sell transactions
.DIV - contains distribution data

The format of the .DIV file is space delimited, with each distribution on its own line. It will read into Excel nicely. Each line has these 5 fields:

month day year distribution_per_share shares_repurchased

If the distribution was distributed, the 'shares_repurchased' field will be 0, otherwise it shows the number of shares reinvested.

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

Replies:

• Re: No edit/copy for distribution data Marden Seavey 11:14:10 11/29/05 (0)