Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 03-25-2005, 02:41 PM
Mark
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

There are some potential problems if you work with a file that was converted
into the pre-1105 version:
http://support.microsoft.com/default...b;en-us;889246
So, as the article states, it may be worthwhile to find the copy of the
pre-converted file (e.g. *.m12 for Money 2004) and reconvert it.

-Mark
"Elizabeth" <Elizabeth[at]discussions.microsoft.com> wrote in message
news:669480EE-7208-4D02-9C7C-74E382D6025B[at]microsoft.com...
- quote -

> On the fourth try I finally was successful in downloading and installing
the
> upgrade. I needed to use the "new user" in XP method you recommended.

I'm
> in the process now of evaluating the figures to see if everything is

correct.
> Unfortunately, the "unrealized gains" problem remains. Still working on
> that one. Thanks for your help in getting the download accomplished.
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Elizabeth wrote:
> > > > You understand the problem, and I understand your response, but it

didn't
> > > work for me. My version is 14.0.125.724 (have been unable to download

the
> > > update). What version are you using to make the figures work? I

appreciate
> > > all your time and effort to help.
> > > I am using 14.0.125.1105.
> > > To get the update, in IE6, I would start with

> > Tools-> Options-> Security-> LocalIntranet-> DefaultLevel which may be
> > sufficient.
> > > If that does not let you updated, and if you are using XP, I would

> > try creating a new user with Administrator privilege. Switch to
> > that user and start Money with a new blank file. Let Money
> > download the updates as that user.
> > > The theory is that if the problem is an IE6 setting, you will get

> > default settings for the new user. If you succeed this way, it
> > would accomplish the download, and it would point toward the reason
> > the other did not work. You can delete the new user later, and
> > your regular IE6 settings will not have been changed.
> > > My experiments were not exhaustive. I may still have an anomaly if I

> > study it further, but it is not so serious a symptom as some.
> > > Getting that updated is significant, and if it does not help that

> > aspect for you, it may help others.
> >

  #6  
Old 03-25-2005, 02:39 AM
Elizabeth
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

On the fourth try I finally was successful in downloading and installing the
upgrade. I needed to use the "new user" in XP method you recommended. I'm
in the process now of evaluating the figures to see if everything is correct.
Unfortunately, the "unrealized gains" problem remains. Still working on
that one. Thanks for your help in getting the download accomplished.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Elizabeth wrote:
> > You understand the problem, and I understand your response, but it didn't
> > work for me. My version is 14.0.125.724 (have been unable to download the
> > update). What version are you using to make the figures work? I appreciate
> > all your time and effort to help.

> I am using 14.0.125.1105.
> To get the update, in IE6, I would start with
> Tools-> Options-> Security-> LocalIntranet-> DefaultLevel which may be
> sufficient.
> If that does not let you updated, and if you are using XP, I would
> try creating a new user with Administrator privilege. Switch to
> that user and start Money with a new blank file. Let Money
> download the updates as that user.
> The theory is that if the problem is an IE6 setting, you will get
> default settings for the new user. If you succeed this way, it
> would accomplish the download, and it would point toward the reason
> the other did not work. You can delete the new user later, and
> your regular IE6 settings will not have been changed.
> My experiments were not exhaustive. I may still have an anomaly if I
> study it further, but it is not so serious a symptom as some.
> Getting that updated is significant, and if it does not help that
> aspect for you, it may help others.

  #5  
Old 03-23-2005, 08:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

In microsoft.public.money, Elizabeth wrote:

- quote -

> You understand the problem, and I understand your response, but it didn't
> work for me. My version is 14.0.125.724 (have been unable to download the
> update). What version are you using to make the figures work? I appreciate
> all your time and effort to help.


I am using 14.0.125.1105.

To get the update, in IE6, I would start with
Tools-> Options-> Security-> LocalIntranet-> DefaultLevel which may be
sufficient.

