|
#3
| |||
| |||
| - quote - > -----Original Message-----
the exact unit price (eg. 0.001 units [at] $1.0085). It> In microsoft.public.money, <anonymous[at]discussions.microsoft.com> wrote: > > Maybe not a big deal, but when I quite a few funds and > > have 0,000's of units in a particular fund and the prices > > are say $1.00985 it ends up with more than a 1% error and > > it makes reconciliation awkward. The real point is that > > there is no reason for money to round the number when it > > is input (maybe only for display purposes). I note that > > it is not rounded when the buy or sell transactions are > > done and therefore the handling of the unit price is > > inconsistent. > As a work-around, since you are entering data by hand, you could do > a 1 for 100 split. Rename to "Hundred xyz units". Enter price *100. > I understand that is not ideal, but it could be an acceptable > compromise. > . > Thanks Cal. The work around I came up with was to enter a BUY transaction of a very small fraction of units at works because I have a very large quantity of units in that investment eg. 10,000+. So using my work around the current investment value is calculated as: 10,000.001 * 1.0085 If I used the manual input the 1.0085 gets rounded to 1.009 and so the current investment value gets calculated as: 10,000 * 1.009 The first workaround is more accurate and reflects my portfolio better. It only works because I have large unit holdings. Your suggestion would work better for smaller holdings I think. Thanks again. Nathan |
|
#2
| |||
| |||
| In microsoft.public.money, <anonymous[at]discussions.microsoft.comwrote: - quote - > Maybe not a big deal, but when I quite a few funds and
As a work-around, since you are entering data by hand, you could do> have 0,000's of units in a particular fund and the prices > are say $1.00985 it ends up with more than a 1% error and > it makes reconciliation awkward. The real point is that > there is no reason for money to round the number when it > is input (maybe only for display purposes). I note that > it is not rounded when the buy or sell transactions are > done and therefore the handling of the unit price is > inconsistent. a 1 for 100 split. Rename to "Hundred xyz units". Enter price *100. I understand that is not ideal, but it could be an acceptable compromise. |
|
#1
| |||
| |||
| - quote - > -----Original Message-----
are say $1.00985 it ends up with more than a 1% error and> In microsoft.public.money, Nathan wrote: > > Seems like MS Money rounds unit prices to three decimal > > places when they are updated manually. Is there a way to > > avoid this because it causes the valuation of the units > > to be inaccurate? > > No. You think that's a big deal? > . > > > Maybe not a big deal, but when I quite a few funds and have 0,000's of units in a particular fund and the prices it makes reconciliation awkward. The real point is that there is no reason for money to round the number when it is input (maybe only for display purposes). I note that it is not rounded when the buy or sell transactions are done and therefore the handling of the unit price is inconsistent. I'll drop a request into the Wish List. Thanks Cal. |
| | |||
| |||
| In microsoft.public.money, Nathan wrote: - quote - > Seems like MS Money rounds unit prices to three decimal
No. You think that's a big deal?> places when they are updated manually. Is there a way to > avoid this because it causes the valuation of the units > to be inaccurate? |
|
#-1
| |||
| |||
| Seems like MS Money rounds unit prices to three decimal places when they are updated manually. Is there a way to avoid this because it causes the valuation of the units to be inaccurate? Regards Nathan |
| Tags |
| prices, rounding, unit |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Rounding on Investment transactions _PC_: I've seen this problem for quite a while in Monday (at least 01, 02, 03, and 04). But when I'm entering my transactions, often times the final... | Microsoft Money | 1 | 01-10-2004 11:39 PM | |
| Automatic Rounding problems Fabio Pires: I am using Money 99 and, only on investments section, when I try enter a price or quantity with a decimal part, it simply round it to an integer... | Microsoft Money | 2 | 01-10-2004 06:42 PM | |
| Thread Tools | |
| Display Modes | |
| |