Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 10-05-2008, 10:41 PM
lonehunter69
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

Thanks for your post.

It happens that "tho Companhia Vale do Rio Doce" is in the portfolio and it
is denominated in $ and it is an ADR since the shares were purchased in New
York.

There is not a single stock not purchased on Wall Street and all of them are
denominated in $, the account currency is $ also.

It is strange but reading other posts, I am not the only one having
miscalculation problems, some have the purchase cost displayed wrongly, mine
is the %TRall or the %gain, what ever I choose to display.

Problem is not going away, unfortunatly

Best Regards.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, lonehunter69 wrote:
> > > I re-inserted all the entries of the portfolio with the accurate purchase

> > cost of the shares and the calculation of the TrAll column was OK.
> > > This lasted only a couple of days and I noted that the TrAll calculation

> > started to move away and adding a few cents a day to the TrAll increasing the
> > value of the gains.
> > > I suspect that MSN Money is accounting for exchange rates, even if the

> > Portfolios are all in US$ and the stocks trade on Wall Street.

> If your file and account are in USD, in Microsoft Money you would
> want to set the Country in the investment Details to United States.
> This would apply to a stock like RIO traded on NYSE as an ADS, even
> tho Companhia Vale do Rio Doce is really a Brazilian company.
> I don't know how that would be handled in MSN Money. Is the
> AccountCurrency in USD? If not, I would make that change.
> > > Wiil greatfull if someone can suggest a solution.

  #6  
Old 09-30-2008, 06:02 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

In microsoft.public.money, lonehunter69 wrote:

- quote -

> I re-inserted all the entries of the portfolio with the accurate purchase
> cost of the shares and the calculation of the TrAll column was OK.
> This lasted only a couple of days and I noted that the TrAll calculation
> started to move away and adding a few cents a day to the TrAll increasing the
> value of the gains.
> I suspect that MSN Money is accounting for exchange rates, even if the
> Portfolios are all in US$ and the stocks trade on Wall Street.


If your file and account are in USD, in Microsoft Money you would
want to set the Country in the investment Details to United States.
This would apply to a stock like RIO traded on NYSE as an ADS, even
tho Companhia Vale do Rio Doce is really a Brazilian company.

I don't know how that would be handled in MSN Money. Is the
AccountCurrency in USD? If not, I would make that change.

- quote -

> Wiil greatfull if someone can suggest a solution.
  #5  
Old 09-30-2008, 05:44 PM
lonehunter69
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

Thanks to all,

I parted away witht he %gain column as suggested by Cal and I am using the
TrAll.

I re-inserted all the entries of the portfolio with the accurate purchase
cost of the shares and the calculation of the TrAll column was OK.

This lasted only a couple of days and I noted that the TrAll calculation
started to move away and adding a few cents a day to the TrAll increasing the
value of the gains.

I suspect that MSN Money is accounting for exchange rates, even if the
Portfolios are all in US$ and the stocks trade on Wall Street.

Wiil greatfull if someone can suggest a solution.

Thanks
Fulvio

"Aviator" wrote:

- quote -

> Ah yes, of course. I misinterpreted your answer to mean that there was a
> setting within Money that allows TR to be calculated with or without
> dividends.
> > Most people have their dividends and capital gains distributions
> > automatically used to buy more shares. Since these are Buy
> > transactions, they count toward the cost of the shares. So a
> > ReinvestDividend is equivalent to a Dividend and a Buy.

>
  #4  
Old 09-08-2008, 10:18 AM
Aviator
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

Ah yes, of course. I misinterpreted your answer to mean that there was a
setting within Money that allows TR to be calculated with or without
dividends.


- quote -

> Most people have their dividends and capital gains distributions
> automatically used to buy more shares. Since these are Buy
> transactions, they count toward the cost of the shares. So a
> ReinvestDividend is equivalent to a Dividend and a Buy.

  #3  
Old 09-08-2008, 01:22 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

In microsoft.public.money, Aviator wrote:

- quote -

> Please help me understand your comment [Check for
> ReinvestDividend to account for "Average Cost". ]
> How does one check for ReinvestDividend for average cost?


Most people have their dividends and capital gains distributions
automatically used to buy more shares. Since these are Buy
transactions, they count toward the cost of the shares. So a
ReinvestDividend is equivalent to a Dividend and a Buy.
  #2  
Old 09-07-2008, 11:59 PM
Aviator
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "A

Cal,

Great advice, as usual.

Please help me understand your comment [Check for
ReinvestDividend to account for "Average Cost". ]

How does one check for ReinvestDividend for average cost?

Thanks in advance.



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Fulvio Bizzaro wrote:
> > Hi,
> > > have a problem with the DeLux Portfolio:

> The group for MSN Money /MoneyCentral is
> microsoft.public.moneycentral. I will comment here for now. See
> below.
> > > > > Since some days, from September 2008 the calculation in the Gain/Loss is not

> > accurate: It is adding about 10% to the correct figure. No settings where
> > changed!!!
> > > > > I am using Win Vista Business since a year and everything was OK untill some

> > days ago.
> > > > > In the "Performance View" of the Portfolio, the columns "% Gain" and

> > "Avarage Cost" are not displaying the correct figures. This affects the
> > whole portfolios values and Gain/Loss calculations rendering the complete
> > software useless.

> I don't know about the problem with the "Average Cost". Maybe there
> was a reinvestment of dividends that changed that average. See below
> for comment on %gain.
> > > > > I have US stocks in the Portfolios ans the Portfolios are denominated in

