Corrupted Price History

Two days ago (Mar 14) I noticed that the price history in my Windows ME Quicken 2001 Deluxe (R3) dataset had gotten corrupted. At the end of every month (for about 10 years) I Import Prices (from a file, not online) of all my securities. In one account all three stocks had correct end-of-February prices, but all earlier price entries, both dates and $, had been replaced by those of a money market account price history, i.e. $1 for every earlier price. Quicken showed most wonderful, but, alas, incorrect returns for those stocks.

John Pollard's excellent and pertinent newsgroup message from Sun, Jun

27 2004 11:22 am suggests exporting the Security Lists (which includes the price history) to a QIF file, correcting any erroneous prices, and converting the output to a format (Symbol,Price,Date) suitable to Import Prices. Then, delete the .QPH file, which Quicken will automatically recreate, and Import the corrected prices.

My plan right now is to go back to what appears to be a good Feb 8 backup, do a validate and, perhaps, super validate, perform the above .QPH manipulations, and reenter the handful of transactions occurring after Feb 8, including the import of end-of-Feb prices from a file I still have. Of course, I would make backups along the way.

  1. Any comments on my plan?

  1. Does validate or super validate have any effect on the .QPH file?

  2. Does the .QPH file contain anything other than price history?

  1. Are the "QIF export/price import" manipulations possible with Quicken 2006? Does Quicken 2006 even have a .QPH file? Is there any way in Quicken 2006 to extract and reimport the entire price history? Yes, I am thinking about upgrading to Quicken 2006.

Thanks, Tom

Reply to
MrTom
Loading thread data ...

Yes. If your version of Quicken utilizes a .qph file, then you may be able to avoid the grunge work involved in manipulating price records in a qif file. I believe you can test the theory with no negative consequences.

Rename your current .qph file. Copy your most recent known-to-be-good .qph file (from the backup you referred to, for example) to replace the .qph from your current Quicken fileset. If your backup is from Feb 8, the only thing you would then need to replace would be prices from that point forward.

In my experience (and readings from others), no.

To my knowledge, no. I do not know of anyone having a problem when replacing one .qph file with another (unless the problem was already in the replacement .qph file). In fact, as far as I know, you can carry the .qph file forward (or backward) between filesets from different Quicken versions.

Yes, you can do everything with the price history in Q2006 that you could do in Q2001.

Reply to
John Pollard

John,

I appreciate your excellent, helpful, comments. Thank you.

Tom

John Pollard wrote:

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.