Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 02-15-2005, 02:49 AM
Gary Townsend
Guest
 
Posts: n/a
Default Re: Work-around for importing quotes?

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  
Old 02-09-2005, 04:56 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Work-around for importing quotes?

In microsoft.public.money, Gary wrote:

- quote -

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


New discovery: see
http://groups-beta.google.com/groups...05&safe=images


  #2  
Old 02-09-2005, 03:14 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Work-around for importing quotes?

In microsoft.public.money, Gary Townsend wrote:

- quote -

> Cal Learner-- MVP wrote:
> > > 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?


I am suggesting that your QIF file have BUY or AddShares
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  
Old 02-09-2005, 01:08 AM
Gary Townsend
Guest
 
Posts: n/a
Default Re: Work-around for importing quotes?

Cal Learner-- MVP wrote:
- quote -

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

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.
 
Old 02-08-2005, 10:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Work-around for importing quotes?

In microsoft.public.money, Gary wrote:

- quote -

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


If you could cobble up a QIF file with transactions that have
prices, you could File-> Import that QIF file into a watch account.

  #-1  
Old 02-08-2005, 05:34 PM
Gary
Guest
 
Posts: n/a
Default Work-around for importing quotes?

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

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 08:53 AM.