Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 02-22-2005, 06:59 PM
A J Gladson
Guest
 
Posts: n/a
Default Re: Investments Price History Chart

Jeff,

I sync automatically with Vanguard each day. When it downloads
information when I have pruchases or revestments, I believe it will
just "add shares". I ignore the downloaded information and go to the
web and grab the data and properly classify it as Buy or Reinvest.

Why? There is an issue with the rounding of the shares/units.
Transactions downloaded are carried to 5 decimal points (0.12345) where
as the website (and their quarterly statements) are rounded to 3
decimals ( 0.123). Vanguard follows "normal" rounding and will take the
0.12345 and round it down to 0.123.

Also, if you do the compare balances function within Money it is the
same issue - you show 0.123 and Vanguard shows 0.12345 - Money asks if
you want to add 0.00045. I ignore this also.

This is not limited to Money, it also occurs in Quicken. It is not a
Money or Quicken bug but Vanguard being inconsistent in reporting.

  #2  
Old 02-22-2005, 04:11 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investments Price History Chart

In microsoft.public.money, Jeff Martin wrote:

- quote -

> One tip I
> have discovered. My plan is through Vanguard and their online
> transaction history only shows 3 decimal places for the # of shares
> purchased. I was running into a problem when I entered their # of
> shares and the share price, it would be a few cents off on the amount.
> Since Money won't let you enter it incorrectly, I found that you can go
> out of order in Money and enter the share price and the amount and it
> will calculate the # of shares for you.


On the transaction entry thing, you will be better off by letting
Money compute the price and you enter the Quantity and Total. The
reason is that you really are only buying units of 0.001 shares for
a specific price. The price per share is the unimportant one.


  #1  
Old 02-22-2005, 02:59 PM
Jeff Martin
Guest
 
Posts: n/a
Default Re: Investments Price History Chart

That makes sense. Thanks for the heads up.
Dick Watson wrote:
- quote -

> I don't know how to answer your question on the price history charts, but I
> do have a suggestion on your data entry technique.
> By entering the price and total amount and letting Money calculate the
> shares, you will have a growing error in share balance since, as you note,
> the fund company rounds shares to three decimal places and Money will not be
> doing the same. The better technique is to enter the number of shares and
> the total amount and let Money calculate the price. A price calculated to
> four or five or more digits in Money won't propagate a problem. A number of
> shares done the same way will.
> "Jeff Martin" <no_jeffwmartin[at]gmail_spam> wrote in message
> news:eNQuLeOGFHA.560[at]TK2MSFTNGP15.phx.gbl...
> > My plan is through Vanguard and their online
> > transaction history only shows 3 decimal places for the # of shares
> > purchased. I was running into a problem when I entered their # of
> > shares and the share price, it would be a few cents off on the amount.
> > Since Money won't let you enter it incorrectly, I found that you can go
> > out of order in Money and enter the share price and the amount and it
> > will calculate the # of shares for you. Probably obvious to some, but
> > it took me a few minutes.

 
Old 02-22-2005, 02:53 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Investments Price History Chart

I don't know how to answer your question on the price history charts, but I
do have a suggestion on your data entry technique.

By entering the price and total amount and letting Money calculate the
shares, you will have a growing error in share balance since, as you note,
the fund company rounds shares to three decimal places and Money will not be
doing the same. The better technique is to enter the number of shares and
the total amount and let Money calculate the price. A price calculated to
four or five or more digits in Money won't propagate a problem. A number of
shares done the same way will.

"Jeff Martin" <no_jeffwmartin[at]gmail_spam> wrote in message
news:eNQuLeOGFHA.560[at]TK2MSFTNGP15.phx.gbl...
- quote -

> My plan is through Vanguard and their online
> transaction history only shows 3 decimal places for the # of shares
> purchased. I was running into a problem when I entered their # of
> shares and the share price, it would be a few cents off on the amount.
> Since Money won't let you enter it incorrectly, I found that you can go
> out of order in Money and enter the share price and the amount and it
> will calculate the # of shares for you. Probably obvious to some, but
> it took me a few minutes.



  #-1  
Old 02-22-2005, 01:05 PM
Jeff Martin
Guest
 
Posts: n/a
Default Investments Price History Chart

First, let me say since I have complained about some things in Money
lately that I have found something they really did well. I wasn't
really sure where my 401K contributions were going when I withheld them
in my Paycheck setup. I finally got around to setting up my 401K
account correctly and thanks to the umpfaq, I got my employer
contributions setup correctly. The investment side of things is very
nice. Easy to use and great to track my retirement account. One tip I
have discovered. My plan is through Vanguard and their online
transaction history only shows 3 decimal places for the # of shares
purchased. I was running into a problem when I entered their # of
shares and the share price, it would be a few cents off on the amount.
Since Money won't let you enter it incorrectly, I found that you can go
out of order in Money and enter the share price and the amount and it
will calculate the # of shares for you. Probably obvious to some, but
it took me a few minutes.

Now for my question...

I like the Price History chart that shows the price history for your
investment. Does anyone know of a way to data points to this chart that
shows when you purchased shares? All of the data needed is in Money, I
just can't find a way to do it. I could download it all to Excel, but
it seems like this would be something in Money.
 

Tags
chart, history, investments, price
Similar Threads
Thread Forum Replies Last Post
Transactions shown on Price History Chart
BruceK: I notice that in some cases, a "BUY" will be indicated on the price history chart for a given mutual fund. But not all of them. What should I do to...
Microsoft Money 4 02-15-2005 09:06 AM
Price History Chart - How to get the chart to show more than 1 years history
Green: The data is here in Price History, why can't Money chart it for me? Am I missing something?
Microsoft Money 3 11-26-2004 09:59 PM
Price history Chart
Jim: I like to see the "BUY" date on the charts of my stocks in the "price history" section, however on about half of my charts there is no reference to...
Microsoft Money 1 05-23-2004 12:02 AM
Price History
Dave Schwartz: How come the price history only goes back a year or so. Why can't it go back to the first entry? I mean, it is a computer. -- Dave Schwartz...
Microsoft Money 6 11-13-2003 05:13 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:38 AM.