> > US$; When I insert any new transaction (buy A Stock) it displays an exchange
> > dialog box for conversion of £ into $; I ignored this for all these months
> > and have not problem untill some days ago.
> > > > > I used the Delux Portfolio it for several years without problems and I

> > re-installed the latest version after this problem started.
> > > > > This appears to be the result of the wrong amount displayed in the column

> > "Avarage Cost" that price have been diminished by about 10% for all the
> > stocks and for all the portfolios.
> > > > > The closed positions of the Portfolios are not affected by this new

> > calculation and are all OK.
> > > > > If I delete any wrong transaction and re-enter into the Portfolio the

> > display of the Avarage Cost and % Gain is correct, but this is a long way
> > and the problem may come back again.
> > 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. Check for
> ReinvestDividend to account for "Average Cost".
> > > > Does anyone experiance something so devastating and have any suggestion?

> Such drama.

  #1  
Old 09-07-2008, 10:18 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "Averege Cost" columns


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:9vu7c4dva30s4p3f0goo3ndu1ovalbes5q[at]4ax.com...
- quote -

> In microsoft.public.money, Fulvio Bizzaro wrote:

<snip> >

- quote -

> > Does anyone experiance something so devastating and have any suggestion?
> Such drama.


Cal,
My guess is that English is not this poster's first language and his last
line reflects a bad "bablefish" translation.
--
Peace,
BobJ


 
Old 09-07-2008, 04:52 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MSN De Lux Portfolio showing wrong data In the "% Gain" and "Averege Cost" columns

In microsoft.public.money, Fulvio Bizzaro wrote:

- quote -

> Hi,
> have a problem with the DeLux Portfolio:


The group for MSN Money /MoneyCentral is
microsoft.public.moneycentral. I will comment here for now. See
below.

- quote -

> Since some days, from September 2008 the calculation in the Gain/Loss is not
> accurate: It is adding about 10% to the correct figure. No settings where
> changed!!!
> I am using Win Vista Business since a year and everything was OK untill some
> days ago.
> In the "Performance View" of the Portfolio, the columns "% Gain" and
> "Avarage Cost" are not displaying the correct figures. This affects the
> whole portfolios values and Gain/Loss calculations rendering the complete
> software useless.


I don't know about the problem with the "Average Cost". Maybe there
was a reinvestment of dividends that changed that average. See below
for comment on %gain.

- quote -

> I have US stocks in the Portfolios ans the Portfolios are denominated in
> US$; When I insert any new transaction (buy A Stock) it displays an exchange
> dialog box for conversion of £ into $; I ignored this for all these months
> and have not problem untill some days ago.
> I used the Delux Portfolio it for several years without problems and I
> re-installed the latest version after this problem started.
> This appears to be the result of the wrong amount displayed in the column
> "Avarage Cost" that price have been diminished by about 10% for all the
> stocks and for all the portfolios.
> The closed positions of the Portfolios are not affected by this new
> calculation and are all OK.
> If I delete any wrong transaction and re-enter into the Portfolio the
> display of the Avarage Cost and % Gain is correct, but this is a long way
> and the problem may come back again.


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. Check for
ReinvestDividend to account for "Average Cost".

- quote -

> Does anyone experiance something so devastating and have any suggestion?

Such drama.
  #-1  
Old 09-07-2008, 03:20 PM
Fulvio Bizzaro
Guest
 
Posts: n/a
Default MSN De Lux Portfolio showing wrong data In the "% Gain" and "Averege Cost" columns

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 adding about 10% to the correct figure. No settings where
changed!!!



I am using Win Vista Business since a year and everything was OK untill some
days ago.



In the "Performance View" of the Portfolio, the columns "% Gain" and
"Avarage Cost" are not displaying the correct figures. This affects the
whole portfolios values and Gain/Loss calculations rendering the complete
software useless.



I have US stocks in the Portfolios ans the Portfolios are denominated in
US$; When I insert any new transaction (buy A Stock) it displays an exchange
dialog box for conversion of £ into $; I ignored this for all these months
and have not problem untill some days ago.



I used the Delux Portfolio it for several years without problems and I
re-installed the latest version after this problem started.



This appears to be the result of the wrong amount displayed in the column
"Avarage Cost" that price have been diminished by about 10% for all the
stocks and for all the portfolios.



The closed positions of the Portfolios are not affected by this new
calculation and are all OK.



If I delete any wrong transaction and re-enter into the Portfolio the
display of the Avarage Cost and % Gain is correct, but this is a long way
and the problem may come back again.



Does anyone experiance something so devastating and have any suggestion?



Thanks to all.

Fulvio

 

Tags
% gain, averege cost, columns, data, lux, msn, portfolio, showing, wrong
Similar Threads
Thread Forum Replies Last Post
"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
Clear "Bank Balance" and "Last Updated" columns?
Rick Shafer: Money 2007 ... in the Account list, is there a way to clear (eliminate) the values shown under the "Bank Balance" and "Last Updated" columns for an...
Microsoft Money 4 06-24-2007 12:53 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
Money Bug? "Deposit" transactions showing as "payments"
J.Won: My investment account's "cash transactions" shows some dividend values as being payments rather than deposits. Also, some stock "sell" transactions...
Microsoft Money 7 02-28-2006 12:47 AM



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:51 AM.