|
#4
| |||
| |||
| Cal Learner-- MVP wrote: - quote - Thanks for the info Cal. It turns out none of my retirement accounts were converted very well by Money. I ended up doing the following to correct the problem: 1. Setting up new retirement accounts. 2. Going back and changing all the transfers from the old accounts to the new accounts (this left just the investment transactions in the old accounts). 3. Exporting the investment transactions from the old accounts to a QIF file. 4. Importing the QIF file from step 3 into the new account. For whatever reason, no matter what I did Money refused to recognize the transfers to these 'converted' retirement accounts as contributions. Doing the above fixed this. Also, none of the buys were showing up in the quotes for the 401k securities and doing the above fixed that, too. It would seem that while the conversion brought these accounts over as retirement accounts, they definitely were not working the way a retirement account would work when it is set up in Money (as opposed to being converted from a Quicken file). I had to create a test Money file and set things up and play with it a bit to figure out what was going on, but I eventually got it all working. Thanks again, Gary -- Gary Townsend For email, replace "nospam" with "adelphia" AIM: gtownsend ICQ: 36261155 http://users.adelphia.net/~gtownsend/ ---- There are 10 types of people in the world: Those that understand binary, and those that don't. |
|
#3
| |||
| |||
| In microsoft.public.money, Gary wrote: - quote - > I just converted my Q2003 Premier to the Money 2005 trial. I have 4
New discovery: see> securities set up in a 401k account in Q that came over fine except for > the historical quotes. In looking through the FAQ for this group I see > there is no "easy" way to import historical quotes into Money. > Since these are securities handled soley by the 401k company that don't > have tickers, there's no way to get the updates from MSN. Am I really > stuck putting the history in manually? I don't mind updating manually > every few days (which is what I had to do in Q), but I'd like at least > weekly quotes to show a little more accurate history. > Can anyone offer any help? http://groups-beta.google.com/groups...05&safe=images |
|
#2
| |||
| |||
| In microsoft.public.money, Gary Townsend wrote: - quote - > Cal Learner-- MVP wrote:
I am suggesting that your QIF file have BUY or AddShares> > > If you could cobble up a QIF file with transactions that have > > prices, you could File-> Import that QIF file into a watch account. > > Hi Cal, > Thanks for the suggestion. One question...I have purchases twice a > month for each security (my Company sends funds to the administrator > every pay), but none of the prices from those purchases seem to have any > impact. There's an ending value in the account list, but when I go to > the individual security there's no price history. > I'm guessing I can just dump all the purchase history to a QIF file and > then import that to the watch account to get the prices in, correct? transactions, that can be for 0 amount. Import into an investment account that you can create just for the purpose (perhaps named "Price Data". At the time of import, I think it will have to not be a watch account, but after import, you can make it a watch account. Since it will containing 0 share transactions, it should not matter in report amounts. You can also close the account to have it not show on your account list. You can mark it as tax deferred too, to make sure it does not show up on tax reports. With Money 2005, File-> Import-> RecoverAccounts. For earlier versions, File-> Import ... NewOrRecoveredAccount. Let us know how it works for you. Delete that account, and you will delete the price data. Here is an example file: =============beginWidgetPrice.qif================= == !Type:Invst D01/01/98 T0.00 NShrsIn Ywidget Pty I10 Q0 ^ D01/01/99 T0.00 NShrsIn Ywidget Pty I10.25 Q1 ^ D01/01'00 T0.00 NShrsIn Ywidget Pty I10.5 Q1 ^ D01/01'01 T0.00 NShrsIn Ywidget Pty I10.75 Q0 ^ D01/01'04 T0.00 NShrsIn Ywidget Pty I11.75 Q0 ^ D03/01'04 T0.00 NShrsIn Ywidget Pty I10.75 Q0 ^ D05/01'04 T0.00 NShrsIn Ywidget Pty I11.75 Q0 ^ D07/01'04 T0.00 NShrsIn Ywidget Pty I12.75 Q0 ^ =============endWidgetPrice.qif=================== |
|
#1
| |||
| |||
| Cal Learner-- MVP wrote: - quote - > If you could cobble up a QIF file with transactions that have
Hi Cal,> prices, you could File-> Import that QIF file into a watch account. Thanks for the suggestion. One question...I have purchases twice a month for each security (my Company sends funds to the administrator every pay), but none of the prices from those purchases seem to have any impact. There's an ending value in the account list, but when I go to the individual security there's no price history. I'm guessing I can just dump all the purchase history to a QIF file and then import that to the watch account to get the prices in, correct? Thanks, Gary -- Gary Townsend For email, replace "nospam" with "adelphia" AIM: gtownsend ICQ: 36261155 http://users.adelphia.net/~gtownsend/ ---- There are 10 types of people in the world: Those that understand binary, and those that don't. |
| | |||
| |||
| In microsoft.public.money, Gary wrote: - quote - > I just converted my Q2003 Premier to the Money 2005 trial. I have 4
If you could cobble up a QIF file with transactions that have> securities set up in a 401k account in Q that came over fine except for > the historical quotes. In looking through the FAQ for this group I see > there is no "easy" way to import historical quotes into Money. > Since these are securities handled soley by the 401k company that don't > have tickers, there's no way to get the updates from MSN. Am I really > stuck putting the history in manually? I don't mind updating manually > every few days (which is what I had to do in Q), but I'd like at least > weekly quotes to show a little more accurate his prices, you could File-> Import that QIF file into a watch account. |
|
#-1
| |||
| |||
| Hi folks, I just converted my Q2003 Premier to the Money 2005 trial. I have 4 securities set up in a 401k account in Q that came over fine except for the historical quotes. In looking through the FAQ for this group I see there is no "easy" way to import historical quotes into Money. Since these are securities handled soley by the 401k company that don't have tickers, there's no way to get the updates from MSN. Am I really stuck putting the history in manually? I don't mind updating manually every few days (which is what I had to do in Q), but I'd like at least weekly quotes to show a little more accurate history. Can anyone offer any help? Thanks, Gary |
| Tags |
| importing, quotes, workaround |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Online Quotes Don't Work Howard in VA: I'm having the same problem as the person earlier...ALL the stock symbols come back as unrecognized and/or incorrect. Been this way since last... | Microsoft Money | 1 | 02-12-2004 08:26 AM | |
| On-line quotes server does not work - for anyone? Money defunct? Anyone home at Microsoft? Hello?: OK - there are numerous posts in this Newsgroup stating that the on-line update to stock quotes and news does not work - everyone getting the... | Microsoft Money | 10 | 02-05-2004 04:32 AM | |
| Downloading price quotes just will not work r: Clicked on all the topics can think of. It will not download market quotes. I have a passport account but money will not recognize it. Says it... | Microsoft Money | 2 | 12-26-2003 04:58 PM | |
| Updating Quotes does not work all the time Dilip: I'm using Money 2004 Premium and find that Updating Quotes does not change the portfolio value to reflect new prices. Haven't changed my hardware,... | Microsoft Money | 2 | 09-10-2003 01:54 AM | |
| Online Quotes don't work anymore Robert: Online quotes stopped working yesterday. I'm using MS Money 2001 standard. Any clues? | Microsoft Money | 4 | 08-02-2003 12:35 PM | |
| Thread Tools | |
| Display Modes | |
| |