Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 02-12-2004, 10:39 AM
Nathan
Guest
 
Posts: n/a
Default Re: Rounding of Unit Prices


- quote -

> -----Original Message-----
> 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
the exact unit price (eg. 0.001 units [at] $1.0085). It
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  
Old 02-11-2004, 09:39 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding of Unit Prices

In microsoft.public.money, <anonymous[at]discussions.microsoft.comwrote:

- quote -

> 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.

  #1  
Old 02-11-2004, 09:33 PM
Guest
 
Posts: n/a
Default Re: Rounding of Unit Prices


- quote -

> -----Original Message-----
> 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
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.

I'll drop a request into the Wish List.

Thanks Cal.

 
Old 02-11-2004, 03:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding of Unit Prices

In microsoft.public.money, Nathan wrote:

- quote -

> 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?

  #-1  
Old 02-11-2004, 10:37 AM
Nathan
Guest
 
Posts: n/a
Default Rounding of Unit Prices

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

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 07:31 AM.