Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 09-25-2008, 04:28 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

In microsoft.public.money, brettrkr[at]gmail.com wrote:

- quote -

> Thanks. I guess this goes for the "Gain" column as well than.
> Concluding, is "TR all" the gain/loss (dividends included) over the
> life of that portfolio?


Gain is affected by SeeADifferentView-> ShowClosedPositions.


Note that the PriceAppreciation column does not include dividends as
Gain does.
  #6  
Old 09-25-2008, 03:41 AM
brettrkr@gmail.com
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

Thanks. I guess this goes for the "Gain" column as well than.

Concluding, is "TR all" the gain/loss (dividends included) over the
life of that portfolio?
  #5  
Old 09-24-2008, 10:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

In microsoft.public.money, Jose wrote:

- quote -

> Why on earth would Microsoft calculate a % gain using only the cost
> basis of the remaining shares????
> Good point from Cal: Stay away from %Gain. Now I will!!


There are what -- 60 or so good useful columns to choose from?
Having just one dud available is not bad.
  #4  
Old 09-24-2008, 04:06 PM
Jose
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

On Sep 24, 5:31*am, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, brett wrote:
> > I'm using Money Plus Deluxe. *What is the difference between these two
> > columns? *Their values are very different from each other. *TR all
> > might be down by -1.1% but % gain will be down by -6.3% for the same
> > position/account.

> I recommend that you configure to not use the "%Gain" column.
> There are so many useful columns available in the Portfolio, and
> for me "%Gain" is not one.
> The main difference between % Gain and Total Return All (TR all)
> appears to differ if sales have been made. *Both appear to take
> dividends into account.
> If showing sold securities, %gain can go negative ... *buy at 100,
> sell at 1, big negative.
> test buy 100 at $10.00
> Sell 99 at $10.10
> %gain says 100% *TR All says 1%
> So, to reiterate, get rid of %gain and use the TR columns. There are
> dozens of useful columns for the portfolio. You found the weird one.


Interesting... This is what it does:

Buy 100 [at] $10.00
Sell 99 at $10.10 - proceeds are $999.90, cost basis is $990, so
capital gain is $9.90 (1%, as defined by TR)

Now you hold 1 share worth $10.10, with a cost basis of $10.00. But
the total gains from that security is:
- $9.90 gains already in your pocket
- $0.10 gains still not realized
TOTAL: $10.00 gains, which based on your cost basis of the "remaining"
shares, is 100% gain!

Why on earth would Microsoft calculate a % gain using only the cost
basis of the remaining shares????

Good point from Cal: Stay away from %Gain. Now I will!!

  #3  
Old 09-24-2008, 01:27 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

In microsoft.public.money, brett wrote:

- quote -

> I've created a test account. It has $1000 cash. I bought a KEP at
> $10. It is now at $13.50. Both columns show +35%. I then changed
> my purchase price to $15. Both columns show -10%. Looks like the
> difference might be in how they handle dividends but I can't tell with
> this simple test.


Sell 90% for $20. You will see a big difference.
  #2  
Old 09-24-2008, 01:22 PM
brett
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

I've created a test account. It has $1000 cash. I bought a KEP at
$10. It is now at $13.50. Both columns show +35%. I then changed
my purchase price to $15. Both columns show -10%. Looks like the
difference might be in how they handle dividends but I can't tell with
this simple test.
  #1  
Old 09-24-2008, 12:31 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

In microsoft.public.money, brett wrote:

- quote -

> I'm using Money Plus Deluxe. What is the difference between these two
> columns? Their values are very different from each other. TR all
> might be down by -1.1% but % gain will be down by -6.3% for the same
> position/account.


I recommend that you configure to not use the "%Gain" column.
There are so many useful columns available in the Portfolio, and
for me "%Gain" is not one.

The main difference between % Gain and Total Return All (TR all)
appears to differ if sales have been made. Both appear to take
dividends into account.

If showing sold securities, %gain can go negative ... buy at 100,
sell at 1, big negative.

test buy 100 at $10.00
Sell 99 at $10.10
%gain says 100% TR All says 1%


So, to reiterate, get rid of %gain and use the TR columns. There are
dozens of useful columns for the portfolio. You found the weird one.

 
Old 09-24-2008, 11:30 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: "TR all" vs. "% gain" in portfolio view?

I think Total Return takes dividends into account and Gain is just capital
gain.

"brett" <account[at]cygen.com> wrote in message
news:79f1073a-3557-4fac-b3af-c9303dc8ece5[at]q5g2000prf.googlegroups.com...
- quote -

> I'm using Money Plus Deluxe. What is the difference between these two
> columns? Their values are very different from each other. TR all
> might be down by -1.1% but % gain will be down by -6.3% for the same
> position/account.



  #-1  
Old 09-24-2008, 05:17 AM
brett
Guest
 
Posts: n/a
Default "TR all" vs. "% gain" in portfolio view?

I'm using Money Plus Deluxe. What is the difference between these two
columns? Their values are very different from each other. TR all
might be down by -1.1% but % gain will be down by -6.3% for the same
position/account.
 

Tags
% gain, portfolio, tr all, view
Similar Threads
Thread Forum Replies Last Post
MSN De Lux Portfolio showing wrong data In the "% Gain" and "Averege Cost" columns
Fulvio Bizzaro: Hi, have a problem with the DeLux Portfolio: Since some days, from September 2008 the calculation in the Gain/Loss is not accurate: It is...
Microsoft Money 8 10-05-2008 10:41 PM
"news" and "fyi" links on the "Track My Portfolio" page
tom: no longer work in my Money 2000. When I click them, I get "MSN Money-Page Not Found" and "The page you requested could not be found." But there is a...
Microsoft Money 7 10-25-2007 11:34 PM
Portfolio not updating "today's change" & "last updated" fields
evy38: Does anybody know why portfolio is not updating these fields?
Microsoft Money 1 06-13-2006 05:05 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:57 AM.