If that does not let you updated, and if you are using XP, I would
try creating a new user with Administrator privilege. Switch to
that user and start Money with a new blank file. Let Money
download the updates as that user.

The theory is that if the problem is an IE6 setting, you will get
default settings for the new user. If you succeed this way, it
would accomplish the download, and it would point toward the reason
the other did not work. You can delete the new user later, and
your regular IE6 settings will not have been changed.

My experiments were not exhaustive. I may still have an anomaly if I
study it further, but it is not so serious a symptom as some.

Getting that updated is significant, and if it does not help that
aspect for you, it may help others.


  #4  
Old 03-23-2005, 06:57 PM
Elizabeth
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

You understand the problem, and I understand your response, but it didn't
work for me. My version is 14.0.125.724 (have been unable to download the
update). What version are you using to make the figures work? I appreciate
all your time and effort to help.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Cal Learner-- MVP wrote:
> > > I think you are saying that the numbers are fine when you let the

> > date be today's date, but when you set the AsOf date back to earlier
> > times, you get bad basis and Price Appreciation numbers. I agree
> > that those number are not right when you set the date back.

> Working with this a bit more, I find that when I select an AsOF date
> and then select UpdatePrices-> UpdatePricesNow, the numbers start
> behaving.

  #3  
Old 03-23-2005, 10:38 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

In microsoft.public.money, Cal Learner-- MVP wrote:

- quote -

> I think you are saying that the numbers are fine when you let the
> date be today's date, but when you set the AsOf date back to earlier
> times, you get bad basis and Price Appreciation numbers. I agree
> that those number are not right when you set the date back.


Working with this a bit more, I find that when I select an AsOF date
and then select UpdatePrices-> UpdatePricesNow, the numbers start
behaving.


  #2  
Old 03-23-2005, 10:23 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

In microsoft.public.money, Elizabeth wrote:

- quote -

