Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 12-07-2006, 06:26 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2005: Shouldn't the 'Market Value' = 'Last Price' x 'Qua

In microsoft.public.money, Scott B. wrote:

- quote -

> The numbers are exact.

OK. That eliminates my suspicion that you had set this up as a bond,
which might have given different numbers.


- quote -

> I really do not know why I changed the symbol to
> something fictitious. I really Do recommend you buy RVBD !
> Update: I subsequently learned that whe the data is "Group[ed] by:"Account
> name", the error disapears; but, for all the other "Group by:" selections
> (i.e. Investment type, Capitalization, Currency, Risk and Position) the
> 15,071.18 discrepency remains on all but a couple of my longest held (<10
> yrs) positions regardless of which accounts the securities are held. Also,
> even though all of these "Market values" are being shown significantly
> inflated, all the calculations even the account subtotals are corrects
> PS. I am reluctant to follow Mark's suggestion at: See the "market value is
> incorrect" item in http://support.microsoft.com/kb/889246/en-us which
> recommends restoring the pre MNY '05 file since I have been using this
> version > 1 yr! Is there no less cumbersome fix?


I believe this is a bug in Money 2005. I have a note that a bug like
that got fixed for me when I went to Money 2006.

However I would right-click the security, and choose
SeeInvestmentActivities. Delete any transactions that are not part
of the real account. I don't know that this has any history of
fixing the problem. I am probably trying to apply logic to an area
where that does not apply.

If you are in the US, you might consider upgrading to Money 2007.
Otherwise GroupBy:Account until you upgrade.






- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Scott B. wrote:
> > > > For Microsofts Money 2005 delux, shouldn't the 'Market Value' equal the 'Last
> > > Price' times the 'Quantity' in the 'Valuation' view of the 'Portfolio
> > > Manager', . For example, one line reads: "SYMBOL: ABC , CHART: [^], NAME: ABC
> > > Technology Inc., LAST PRICE: 32.65, QUANTITY: 20.000, COST BASIS: 432.00,
> > > MARKET VALUE: 15,724.18, INCOME: , PRICE APPRECIATION: 221.00"
> > > As you can see, all of the calculations, except the "MARKET VALUE" are
> > > correct. Even the PRICE APPRECIATION which depends on the value of the
> > > "MARKET VALUE" is correct, but the MARKET VALUE value itself is way off! As
> > > it turns out, every single value in this column is off by exactly 15,071.18
> > > which is the 'MARKET VALUE' value assigned to line items which have zero
> > > QUANTITY.
> > > I have performed both Quick and Standard File Repairs but the anomaly
> > > remains. Any suggestions? Thanks.
> > > Are those the actual numbers you are seeing? You appear to have put

> > in an artificial name and symbol, so are the numbers artificial too?
> > > >
  #2  
Old 12-07-2006, 06:21 PM
Mark
Guest
 
Posts: n/a
Default Re: Money 2005: Shouldn't the 'Market Value' = 'Last Price' x 'Qua

You could try the Money 2007 Trial version to see if that corrects the
problem.

http://www.microsoft.com/money/freetrial_deluxe.mspx

