Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 08-26-2007, 07:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Severe problem with "Performance by Investment Type" report

In microsoft.public.money, David Arnstein wrote:

- quote -

> I have been using the ""Performance by Investment Type" report in
> Microsoft Money for years. I am using the 2007 "Premium" version now.
> I just noticed this problem today. I *think* it is new, but I am not
> entirely certain.
> One of the line items in this report is a money market fund. I
> classified it as a mutual fund in MS Money. Like most money market
> funds, this one has a stable share price of $1. I make frequent "buys"
> and "sells" of this fund. The overall trend is down, I have been
> selling more than buying.
> Today, the "Performance" report shows the following bogus columns:
> Realized Gain / Loss: 0.00
> Return for Period: (large negative number)
> % Rate of Return: -15.18
> Annual % Return -44.29
> The last number is especially troublesome. It should be a small
> positive number, reflecting the modest interest rate that the money
> market fund pays out.
> So now I doubt the accuracy of this report for all my investments. Is
> there a solution to this problem? Perhaps I should switch to a
> different report? I am most interested in the total annualized return
> (last report column) for my investments, for various periods of time.
> Thanks for any suggestions.


The workaround I suggest is to blank the symbol in the Details for
the fund and then delete any non-$1 prices from the list. You want
to have at least one $1 entry dated from before you first held that
fund. You could enter a new manual Update with a date from last
century.

Go to Investment-> Portfolio and right-click the fund. Choose
SeeInvestmentDetails. There you can blank out the symbol. You can
optionally add the symbol to the comments or rename the security to
incorporate the symbol in the name. Then, from the Details, click
PriceHistory-> UpdatedPrices-> UpdatedPricesManually. Delete all of
the non-$1 prices. This should not be too difficult since the
Delete key will auto-repeat. If you have an older version of
Money, the navigation may be a little different.

This occurred during an update evening of 17 Aug 2007 that involved
a quote supplier change. I have seen a positive effect, but there
is a negative one that has popped up for some users. It appears
that most MMFs with a public symbol are now downloading a bogus
(not $1) price from the new quote server. If the 7-day annualized
yield is 4.8%, the price is downloaded as $4.80. This results in
inflated portfolio values.

See http://articles.moneycentral.msn.com...orkstatus.aspx
 
Old 08-26-2007, 06:59 PM
David Arnstein
Guest
 
Posts: n/a
Default Re: Severe problem with "Performance by Investment Type" report

I think I found the problem. I viewed the price history for this money
market fund, and I saw about 100 entries that were NOT $1.00. These
entries had all come from online updates.

I deleted these entries manually. I think that my computer mouse is worn
out now. I also added an asterisk (*) to the end of the trading symbol.
I hope that this will prevent any further online updates to this money
market fund.

--
David Arnstein (00)
arnstein+usenet[at]pobox.com {{ }}
^^
  #-1  
Old 08-26-2007, 06:19 PM
David Arnstein
Guest
 
Posts: n/a
Default Severe problem with "Performance by Investment Type" report

I have been using the ""Performance by Investment Type" report in
Microsoft Money for years. I am using the 2007 "Premium" version now.

I just noticed this problem today. I *think* it is new, but I am not
entirely certain.

One of the line items in this report is a money market fund. I
classified it as a mutual fund in MS Money. Like most money market
funds, this one has a stable share price of $1. I make frequent "buys"
and "sells" of this fund. The overall trend is down, I have been
selling more than buying.

Today, the "Performance" report shows the following bogus columns:
Realized Gain / Loss: 0.00
Return for Period: (large negative number)
% Rate of Return: -15.18
Annual % Return -44.29

The last number is especially troublesome. It should be a small
positive number, reflecting the modest interest rate that the money
market fund pays out.

So now I doubt the accuracy of this report for all my investments. Is
there a solution to this problem? Perhaps I should switch to a
different report? I am most interested in the total annualized return
(last report column) for my investments, for various periods of time.

Thanks for any suggestions.
--
David Arnstein (00)
arnstein+usenet[at]pobox.com {{ }}
^^
 

Tags
problem, report, severe
Similar Threads
Thread Forum Replies Last Post
Problem with keeping track of shared expenses, "His", "Hers", "Ours" and How much do I owe you?
P.Constantineau: Hi all, My girlfriend and I are having trouble figuring how to use money 2005 to indicate us how much we owe each other. I have setup Money 2005...
Microsoft Money 4 04-03-2006 02:01 PM
Bank Reverses the "Transaction Type" and "Description" Fields
David Brenner: Has anyone else had an issue like this? My Credit Union supports Direct Download, and all the numbers come in right. The quirky thing is that the...
Microsoft Money 4 07-13-2005 10:39 PM
Eliminate "Investment Performance" from Portfolio page?
Steve Brecher: I recently upgraded to Money 2004 from a previous version. I would like to get rid of the new "Investment Performance" panel at the bottom of the...
Microsoft Money 2 04-16-2004 06:40 PM
How to customize "Performance by Inv. Acct" report ?
: When I open the report "Performance by Inv.Account" report and select the date as "Current year", it includes all investments irrespective of...
Microsoft Money 3 04-10-2004 07:49 PM
"investment type" field
jr: is there a way to change the "investment type" field that is in the details page of an investment. For instance, i put in "abc" as a stock when it...
Microsoft Money 1 09-10-2003 04:20 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 01:39 AM.