Quicken Price History Utility to extract security prices out of a Quicken Windows data file.
I'm not a Quicken Inc employee and don't represent them. If you need any kind of support other that the download link being broken. Contact Quicken Inc support or post on their forum.
Quicken Support
Quicken Forum
I'm also not the author of the QPH File Processor utility. Harold Munro Corbould is and holds the copyright to it. I'm providing the install for it here because I don't believe there is any other way to get a hold of it and I don't have any way of contacting the author.
If you need to get the security prices out of one Quicken windows data files and import them into another Quicken Windows data file you can try exporting the prices using the QIF export/import with the "Security list" option (which include the syntax to create the securities as well as import the prices). One thing about this method is that the import is extremely slow. And also, for some people it might not result in the prices being imported (maybe because of the date format being wrong).
First let me say that for both the QIF export/import and the QPH program if a security doesn't have a symbol in the old data file, then it will not be imported into the new one. The security symbol can be anything, so for your securities that doesn't have a security symbol just use a fake one that isn't possible to be real like _Fake1.
Second, the import of securities using the CSV file that QPH produces doesn't create a new security, so you will need to pre-create the securities that you want imported in the data file you are importing into.
The QPH program assumes the "pre-Quicken 2010" format where the .QPH file was a separate file, so the first thing that needs to be done is to extract out the .QPH file from the Quicken data file for Quicken 2010 and beyond. The Quicken 2010 and beyond data file is actually the same files but put in a compressed data file similar to a ZIP file.
You can use the free program 7-Zip to copy the .QPH file out of your data file so that you can then use the QPH program on that file to produce a .CSV file that can then be imported into Quicken.
You can get the 7-Zip install from here: Download (7-zip.org)
Once installed, run 7-Zip and use the text box to browse to your data file and open it like this:
Quicken Support
Quicken Forum
I'm also not the author of the QPH File Processor utility. Harold Munro Corbould is and holds the copyright to it. I'm providing the install for it here because I don't believe there is any other way to get a hold of it and I don't have any way of contacting the author.
If you need to get the security prices out of one Quicken windows data files and import them into another Quicken Windows data file you can try exporting the prices using the QIF export/import with the "Security list" option (which include the syntax to create the securities as well as import the prices). One thing about this method is that the import is extremely slow. And also, for some people it might not result in the prices being imported (maybe because of the date format being wrong).
First let me say that for both the QIF export/import and the QPH program if a security doesn't have a symbol in the old data file, then it will not be imported into the new one. The security symbol can be anything, so for your securities that doesn't have a security symbol just use a fake one that isn't possible to be real like _Fake1.
Second, the import of securities using the CSV file that QPH produces doesn't create a new security, so you will need to pre-create the securities that you want imported in the data file you are importing into.
The QPH program assumes the "pre-Quicken 2010" format where the .QPH file was a separate file, so the first thing that needs to be done is to extract out the .QPH file from the Quicken data file for Quicken 2010 and beyond. The Quicken 2010 and beyond data file is actually the same files but put in a compressed data file similar to a ZIP file.
You can use the free program 7-Zip to copy the .QPH file out of your data file so that you can then use the QPH program on that file to produce a .CSV file that can then be imported into Quicken.
You can get the 7-Zip install from here: Download (7-zip.org)
Once installed, run 7-Zip and use the text box to browse to your data file and open it like this:
And to copy it out:
Next you will need to download and install the QPH program. You can download it from here:
Run the QPH program and use the File -> Open to open your .QPH file. And then select the Process Source File button. Note that unlike the QIF import where for Quicken Windows US and Canada the date format has to be MM/DD/YYYY for the importing of the security prices using a CSV file must be in the same format as your Windows short date/register format.
This will produce a -AllData.csv file in the same folder as your data file.
You should now be able to import the prices in that CSV using Quicken's:
File -> File Import -> Import Security prices from CSV file...
This will produce a -AllData.csv file in the same folder as your data file.
You should now be able to import the prices in that CSV using Quicken's:
File -> File Import -> Import Security prices from CSV file...