It's been a while since I've thought of this issue. I think it has to do
with when you originally set up the account having set an "estimated" amount
prior to adding actual transaction and that "estimated" amount was probably
$15071.18.
A work-around in Money 2005 (after ensuring that you have updated to the
1105 version: Help - About) is to try moving all of the transactions into a
NEW account (which won't have that estimated amount). In order to see the
Estimated amount in the Account Details, there needs to be no transactions.
If I remember correctly, an estimated amount in other accounts could impact
the Market Value in different accounts. So you'll need to find out which
account has that estimated amount (i.e. move all transactions out of it) and
then zero out the estimate.

-Mark

"Scott B." <ScottB[at]discussions.microsoft.com> wrote in message
news:AF310F52-58FB-4C38-8AAA-E73426FD14A2[at]microsoft.com...
- quote -

> The numbers are exact. I really do not know why I changed the symbol to
> something fictitious. I really Do recommend you buy RVBD !
> Update: I subsequently learned that whe the data is "Group[ed] by:"Account
> name", the error disapears; but, for all the other "Group by:" selections
> (i.e. Investment type, Capitalization, Currency, Risk and Position) the
> 15,071.18 discrepency remains on all but a couple of my longest held (<10
> yrs) positions regardless of which accounts the securities are held.
> Also,
> even though all of these "Market values" are being shown significantly
> inflated, all the calculations even the account subtotals are corrects
> PS. I am reluctant to follow Mark's suggestion at: See the "market value
> is
> incorrect" item in http://support.microsoft.com/kb/889246/en-us which
> recommends restoring the pre MNY '05 file since I have been using this
> version > 1 yr! Is there no less cumbersome fix?
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Scott B. wrote:
> > > > For Microsofts Money 2005 delux, shouldn't the 'Market Value' equal the
> > > 'Last
> > > Price' times the 'Quantity' in the 'Valuation' view of the 'Portfolio
> > > Manager', . For example, one line reads: "SYMBOL: ABC , CHART: [^],
> > > NAME: ABC
> > > Technology Inc., LAST PRICE: 32.65, QUANTITY: 20.000, COST BASIS:
> > > 432.00,
> > > MARKET VALUE: 15,724.18, INCOME: , PRICE APPRECIATION: 221.00"
> > > As you can see, all of the calculations, except the "MARKET VALUE" are
> > > correct. Even the PRICE APPRECIATION which depends on the value of the
> > > "MARKET VALUE" is correct, but the MARKET VALUE value itself is way off!
> > > As
> > > it turns out, every single value in this column is off by exactly
> > > 15,071.18
> > > which is the 'MARKET VALUE' value assigned to line items which have zero
> > > QUANTITY.
> > > I have performed both Quick and Standard File Repairs but the anomaly
> > > remains. Any suggestions? Thanks.
> > > Are those the actual numbers you are seeing? You appear to have put

> > in an artificial name and symbol, so are the numbers artificial too?
> > > >

  #1  
Old 12-07-2006, 03:15 PM
Mark
Guest
 
Posts: n/a
Default Re: Money 2005: Shouldn't the 'Market Value' = 'Last Price' x 'Quanti

Did you recently covert your file to 2005 deluxe (before downloading the
updates)?
See the "market value is incorrect" item in
http://support.microsoft.com/kb/889246/en-us

-Mark
"Scott B." <ScottB[at]discussions.microsoft.com> wrote in message
news:5A7C213C-3418-4CBC-8CFC-BAD993A8A219[at]microsoft.com...
- quote -

> For Microsofts Money 2005 delux, shouldn't the 'Market Value' equal the
> 'Last
> Price' times the 'Quantity' in the 'Valuation' view of the 'Portfolio
> Manager', . For example, one line reads: "SYMBOL: ABC , CHART: [^], NAME:
> ABC
> Technology Inc., LAST PRICE: 32.65, QUANTITY: 20.000, COST BASIS: 432.00,
> MARKET VALUE: 15,724.18, INCOME: , PRICE APPRECIATION: 221.00"
> As you can see, all of the calculations, except the "MARKET VALUE" are
> correct. Even the PRICE APPRECIATION which depends on the value of the
> "MARKET VALUE" is correct, but the MARKET VALUE value itself is way off!
> As
> it turns out, every single value in this column is off by exactly
> 15,071.18
> which is the 'MARKET VALUE' value assigned to line items which have zero
> QUANTITY.
> I have performed both Quick and Standard File Repairs but the anomaly
> remains. Any suggestions? Thanks.


 
Old 12-06-2006, 11:44 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2005: Shouldn't the 'Market Value' = 'Last Price' x 'Quanti

In microsoft.public.money, Scott B. wrote:

- quote -

> For Microsofts Money 2005 delux, shouldn't the 'Market Value' equal the 'Last
> Price' times the 'Quantity' in the 'Valuation' view of the 'Portfolio
> Manager', . For example, one line reads: "SYMBOL: ABC , CHART: [^], NAME: ABC
> Technology Inc., LAST PRICE: 32.65, QUANTITY: 20.000, COST BASIS: 432.00,
> MARKET VALUE: 15,724.18, INCOME: , PRICE APPRECIATION: 221.00"
> As you can see, all of the calculations, except the "MARKET VALUE" are
> correct. Even the PRICE APPRECIATION which depends on the value of the
> "MARKET VALUE" is correct, but the MARKET VALUE value itself is way off! As
> it turns out, every single value in this column is off by exactly 15,071.18
> which is the 'MARKET VALUE' value assigned to line items which have zero
> QUANTITY.
> I have performed both Quick and Standard File Repairs but the anomaly
> remains. Any suggestions? Thanks.


Are those the actual numbers you are seeing? You appear to have put
in an artificial name and symbol, so are the numbers artificial too?



  #-1  
Old 12-06-2006, 11:10 PM
Scott B.
Guest
 
Posts: n/a
Default Money 2005: Shouldn't the 'Market Value' = 'Last Price' x 'Quanti

For Microsofts Money 2005 delux, shouldn't the 'Market Value' equal the 'Last
Price' times the 'Quantity' in the 'Valuation' view of the 'Portfolio
Manager', . For example, one line reads: "SYMBOL: ABC , CHART: [^], NAME: ABC
Technology Inc., LAST PRICE: 32.65, QUANTITY: 20.000, COST BASIS: 432.00,
MARKET VALUE: 15,724.18, INCOME: , PRICE APPRECIATION: 221.00"
As you can see, all of the calculations, except the "MARKET VALUE" are
correct. Even the PRICE APPRECIATION which depends on the value of the
"MARKET VALUE" is correct, but the MARKET VALUE value itself is way off! As
it turns out, every single value in this column is off by exactly 15,071.18
which is the 'MARKET VALUE' value assigned to line items which have zero
QUANTITY.
I have performed both Quick and Standard File Repairs but the anomaly
remains. Any suggestions? Thanks.
 

Tags
2005, market, money, price, quanti
Similar Threads
Thread Forum Replies Last Post
Money 2005 Deluxe Price
Elena: Hi I want to buy Money 2005 Deluxe so I was shopping around various online stores... I finally came to the Microsoft website to check if they...
Microsoft Money 5 09-20-2004 05:00 AM
Beginning balance in reports shouldn't be there
CIS: I have a beginning balance in my Reimbursable Expenses accout that I cannot figure out. I report ALL dates, ALL everything and it just shows up as a...
Microsoft Money 5 01-21-2004 02:56 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 10:14 PM.