Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 12-16-2007, 03:33 PM
Doug Brooks
Guest
 
Posts: n/a
Default Re: Investments

Thanks Chris

"Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
news:eH9vqW4PIHA.5360[at]TK2MSFTNGP03.phx.gbl...
- quote -

> "Doug Brooks" <dougbrooks[at]shaw.ca> wrote in message
> newsaX8j.2487$hQ3.1571[at]pd7urf3no...
> > How do I set up my investment portfolio in Money 2006 so that the the
> > value of an investment (Mutual Fund) shows as the latest quantity of
> > units times the latest unit price? Right now every time I update an
> > investment Money sums the quanities of units and multiplies it by the
> > latest unit price, enen though I have not purchased any more units.
> > > ie:

> > Date No of units Unit Price Total
> > Jan 1 100 $10.00 $1,000
> > Mar 31 100.1 $10.50 $1,051.05
> > June 20 100.2 $11.00 $1,102.20
> > Sep 30 100.2 $10.75 $1,077.15
> > > Money reports that I have 400.5 Units [at] $10.75 for a total of $4,305.38

> > when it is in fact 100.2 units [at] $10.75 for a total of $1,077.15.

> If you're entering those in your register as you printed them here, Money
> interprets them as transactions, probably as add transactions. What you
> probably want to do is add 100 on 1/1, then 0.1 on 3/31 and 0.1 on 6/20.
> The total on 6/20 and 9/30 will be 100.2. The current value will be, as
> you say, quantity time unit price.
> --
> Chris Cowles
> Gainesville, FL



 
Old 12-16-2007, 12:47 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Investments

"Doug Brooks" <dougbrooks[at]shaw.ca> wrote in message
newsaX8j.2487$hQ3.1571[at]pd7urf3no...
- quote -

> How do I set up my investment portfolio in Money 2006 so that the
> the value of an investment (Mutual Fund) shows as the latest
> quantity of units times the latest unit price? Right now every time
> I update an investment Money sums the quanities of units and
> multiplies it by the latest unit price, enen though I have not
> purchased any more units.
> ie:
> Date No of units Unit Price Total
> Jan 1 100 $10.00 $1,000
> Mar 31 100.1 $10.50 $1,051.05
> June 20 100.2 $11.00 $1,102.20
> Sep 30 100.2 $10.75 $1,077.15
> Money reports that I have 400.5 Units [at] $10.75 for a total of
> $4,305.38 when it is in fact 100.2 units [at] $10.75 for a total of
> $1,077.15.


If you're entering those in your register as you printed them here,
Money interprets them as transactions, probably as add transactions.
What you probably want to do is add 100 on 1/1, then 0.1 on 3/31 and
0.1 on 6/20. The total on 6/20 and 9/30 will be 100.2. The current
value will be, as you say, quantity time unit price.
--
Chris Cowles
Gainesville, FL


  #-1  
Old 12-15-2007, 07:54 PM
Doug Brooks
Guest
 
Posts: n/a
Default Investments

How do I set up my investment portfolio in Money 2006 so that the the value
of an investment (Mutual Fund) shows as the latest quantity of units times
the latest unit price? Right now every time I update an investment Money
sums the quanities of units and multiplies it by the latest unit price, enen
though I have not purchased any more units.

ie:
Date No of units Unit Price Total
Jan 1 100 $10.00 $1,000
Mar 31 100.1 $10.50 $1,051.05
June 20 100.2 $11.00 $1,102.20
Sep 30 100.2 $10.75 $1,077.15

Money reports that I have 400.5 Units [at] $10.75 for a total of $4,305.38 when
it is in fact 100.2 units [at] $10.75 for a total of $1,077.15.


Doug


 

Tags
investments
Similar Threads
Thread Forum Replies Last Post
tax deferred investments now seperated from taxed investments in performance report
Dave Programmer: I'm running Money 2005. In some cases I have the same investment in both a tax deferred and regular account. Until just a couple of days ago, when...
Microsoft Money 5 10-28-2007 04:00 PM
Removing Investments From Home Page "Investments" Portal
cd: On my home page I have an "Investments" portal that lists all the stocks/funds I own. Is there a way to select which funds/stocks show up in that...
Microsoft Money 4 05-03-2006 11:46 PM
Investments
Bernardo Ferreira: I dont want my investments to appear as expenses on my reports. How should i do it? I though about putting it on the budget sumary, but i didnt...
Microsoft Money 3 04-26-2005 02:12 PM
Investments
DKAllen: I am evaluating Money 2004 and was wondering if there was a way to track my gold and silver bullion acquisions and auto update pricing like you can...
Microsoft Money 1 01-20-2004 10:15 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:32 PM.