Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 11-05-2007, 05:34 AM
Mike Connors
Guest
 
Posts: n/a
Default Re: M2004 - Weird price and quantity in Portfolio

But why should we have to apply this workaround? This is ridiculous. And
where will the problem strike next? It's the sort of problem that can go
un-noticed for a long period of time and cause all sorts of problems to the
user. What confidence can we have in a financial reporting/management system
that changes the quantities of our investments at random? What will it
corrupt next?

This problem was first reported two months ago and it remains unfixed. I
don't care one tiny bit whether there is a new data provider, nor should I
have to care about these things. It is extrordinary that Microsoft
Money/MSN corrupts our files this way and Microsoft does absolutely nothing
about it. Not a comment in these news groups. No fixes. Nothing.



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

> In microsoft.public.money, GeorgeR wrote:
> > I have just noticed that the quantities and prices for all transactions in
> > some of my investments have been changed, the total is still correct.

> That is probably due to some bogus splits in the price quote
> download data.
> > All
> > quantities are now fractions (always less than what they were) and prices
> > are
> > correspondingly higher and also the price ends with the letter s.
> > > What has caused this? How do I prevent it happening again? What is the

> > meaning of the letter s?

> That would stand for Split.
> > > I now have to go back and edit all my investment entries because the total

> > quantity is now less than it should be.

> There are some shares with bogus splits in the data stream from the
> new quote provider.
> To work around this, look at the split history for a stock. Go to
> the investment PriceHistory. UpdatePrices-> UpdatePricesManually,
> Look through the table and find the entries in the Source column
> that say "Stock Split". The first split, going back in time, will
> be identifiable by the quotes being suffixed with an 'S' for the
> price. The first may not be the bad one.
> Note the date of the bad split. It is not necessary to delete it
> at this point. Click Close. Then UpdatePrices-> RecordASplit.
> Record a split for the date you noted as a 1 for 1 split. Accept
> that you are overwriting the existing split. That should inoculate
> you to a re-download of the bad split for that date-- at least for
> some versions. Let us know how that works out for you. It would
> be nice if post the symbol for the stock and the date of the bad
> split data.
> I am not sure the 1:1 split workaround will work on Money 2004. Let
> us know if it does not.



  #1  
Old 11-04-2007, 01:44 PM
GeorgeR
Guest
 
Posts: n/a
Default Re: M2004 - Weird price and quantity in Portfolio

Thanks, your solution worked just great!

Info regarding the bad splits:
Stock Date
AMP 21-May-2007
HGI 15-Oct-2007
QAN 13-Feb-2007

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, GeorgeR wrote:
> > I have just noticed that the quantities and prices for all transactions in
> > some of my investments have been changed, the total is still correct.

> That is probably due to some bogus splits in the price quote
> download data.
> > All
> > quantities are now fractions (always less than what they were) and prices are
> > correspondingly higher and also the price ends with the letter s.
> > > What has caused this? How do I prevent it happening again? What is the

> > meaning of the letter s?

> That would stand for Split.
> > > I now have to go back and edit all my investment entries because the total

> > quantity is now less than it should be.

> There are some shares with bogus splits in the data stream from the
> new quote provider.
> To work around this, look at the split history for a stock. Go to
> the investment PriceHistory. UpdatePrices-> UpdatePricesManually,
> Look through the table and find the entries in the Source column
> that say "Stock Split". The first split, going back in time, will
> be identifiable by the quotes being suffixed with an 'S' for the
> price. The first may not be the bad one.
> Note the date of the bad split. It is not necessary to delete it
> at this point. Click Close. Then UpdatePrices-> RecordASplit.
> Record a split for the date you noted as a 1 for 1 split. Accept
> that you are overwriting the existing split. That should inoculate
> you to a re-download of the bad split for that date-- at least for
> some versions. Let us know how that works out for you. It would
> be nice if post the symbol for the stock and the date of the bad
> split data.
> I am not sure the 1:1 split workaround will work on Money 2004. Let
> us know if it does not.

 
Old 11-04-2007, 05:14 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: M2004 - Weird price and quantity in Portfolio

In microsoft.public.money, GeorgeR wrote:

- quote -

> I have just noticed that the quantities and prices for all transactions in
> some of my investments have been changed, the total is still correct.


That is probably due to some bogus splits in the price quote
download data.

- quote -

> All
> quantities are now fractions (always less than what they were) and prices are
> correspondingly higher and also the price ends with the letter s.
> What has caused this? How do I prevent it happening again? What is the
> meaning of the letter s?


That would stand for Split.

- quote -

> I now have to go back and edit all my investment entries because the total
> quantity is now less than it should be.



There are some shares with bogus splits in the data stream from the
new quote provider.

To work around this, look at the split history for a stock. Go to
the investment PriceHistory. UpdatePrices-> UpdatePricesManually,
Look through the table and find the entries in the Source column
that say "Stock Split". The first split, going back in time, will
be identifiable by the quotes being suffixed with an 'S' for the
price. The first may not be the bad one.

Note the date of the bad split. It is not necessary to delete it
at this point. Click Close. Then UpdatePrices-> RecordASplit.

Record a split for the date you noted as a 1 for 1 split. Accept
that you are overwriting the existing split. That should inoculate
you to a re-download of the bad split for that date-- at least for
some versions. Let us know how that works out for you. It would
be nice if post the symbol for the stock and the date of the bad
split data.

I am not sure the 1:1 split workaround will work on Money 2004. Let
us know if it does not.
  #-1  
Old 11-04-2007, 03:36 AM
GeorgeR
Guest
 
Posts: n/a
Default M2004 - Weird price and quantity in Portfolio

I have just noticed that the quantities and prices for all transactions in
some of my investments have been changed, the total is still correct. All
quantities are now fractions (always less than what they were) and prices are
correspondingly higher and also the price ends with the letter s.

What has caused this? How do I prevent it happening again? What is the
meaning of the letter s?

I now have to go back and edit all my investment entries because the total
quantity is now less than it should be.
 

Tags
m2004, portfolio, price, quantity, weird
Similar Threads
Thread Forum Replies Last Post
Weird behavior in MSMoney 2007 Portfolio Manager
donawalt@gmail.com: All of a sudden a couple of days ago, after automatic download of mutual fund quotes, Portfolio Manager calculates a completely wrong total return...
Microsoft Money 20 08-20-2007 02:32 PM
M2004 Portfolio Button Broke
Judy: :) Hi, When I click the Portfolio button or Portfolio from the tool bar, I get the Window Error Report. In the "Error Signature" it shows ModName:...
Microsoft Money 13 12-25-2005 01:24 AM
MSN Money Portfolio cannot import M2004 file?
Aloke Prasad: The MSN Money Portfolio page http://moneycentral.msn.com/scripts/webquote.dll?iPage=pmx shows my old portfolio. I periodically import the...
Microsoft Money 2 09-30-2004 11:14 PM
M2004 Standard. Can I track my portfolio & Stocks?
J. Lane Randolph II: In M2003 standard I can track my stocks and portfolio. The info re: M004 standard says I am unable to track stocks or have a portfolio. Is this...
Microsoft Money 3 07-26-2003 10:31 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 11:53 PM.