Investment entry, a better way?
Michael Lynch
Why does entering an investment insist on trying to
do all of the rounding. My mutual fund statements
round shares to 3 places, price to two, and amount to 2
places. When I try to put the transaction in as it is
given to me, Money insists on changing things so that
a penny ends up in the commission box, which I didn't
spend anything on. My only solution to keep the cost
and shares in line is to fiddle with the price to add
extra decimals to round it.
4.216 shares at 35.58 for $150.00 is how the fund stmt
reads. If I enter 4.216, 35.58 it comes up with 150.01
and I change it to 150.00 it forces me to balance.
Why????? I end up entering it as 4.216 @35.579 for $150.00
so I keep the important parts correct.
Is there a better way? Why wouldn't Microsoft help
us out with this, as I know everyone else must have
similar experiences. Quicken added it last year and
I notice that Money still has the problem this year.
Oh well, here's hoping it gets fixed sometime.
Mike
MichaelJo AT msn.com
Gary Bartlett
Michael Lynch wrote in message
<#icqXGjz...@uppssnewspub04.moswest.msn.net>...
>4.216 shares at 35.58 for $150.00 is how the fund stmt
>reads. If I enter 4.216, 35.58 it comes up with 150.01
>and I change it to 150.00 it forces me to balance.
>Why????? I end up entering it as 4.216 @35.579 for $150.00
>so I keep the important parts correct.
Well, if you do the math: 4.216 x 35.58 = 150.00528, so technically the
total would be 150.01 with rounding.
>Is there a better way?
The way I do it is this:
The things which are most important to me are the total amount (that's the
amount that was taken from my account -- physical money only has two decimal
places!), and the quantity of shares (this is what the broker tracks). The
share price is the thing which isn't as important (it's only ever valid for
one instance in time anyway).
So, enter the quantity and total price and let Money compute the share price
for you, and then just live with the difference between your value and the
statement value (it shouldn't be too different). This way, your total
number of shares (after many transactions) will match, and the right amount
of money will be taken from other accounts.
Hope this helps.
Gary
g...@slip.net
Michael Lynch
Thanks Gary. Thats what I do, but I was wondering if there was anything
else possible
here (ie, a new hidden option or something).
Mike
Gary Bartlett wrote in message ...
Robert Karp
"Michael Lynch" <NoM...@MSN.Com> wrote:
> Why does entering an investment insist on trying to
>do all of the rounding. My mutual fund statements
>round shares to 3 places, price to two, and amount to 2
>places.
>
>4.216 shares at 35.58 for $150.00 is how the fund stmt
>reads. If I enter 4.216, 35.58 it comes up with 150.01
>and I change it to 150.00 it forces me to balance.
>Mike
>
>MichaelJo AT msn.com
Money is doing things correctly, if you ask me. When you enter your
transactions, enter only the two real numbers you have. You enter the
total transaction cost and the share price. Money will calculate the
number of shares for you. Your statement already reflects a rounded
number. There is nothing for Microsoft to fix here ... again, Money
is doing things exactly right. The number of share you see on your
statement is rounded and is not the exact number. I don't know about
your mutual fund company, but for mine only the share price and total
are hard numbers.
Joseph Norton
I've always had to do the same thing in Managing Your Money (may it rest in
peace), so it seems to be pretty universal.
--
Joe Norton
Ringwood, NJ
Joe_N...@email.msn.com
Michael Lynch wrote in message ...
>Thanks Gary. Thats what I do, but I was wondering if there was anything
>else possible
>here (ie, a new hidden option or something).
>
>Mike
>
>
>Gary Bartlett wrote in message ...
>>
>>Michael Lynch wrote in message
>><#icqXGjz...@uppssnewspub04.moswest.msn.net>...
>>>4.216 shares at 35.58 for $150.00 is how the fund stmt
>>>reads. If I enter 4.216, 35.58 it comes up with 150.01
>>>and I change it to 150.00 it forces me to balance.
Michael Gordon
Actually, mymdos did it right (you entered the amount and the number of
shares and it computed the price). Mymwin, Quicken, and Money do it the
"wrong" way by computing the amount. In Quicken, however, if you input the
correct amount, the program offers to correct the price. It would be a nice
feature in Money...
Michael
Michael Gordon
MVP- Office
Take a look at the neat stuff at:
http://www.microsoft.com/officefreestuff/office/tea.htm
To inquire about upgrades, fulfillment kits, or other ordering
information, please call the Microsoft Order Desk at 1-800-360-7561,
or your local Microsoft Office.
The Microsoft Knowledgebase is available at http://www.microsoft.com/KB/
and the Microsoft Software Library is available at
http://www.microsoft.com/KB/SOFTLIB/.
Need to communicate with a Support Engineer? Go to
http://www.microsoft.com/support/webresponse/pid/intropid.htm
============================================================
Joseph Norton wrote in message ...
Michael Gordon
You're right, but the tab order as you enter the data takes you to "price"
before you get to "transaction amount" and, if you enter all three -- the
number of shares and the price and the correct amount, Money adjusts the
transaction amount -- which is cleary the wrong thing to do. It's necessary
to skip the price entry which isn't obvious to new users.
Michael
Robert Karp wrote in message <34412e4c...@msnews.microsoft.com>...