1. Home
  2. Quicken Personal Finance
  3. QIF Export does not export earliest prices

QIF Export does not export earliest prices

While working at fixing a corrupted Price History (.QPH) file with Windows ME Quicken 2001 Deluxe (R3) I did a QIF Export (Security Lists) from a good backup. I manipulated the exported data in preparation for import into my current QUICKEN file (with the.QPH file missing), hoping, thus, to get Quicken to build a good .QPH file. All seemed fine until I happened to notice that the earliest price for each security (I checked

7 of about 70) was missing from the QIF Export.

For further testing I created a new Quicken file with only one security (ITW) and two prices, 3/17/06 $317 and 3/13/06 $3.13.

The QIF Export (Security Lists) of this new file looks like

!Type:Security NIllinois tool works SITW TStock ^ !Type:Prices "ITW",317," 3/17' 6" ^ !Type:Prices "ITW",," 0/ 0/ 0" ^

The 3/17/06 price is there. The 3/13/06 price is missing; a junk price record appears instead.

  1. Is there any way to get QUICKEN to export all the prices?

  1. Am I the only one who sees this error (it seems like an error to me)?

  2. Is this error also in Quicken 2006?

  1. Is there a reasonable work around? Needless to say, missing the first price, usually the buy price, would cause problems with reports, and manually entering 70 or so initial prices would be error prone and very time consuming. Using the backup's .QPH file with my current QUICKEN file might work, but might pass along whatever problem that caused the corruption in the first place.

Tom

Reply to
MrTom
Loading thread data ...

As far as I know, the problem you are seeing has always existed.

Purchase (and sale) prices are not lost when price history is lost; that information is still in your file in the Buy and Sell transactions. Cost basis and capital gains info is not therefore not lost.

If the missing price is *not* a purchase price, the only workaround I can think of (entering a dummy price with a very old date before exporting) would be no improvement in effort over letting the historical price download replace the price; or, if that doesn't get it, just manually adding the missing prices in your new price history file.

If the missing price *is* a purchase price, you still may not want it in your price history; if it was not for a mutual fund, it probably was not the closing price for that day. But you can easily recover the prices from all your purchase (and sale) transactions into the price history (if there are no prices already in the history for those dates). Just do a register recalcuation. Place your cursor in the date field of a new transaction in the account you want to recalculate, and press CTRL + Z (you must have Quicken keyboard mapping). Do these recalculations in a copy of your Quicken data, especially if you plan to do them in tax-deferred accounts. Intuit suggests that sometimes there are problems (I think when there is already some problem with the data, the recalculation can make it worse, or at least more obvious).

Reply to
John Pollard

Your "CTRL Z" register recalculation option, of which I was unaware, might be just what I want (aside from QIF simply exporting all the prices). I tried it on a small test file with a couple of buys and sells and, yes, the prices were updated. I definitely do want the prices to be my actual transaction prices, not the closing prices. I will experiment further with (i.e. play with) the register recalculation using my full data in the next day or so, when I get the chance. Thanks for your reply.

Tom

Reply to
MrTom

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.