> I don't think so. See if I can explain. I'll use as an example a stock I've
> loaded. I'm getting results I don't understand in "Portfolio Value by
> Investment Account" report.
> (a) Effective Apr 30, 2004 spin-off of ABT (CB=0.9377891) and HSP
> (CB=0.0622109), 1 shr HSP for every 10 ABT. Price ABT Apr 29 $44.40; Apr 30
> $44.02. So I "Record a special activity" > "Record a spin-off" > etc.
> (b) Check new CB using "Investment Transactions Report." Set-up: Account(#)
> > Investment (ABT) > Activity (Select All). Result CB (Apr 30) divided by CB

> (Apr 29) = 0.9377891. Right on, all is well so far I think.
> (c) "Portfolio Value by Investment Account" report (ABT) for Apr 30 all
> columns appear to contain logical results. Still look'n good.
> (d) Portfolio Value by Investment Account" report (ABT) for Apr 29 Quantity,
> Latest Price, and Value columns appear to also contain logical results. Ah,
> almost there, but wait... Unrealized Gains and Cost Basis each appear
> excessive by a factor of two (double); Average Cost per Share is deficient by
> a factor of two (one half). The double and one half structure persists in
> the same three columns backwards for all "Portfolio Value by Investment
> Account" reports to original ABT purchase date.
> This I don't understand.


Trying to duplicate this, I see portfolio column "Price
Appreciation" which I think is what you would be using for
unrealized gain.

CB stands for cost basis, I assume. I do not see a doubling of the
cost basis. That is to say, the basis for ABT+HSP matches the
original test Buy of ABT that I entered.

I think you are saying that the numbers are fine when you let the
date be today's date, but when you set the AsOf date back to earlier
times, you get bad basis and Price Appreciation numbers. I agree
that those number are not right when you set the date back.

- quote -

> Thanks
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Elizabeth wrote:
> > > > re M2005 premium: when recording a spin-off, need help understanding how or
> > > why all prior parent company unrealized gain values double.
> > > > I can imagine. If you are comparing the values before and after that

> > spinoff, but the price quote of the parent did not drop a lot over
> > that interval, the value would stay the same. You have reduced the
> > basis a lot by transferring basis to the spinoff. So the
> > unrealizedGain(=value-basis) would have increased.
> > > In reality, the price probably dropped significantly when the parent

> > went ex-dividend, but your entering of the spinoff info probably did
> > not match that timing exactly.
> > > Would that explain it?

> >

  #1  
Old 03-23-2005, 02:05 AM
Elizabeth
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

I don't think so. See if I can explain. I'll use as an example a stock I've
loaded. I'm getting results I don't understand in "Portfolio Value by
Investment Account" report.

(a) Effective Apr 30, 2004 spin-off of ABT (CB=0.9377891) and HSP
(CB=0.0622109), 1 shr HSP for every 10 ABT. Price ABT Apr 29 $44.40; Apr 30
$44.02. So I "Record a special activity" > "Record a spin-off" > etc.
(b) Check new CB using "Investment Transactions Report." Set-up: Account(#)
- quote -

> Investment (ABT) > Activity (Select All). Result CB (Apr 30) divided by CB
(Apr 29) = 0.9377891. Right on, all is well so far I think.
(c) "Portfolio Value by Investment Account" report (ABT) for Apr 30 all
columns appear to contain logical results. Still look'n good.
(d) Portfolio Value by Investment Account" report (ABT) for Apr 29 Quantity,
Latest Price, and Value columns appear to also contain logical results. Ah,
almost there, but wait... Unrealized Gains and Cost Basis each appear
excessive by a factor of two (double); Average Cost per Share is deficient by
a factor of two (one half). The double and one half structure persists in
the same three columns backwards for all "Portfolio Value by Investment
Account" reports to original ABT purchase date.

This I don't understand.

Thanks

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Elizabeth wrote:
> > re M2005 premium: when recording a spin-off, need help understanding how or
> > why all prior parent company unrealized gain values double.

> I can imagine. If you are comparing the values before and after that
> spinoff, but the price quote of the parent did not drop a lot over
> that interval, the value would stay the same. You have reduced the
> basis a lot by transferring basis to the spinoff. So the
> unrealizedGain(=value-basis) would have increased.
> In reality, the price probably dropped significantly when the parent
> went ex-dividend, but your entering of the spinoff info probably did
> not match that timing exactly.
> Would that explain it?

 
Old 03-21-2005, 03:17 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: unrealized gains doubled

In microsoft.public.money, Elizabeth wrote:

- quote -

> re M2005 premium: when recording a spin-off, need help understanding how or
> why all prior parent company unrealized gain values double.



I can imagine. If you are comparing the values before and after that
spinoff, but the price quote of the parent did not drop a lot over
that interval, the value would stay the same. You have reduced the
basis a lot by transferring basis to the spinoff. So the
unrealizedGain(=value-basis) would have increased.

In reality, the price probably dropped significantly when the parent
went ex-dividend, but your entering of the spinoff info probably did
not match that timing exactly.

Would that explain it?

  #-1  
Old 03-21-2005, 02:49 AM
Elizabeth
Guest
 
Posts: n/a
Default unrealized gains doubled

re M2005 premium: when recording a spin-off, need help understanding how or
why all prior parent company unrealized gain values double.
 

Tags
doubled, gains, unrealized
Similar Threads
Thread Forum Replies Last Post
Net Worth Report NOT including unrealized gains
Rob Blackburn: I need to produce a net worth report in Money and I would like to be able to run this report both including and not including unrealized gains and...
Microsoft Money 2 09-04-2004 08:32 PM
Budget amounts are doubled
Suelynn: Due to errors I have had to delete and renter deposits and bills but in the budget and in edit budget these amounts are doubled even though they...
Microsoft Money 12 08-16-2004 08:21 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 06:36 AM.