This problem is giving me a headache! I am struggling with
how best to set up a workbook to track various transactions
in a mutual fund.

Does anyone have a good design for that?

If so, feel free to mail it "curiousgeorge408" at "hotmail.com".

I don't like any of the the MS templates that I have looked at.

Of course, I need to track buys, including reinvested dividends,
and sells, with related basis. I also need to track splits and
"journal" transfers to other accounts in the same brokerage. I
have not yet decided whether to use actual basis or single
category average basis for shares sold. So I need to design
the workbook with that flexibility in mind.

The problem I wrestle with is: how to organize the data and
computations so that I can track how many shares remain
in each purchase lot and with what basis after several sells
over time?

Any constructive thoughts would be appreciated. My thoughts
are going in circles.

PS: I am an occassional seller, not a day trader. I tend to
sell once or twice a month.