Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 08-31-2007, 12:53 PM
peterhoa
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

I have a large Australian portfolio and it is greatly affected by these
phantom share splits. There are far to many stocks affected to start
fiddling around with the suggested solution. And anyway tomorrow there
might be another lot affected, or some other data problem may corrupt the
integrity of the data.

This is an extremely serious error which Microsoft must fix ASAP. There is
no way we can use on-line updating of prices the way it is. Work arounds
are completely unacceptable.



"David Arnstein" <arnstein[at]panix.com> wrote in message
news:fb7fhg$qt$1[at]reader1.panix.com...
- quote -

> In article <e1ndd3h8qiuua6jukdo5l3ivqh0qui0680[at]4ax.com> ,
> Cal Learner-- MVP <via_newsgroup[at]please.tnx> wrote:
> > No. There are some shares with bogus splits in the data stream from
> > the new quote provider. Your first indication on download may be
> > that a new difference, between what your register shows and what the
> > broker statement shows, may appear during download processing.

> Cal Learner has posted very valuable information (including solutions!)
> concerning two problems with the "new quote provider." One problem was
> the above "split" business, the other was erroneous share prices for
> some (all?) money market mutual funds.
> At this point, I would like to know if there are other known problems
> with the "new quote provider." Thanks for any info.
> By the way: thank you Cal.
> --
> David Arnstein (00)
> arnstein+usenet[at]pobox.com {{ }}
> ^^



  #4  
Old 08-30-2007, 10:15 PM
David Arnstein
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

In article <e1ndd3h8qiuua6jukdo5l3ivqh0qui0680[at]4ax.com> ,
Cal Learner-- MVP <via_newsgroup[at]please.tnx> wrote:
- quote -

> No. There are some shares with bogus splits in the data stream from
> the new quote provider. Your first indication on download may be
> that a new difference, between what your register shows and what the
> broker statement shows, may appear during download processing.


Cal Learner has posted very valuable information (including solutions!)
concerning two problems with the "new quote provider." One problem was
the above "split" business, the other was erroneous share prices for
some (all?) money market mutual funds.

At this point, I would like to know if there are other known problems
with the "new quote provider." Thanks for any info.

By the way: thank you Cal.
--
David Arnstein (00)
arnstein+usenet[at]pobox.com {{ }}
^^
  #3  
Old 08-30-2007, 09:43 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

In microsoft.public.money, Martyn wrote:

- quote -

> Thanks for the reply I have applied your suggestion and my share balances
> are now correct even after using "update prices online".
> The stocks/dates I was having problems with were:
> DRX 30/04/2007 was 99:100 should have been 64:67
> KEL 18/06/2007 was 97:100 changed to 1:1
> IHG 13/12/2004 was 100:100 should have been 25:28
> IHG 24/06/2005 was 96:100 should have been 11:15
> IHG 13/06/2006 was 100:100 should have been 7:8
> SMWH 27/09/2004 was 96:100 changed to 1:1
> SMWH 01/09/2006 was 139:100 changed to 1:1
> SBRY 19/07/2004 was 100:100 changed to 1:1
> NWS 01/09/2006 was 19:5 this is missing now
> UU. 27/08/2003 was 115:100 changed to 1:1
> VOD 31/07/2006 was 100:100 changed to 1:1
> XTA 05/10/2006 was 111:100 changed to 1:1
> It looks like some have already been changed as when I reenabled the updates
> some of the incorrect share splits were no longer downloaded.
> Thanks again,


What country are those symbols from? I tried looking some of those
up a US symbols, and I did not find them. Looking at the "UU." I
suspect those are London symbols.

  #2  
Old 08-30-2007, 09:14 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

In microsoft.public.money, Martyn wrote:

- quote -

> Thanks for the reply I have applied your suggestion and my share balances
> are now correct even after using "update prices online".
> The stocks/dates I was having problems with were:
> DRX 30/04/2007 was 99:100 should have been 64:67
> KEL 18/06/2007 was 97:100 changed to 1:1
> IHG 13/12/2004 was 100:100 should have been 25:28
> IHG 24/06/2005 was 96:100 should have been 11:15
> IHG 13/06/2006 was 100:100 should have been 7:8
> SMWH 27/09/2004 was 96:100 changed to 1:1
> SMWH 01/09/2006 was 139:100 changed to 1:1
> SBRY 19/07/2004 was 100:100 changed to 1:1
> NWS 01/09/2006 was 19:5 this is missing now
> UU. 27/08/2003 was 115:100 changed to 1:1
> VOD 31/07/2006 was 100:100 changed to 1:1
> XTA 05/10/2006 was 111:100 changed to 1:1
> It looks like some have already been changed as when I reenabled the updates
> some of the incorrect share splits were no longer downloaded.
> Thanks again,
> Martyn.


Thanks.
  #1  
Old 08-30-2007, 09:04 PM
Martyn
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

Cal,

Thanks for the reply I have applied your suggestion and my share balances
are now correct even after using "update prices online".

The stocks/dates I was having problems with were:

