Share price data is stored in the .qph file. Does this file still exist ?
Alternatively, have the company codes or the settings for these companies changed with the upgrade ? Hopefully only the links to the existing stored prices have been lost.
If you can download share prices from other web sites which store asx historical data, you can re-format them to a suitable layout .csv file to re-import what you have lost. .csv format is:
see the related article for lots more info:
Do you have a copy of the file with your database, in somewhere like:
users > neil > documents > quicken > Qdata.qph
This is the default directory for your files in Windows 7 or 8 and where your database should be stored. (Files > Open should indicate this directory). Your AppData/Local/Temp folder is not a likely place for your RPP database files. (You need to recover more than just the Qdata.QDF file when restoring. Qdata.rkn is a full backup file.)
The program should automatically access the .qph file if it is in the correct directory. when the file is in the correct folder (although I would be cautious if it is not) I'd suggest you go to "Investing > Security Detail View" and look at some of the companies you expect to have data, then use Update > Edit Price History and see if there is any available data.
Otherwise use Edit Security Details to see if there is something missing from the company details.
There is a utility at reltan.com that can view the .qph file and report it as a text file. This would allow you to look at the data you have and see what might be the mismatch. It will report the company codes, if this is the source of your problem.
When i select "Download Historical Prices" I get a box that states 'Select the securities you want historical prices for (U.S. Securities only) - there is no choice of any listed Australian stocks. I can confirm that I have the "Australian Edition" of Reckon Accounts Personal Plus 2015 Release R 1. I can confirm the symbols used for the Ausutralian stocks are valid as they have not changed since the 2013 version of the software and they currently get the daily prices, but cannot get historical prices.
There have been others who have obtained a US version and you appear to have an Australian version that is configured for US Securities, which appears to have generated a new .QPH file.
I don't know what has happened as I have remained with RPP 2013 and do my share price updates via a .csv file import. It appears my caution is warranted.
Hopefully someone at Reckon will answer your questions as your installation of RPP 2015 does not appear to be working as would be expected. How could it default to US securities if it is a Reckon Australia update ?
Maybe they should not have skipped the beta test phase ! We can only hope there was at least an alpha phase. Given the only change appears to have been the url of the new download site what could they stuff up.
Do you have a .rkn backup file from before the update to RPP 2015 that you can recover and see if it corrects the security settings ?
Alternatively you could go to the backup sub directory and see if any file sets are dated before the change-over and copy these files across, changing their names to the current active dataset. (make sure you copy the latest dataset to an alternative directory in case this fails.) I would do this as a file copy and not from inside RPP. Run RPP 2015 and see if the security information appears and if the default security type is now Australian. (No idea where this is set)
To summarise a few points here on upgrades and Share Price History.
Before upgrading we suggest creating a backup, which will, whether it be the old backup or the new Reckon backup (extension .rkn), keep your data file (extension .QDF) and all other ancillary files (share price history extension .QPH) together.
When you install Reckon Accounts Personal Range 2015 you can access your data by
- opening the existing file from its existing location (your file will be upgraded the first time you open it); or
- Restore your backup to another folder
In the case where the .QPH file was missing after upgrading, then a search of your PC should locate it for you. Then merely copy that file to your current folder to gain access to it again.
This was discussed in an earlier thread:
There is a KnowledgeBase article as well at: http://kb.reckon.com.au/issue_view.asp?ID=3027
Reckon Accounts Personal range does not, and never has, provided an historical database for Australian and New Zealand securities. It does have access to an historical database for US securities. The Download Historical Prices module clearly states that only US securities are available.
That Personal Plus 2015 created a new QPH file meant that a QPH file did not exist in the same folder as the datafile you were using. Why it wasn't there is a matter of reviewing the steps taken against the ideal steps in an upgrade. As this issue is not widespread, the failure to restore a QPH file is not an endemic problem with the software.
I looked at the KnowledgeBase article you referred to. I don't think the author of this article is an informed user of QPP. How would I go with Method 2, when I have over 280,000 price records stored in my QPH file! I think something more helpful should be provided than this little gem. A better designed .csv import and export facility would certainly help.
When the Download Historical Prices module was first introduced there were a number of ASX market indices provided, including the All Ords, ASX 200, ASX 100 and ASX 50. I have ASX 100 prices stored from 23/8/2000 to 16/11/2006, when they stoped being provided with QPP 2007.
There is a widespread problem with QPP users of missing share price data, because of the limited ~7-day storage time of available price data from the download site. This is an endemic problem with the software and a solution should be addressed.
I have actually used a dump of Currency exchange rates, which provides a useful time stamp of the days that I did a share price update. Using Tools > Currency List > Historical Rates to print/export the values, I can then calculate the day spacing of these updates. By presenting as a histogram, this provides a good indication of how often I missed share price data over the years of this service. I am sure many others could report a similar problem.
However when I renamed the data file ( which you can do from File Operations ) the historical share price data disappeared. The new QPH file has only a few kb of data whereas the old QPH file still had a lot of data.
So I manually renamed the old .QPH file to same name as the new data file, and the historical share price info has all returned.
A point on renaming files, if you try to rename a file with an underscore in it appears that the Reckon File Rename tool can no longer find the file.
Reckon will always add an underscore if you backup with the option to append the date. After you restore a file you would normally want to rename the file to remove that appendage, but alas you now cannot. The only option is to NOT use the date appendage if you want to rename the file after restoring. Then after renaming do another restore of the old file and rename the QPH file. Simple huh ! NOT
restoring security history.
I have recently transferred my Reckon Accounts Personal Plus 2015 over to another computer and everything seems to have gone over ok apart from my security price history. I have read an earlier post about copying the existing QPH file over to the new folder and have done this and it doesn't seem to recognise this despite deleting all other QPH references in the new folder. Seeing my price history goes back to 1995, you can understand my frustration.
I do not know why this problem is occurring. All I can think of is that:
* the .qph file you were transferring has a different name to that being expected by RPP 2015, or
* you have copied it to the wrong directory.
Look at the file menu in RPP 2015 and see what name and directory is being used for your database.
What is the size of your qdata.qph file ?
Have you changed or added any company codes since transferring to the new computer, which could generate a mis-match in the expected record structure of the .qph file.
Thanks for the reply and sorry I have taken so long to reply. I have overcome the problem by renaming the last complete QPH file to the date of the current RKN file and that seems to have worked. Now I have another problem with one of my credit card balances suddenly decreasing instead of increasing but that is a different post. I have been using Personal Plus for nearly 20 years and have never experienced so many problems as with this 2015 release, seems to be riddled with errors.
This conversation is no longer open for comments or replies.
This conversation is no longer open for comments or replies.