|
#1
| |||
| |||
| 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 > news aX8j.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 |
| | |||
| |||
| "Doug Brooks" <dougbrooks[at]shaw.ca> wrote in message news aX8j.2487$hQ3.1571[at]pd7urf3no...- quote - > How do I set up my investment portfolio in Money 2006 so that the
If you're entering those in your register as you printed them here,> 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. 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
| |||
| |||
| 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 | |
| |