DRX 30/04/2007 was 99:100 should have been 64:67
KEL 18/06/2007 was 97:100 changed to 1:1
IHG 13/12/2004 was 100:100 should have been 25:28
IHG 24/06/2005 was 96:100 should have been 11:15
IHG 13/06/2006 was 100:100 should have been 7:8
SMWH 27/09/2004 was 96:100 changed to 1:1
SMWH 01/09/2006 was 139:100 changed to 1:1
SBRY 19/07/2004 was 100:100 changed to 1:1
NWS 01/09/2006 was 19:5 this is missing now
UU. 27/08/2003 was 115:100 changed to 1:1
VOD 31/07/2006 was 100:100 changed to 1:1
XTA 05/10/2006 was 111:100 changed to 1:1

It looks like some have already been changed as when I reenabled the updates
some of the incorrect share splits were no longer downloaded.

Thanks again,

Martyn.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Martyn wrote:
> > I am running Microsoft Money 11.0 (2002?) on Windows XP Home SP2. It seemed
> > to be working OK until quite recently when I noticed the number of shares for
> > several companies was showing an incorrect value. After loads of
> > investigation I've found it is caused by some share splits being
> > created/updated whenever I update prices online. If you set up a new Money
> > file and add one account containing 100 shares for Intercontinental Hotel
> > Group (IHG) purchased on 01/01/2000 (before the company was set up) and then
> > update prices online you get incorrect share splits created. Any existing
> > share splits may also be corrupted. Other tickers which cause a problem are
> > DRX, KEL and XTA. Some companies (e.g. SBRY and VOD) have 100:100 share
> > splits incorrectly created. Other tickers I am having problems with are SMWH
> > and NWS.
> > > To prevent the corruption I have had to turn off updating the prices online

> > for the tickers listed which has limited the usefulness of the program.
> > > Is this just a problem with this particular version?

> No. There are some shares with bogus splits in the data stream from
> the new quote provider. Your first indication on download may be
> that a new difference, between what your register shows and what the
> broker statement shows, may appear during download processing.
> > How can I stop the
> > share splits happening but retain the option to update online the proces of
> > the affected companies.

> 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.

 
Old 08-30-2007, 03:04 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Update prices online causes "phantom" share splits

In microsoft.public.money, Martyn wrote:

- quote -

> I am running Microsoft Money 11.0 (2002?) on Windows XP Home SP2. It seemed
> to be working OK until quite recently when I noticed the number of shares for
> several companies was showing an incorrect value. After loads of
> investigation I've found it is caused by some share splits being
> created/updated whenever I update prices online. If you set up a new Money
> file and add one account containing 100 shares for Intercontinental Hotel
> Group (IHG) purchased on 01/01/2000 (before the company was set up) and then
> update prices online you get incorrect share splits created. Any existing
> share splits may also be corrupted. Other tickers which cause a problem are
> DRX, KEL and XTA. Some companies (e.g. SBRY and VOD) have 100:100 share
> splits incorrectly created. Other tickers I am having problems with are SMWH
> and NWS.
> To prevent the corruption I have had to turn off updating the prices online
> for the tickers listed which has limited the usefulness of the program.
> Is this just a problem with this particular version?


No. There are some shares with bogus splits in the data stream from
the new quote provider. Your first indication on download may be
that a new difference, between what your register shows and what the
broker statement shows, may appear during download processing.

- quote -

> How can I stop the
> share splits happening but retain the option to update online the proces of
> the affected companies.


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.
  #-1  
Old 08-30-2007, 02:56 PM
Martyn
Guest
 
Posts: n/a
Default Update prices online causes "phantom" share splits

I am running Microsoft Money 11.0 (2002?) on Windows XP Home SP2. It seemed
to be working OK until quite recently when I noticed the number of shares for
several companies was showing an incorrect value. After loads of
investigation I've found it is caused by some share splits being
created/updated whenever I update prices online. If you set up a new Money
file and add one account containing 100 shares for Intercontinental Hotel
Group (IHG) purchased on 01/01/2000 (before the company was set up) and then
update prices online you get incorrect share splits created. Any existing
share splits may also be corrupted. Other tickers which cause a problem are
DRX, KEL and XTA. Some companies (e.g. SBRY and VOD) have 100:100 share
splits incorrectly created. Other tickers I am having problems with are SMWH
and NWS.

To prevent the corruption I have had to turn off updating the prices online
for the tickers listed which has limited the usefulness of the program.

Is this just a problem with this particular version? How can I stop the
share splits happening but retain the option to update online the proces of
the affected companies.
 

Tags
online, phantom, prices, share, splits, update
Similar Threads
Thread Forum Replies Last Post
"Phantom" bills in Money 2007
Stan Pesotsky: Hi, I used recurring bills and set some transfers in that way. Then I deleted those entries from bills list but still see overdue bills in the...
Microsoft Money 1 04-06-2007 06:23 PM
Portfolio Manager "Update prices" - not updating stock prices since 13th of Dec
Bobby Sawhney: I am using "Microsoft Money 2006 Premium". In the "Portfolio Manager" if I click on "Update prices"-->"Update prices now", it come up with the...
Microsoft Money 3 12-22-2006 05:01 PM
"Update Prices Online" works about 1 time in 100
Tom: I have 2004 Deluxe. It's the 3rd version I've had. The "update prices online" has always been unreliable, but the last couple weeks it almost...
Microsoft Money 10 02-02-2004 11:40 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 01:41 AM.