In microsoft.public.money, Brannon wrote:

- quote -

You might try customizing the "Performance by investment account"
and similar reports. There you can set a date range. Note that the
Annual%Return is a more complex IRR calculation like the APR of a
bank account.



- quote -

After I did the math on it, I think that's exactly what's happening. I did
what you suggested previously and changed my old transactions (including
dividends) to DUK_Sold. They're 2 years old, so I won't be using them on
this years taxes anyway. I just wish I could get Money to show current Gain
w/out including those old dividends. Still open to any other ideas. Thanks
though. At least I know Money isn't just making up numbers!

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

My suspicion is that for Gain, which includes dividends, that the
old dividends earned by the old shares are being attributed to the
current holdings. The PriceAppreciation column ignores dividends. So
it could be of use. Today nobody says that dividends don't matter.
That was a very common claim late in the previous century, but not
from DUK investors.

If you had no old dividends during the last year, the TR return
columns as far back as a year could be useful too.

OK Cal...you were partially right...I was partially wrong. Here's the
scenario.
I backed up and deleted the new transaction so everything was old (and
closed). I checked "Show Closed Positions" and the grey 'Gain' amout shown
was 644.38.

Next, I recorded a mock buy of $100.00 of DUK at $15.81. It closed today at
$15.45, leaving a net loss of $2.28 for the day (and overall). This is the
'Gain' amount I want displayed.

If I Mark 'Show Closed Positions', it shows a Gain of $642.10... This is the
old value of $644.38 minus the loss for the day $2.28. (This is correct).

Now, if I uncheck 'Show Closed Positions', the 'Gain' changes to $194.46.
(I have no idea where the heck this number comes from.) My previous
assumption was incorrect. I had to pull an old datafile and re-create this
scenario...but as you can see, $194.46 is not the number I need.

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

Are you saying that if you have a mix of open and closed positions
in a security and toggle ShowClosedPositions, that the
PriceAppreciaton column and Gain column do not change?

They do when I try it on Money 2007.

I wish that was the case, but it isn't. Deselecting 'ShowClosedPositions'
will do just that...make 'truly closed' positions disappear from view.
However, if you buy the security again, Money, in effect, re-opens the
position and includes any profit or loss related to the original closing
(complete sale) of said security along with the present position [gain]
(current value minus current basis).

If Money did what you described, that would be ideal. Wish it could...maybe
it can...but it's not by use of the ShowClosedPositions checkmark. And I
can't find any other way to make it do it; and believe me, I've looked!!

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

In that case, de-selecting ChangePortfolioView-> ShowClosedPositions
should cause the Portfolio PriceAppreciaton column should tell you
what you what your current value minus the current basis is. The
Gain column would be the same, except that it includes dividends.


- quote -

Money 2007 (I think Ver. 16.x...)

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

I assume you are using an older version of Money.


- quote -

I think that'll do it. I do my Sched. D the old-fashioned way. I wish I
could keep the old transactions there, but like I said, it throws off my
Gain. I just bought shares today, DUK dropped a few cents/share, and I still
showed a profit. I know that's the 'overall' picture, but I could care less
about that now. I want to know the performance of the Money I just put in,
my dividend reinvestments, and any future money I put into DUK...not so much
how I've fared investing in DUK over the past 5 years off-and-on.

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

I thought you were talking about the Gain column on the Portfolio in
your original post.

To do what I think you say you want to do, create a new stock called
DUK_sold old, with no symbol. Do a fake big AddShares of DUK
pre-dating the oldest existing DUK transaction. Change each old DUK
transaction from DUK to DUK_sold, starting with the oldest
transaction. Then Delete the fake DUK AddShares.

If you are going to have Money fill out your schedule D, don't
actually call it DUK_sold; that name goes onto your schedule D.

I don't actually recommend that you do that. Your latest objection
is that you see the old transactions in the list of the transaction
history. That's the way I would want it to be.

- quote -

Already done... That just hides the stocks that you have sold all shares of.
Once I enter the buy on the previously owned stock (in this case DUK), then
pull up the transaction history for that stock, all the old transactions are
listed as well (which is the issue I'm trying to correct/prevent).

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Brannon wrote:

- quote -

Try de-selecting ChangePortfolioView-> ShowClosedPositions.

I recently re-invested in a stock that I haven't used since 2006 in one of my
investment accounts. I also bought 4 other stocks that were new to me. The
4 new ones show a Gain amount equal to their cost minus their current
value...what it should be. The other, however, (I believe) is taking that
amount and adding it to the amount that I profited 2 years ago...which throws
everything off for me. Is there any way to make Money think this is a new
investment so the Gain will make sense for this year, and not add in data
from years past?