|
#3
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Jeff Martin wrote: - quote - > One tip I
On the transaction entry thing, you will be better off by letting> 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. 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
| |||
| |||
| 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. |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |