|
#7
| |||
| |||
| In microsoft.public.money, brettrkr[at]gmail.com wrote: - quote - > Thanks. I guess this goes for the "Gain" column as well than.
Gain is affected by SeeADifferentView-> ShowClosedPositions.> Concluding, is "TR all" the gain/loss (dividends included) over the > life of that portfolio? Note that the PriceAppreciation column does not include dividends as Gain does. |
|
#6
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Jose wrote: - quote - > Why on earth would Microsoft calculate a % gain using only the cost
There are what -- 60 or so good useful columns to choose from?> basis of the remaining shares???? > Good point from Cal: Stay away from %Gain. Now I will!! Having just one dud available is not bad. |
|
#4
| |||
| |||
| On Sep 24, 5:31*am, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote: - quote - > In microsoft.public.money, brett wrote:
Interesting... This is what it does:> > 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. 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
| |||
| |||
| In microsoft.public.money, brett wrote: - quote - > I've created a test account. It has $1000 cash. I bought a KEP at
Sell 90% for $20. You will see a big difference.> $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. |
|
#2
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, brett wrote: - quote - > I'm using Money Plus Deluxe. What is the difference between these two
I recommend that you configure to not use the "%Gain" column.> 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. 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. |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |