I’m happy to report that the migration to the new portfolio system is complete.This new system applies to Quicken Windows 2006, 2007 and 2008.
If you want more information about this transition, or if you are experiencing any issues with the new portfolio, please post them in the thread here. This will keep all of the issues in one place, which means we can gather and fix them a lot sooner--
Thanks--
Quicken Kathryn
Signature - Please remember that this is a User-to-User community forum. If you come in to get an answer, see if there are any that you can provide. The more people who do that, the more likely you will get your answer.
To help others trying to answer your question, go to "Preferences/Profile" to the left of the page and and fill in those fields.
Intuit Employees using the forum can be identified by the name "Quicken" followed by an Intuit logo. Unless a poster has the above requirements they are not an Intuit employee.
Hi All, I want to give you a status update on where we are at with the historical quotes issues. The engineering team has determined the problem is not in the core application. We are now checking the databases and working with our data feeds providers to find the root cause. The team is aggressivly working on this and considers it to be a high priority issue to get resolved. As I learn more I will update you. Please remember that sometimes you will get incorrect values and other times you will get correct values. This is one of the reasons it has been really hard in determining the root cause. I apologize for the difficulties it has given to many of you. Dale
Relates to Quicken 2009:
Dale, some more information that may be helpful in tracking down the problem and coming to a resolution:
Spent some time experimenting with updates last night and results were as follows:
1. Downloading historical quotes does not replace an incorrect price in the price history - i.e., if, for example, there is an incorrect price for 8/22 in the QPH file, re-downloading correct historical prices will not replace the incorrect price.
2. Deleted incorrect price history for 8/22 and 8/25-28, then downloaded historical prices for month -- correct price history was filled in for empty information. Tried this for several securities with same results with one exception in my test set, namely, AT&T, which twice filled in missing price history data with incorrect information. AT&T finally updated with correct historical data when I completely rebuilt my QPH file, as described below.
3. However, if you delete incorrect price history and download quotes before downloading historical prices, then missing price history data is filled with incorrect information. (This suggests that "download quotes" is doing more than just providing the most recent prices and that something in the process may be corrupting the QPH file.)
4. The foregoing steps for correcting the corrupted price history data are problematical for users who have large portfolios with several hundred separate securities. (It took me almost two hours to delete the incorrect price histories just for my stocks beginning with "A", since you have to go one by one into each stock's price history to delete the corrupt data.) Accordingly, I have rebuilt my QPH file in the following manner (perhaps another user can suggest an easier method - is there any way to directly manipulate the QPH file, as you could if it had an Excel or other spreadsheet file structure?):
a. using QPH Processor (a free utility which you can find by searching that title in these Forums), I extracted the 8/29 prices for all securities, which are correct, to a .cvs file;
b. renamed existing QPH file by changing extension to .old (saves the data and can be restored by changing extension back to .qph);
c. restarted Quicken which creates new, blank QPH file;
d. imported the 8/29 prices using the .cvs file created in step a.;
e. downloaded historical prices for the month;
f. checked my portfolio, and when everything appeared to have downloaded properly (even AT&T now had the correct price history information for 8/22 and 8/25-28), I downloaded historical prices for the past 2 years. Again, all seems to have downloaded properly.
5. There is one significant problem with the rebuilt QPH file - price histories for bonds and investments that aren't publicly traded are missing. These are usually updated from your broker's records. For these holdings, I had to edit the price histories to provide the 8/29 prices, but all the prior data is missing. Does anyone know a way to extract the price histories for bonds and non-publicly traded investments from the old QPH file and import them into the rebuilt file?
6. I now have a rebuilt price history file with the correct data for 8/22 and 8/25-28, but with missing information for bonds and non-publicly traded investments, and I can view real results in my various accounts and portfolio as a whole for those dates. But what will happen when I download quotes at the end of the day on Tuesday? I will have my fingers crossed and hope that all the work I did will not be undone by another corrupt download. Rest assured that I intend to back up my QPH file before I hit the "download quotes" button, and from now on I will make a backup of the QPH file at the end of each day.
New Quicken.com Investing and Quotes Download Aug 31, 2008 08:59 am
This post is about: Quicken Online
Yes, I did have to buy the software in order to be able to continue using the online portfolio. I would get a message on the sign in screen that I needed to update my software that after a certain date I would no longer be able to use the online portfolio. I would have to buy the software and register it on my computer in order to continue using the online portfolio. I don't know any free sites that allow me to view all my my individual portfolios, all my transactions, the daily and overall loss or gain of my individual portfolios, and the daily and overall loss and gain of all my portfolios besides the online portfolio that quicken no longer has. If anyone knows one please let me know. I also would not go to a free site and put in personal information without registering and signing in. And, when you create a portfolio at a free site how would anyone really know whether you really own those stocks even if they were able to hack into your account. I had never seen the note column at yahoo before and I was leery of putting in the name of the brokerage firm so I did not put in the actual name. It is also nice when traveling because you do not have to sign in to your actual accounts and worry about someone stealing your sign in information. If someone hacks into my online portfolios there is nothing there for them to steal. Most all our trades or long term trades. We are not daily traders. The only time I check the history of a stock is when I am not sure I got the best deal on a trade. Maybe I should have been using the software, but the online portfolio suited our needs. I would be willing to pay a "small" subscription fee to continue using it!
New Quicken.com Investing and Quotes Download Aug 31, 2008 09:06 am
This post is about: Quicken Premier 2008
JPG wrote:
5. There is one significant problem with the rebuilt QPH file - price histories for bonds and investments that aren't publicly traded are missing. These are usually updated from your broker's records. For these holdings, I had to edit the price histories to provide the 8/29 prices, but all the prior data is missing. Does anyone know a way to extract the price histories for bonds and non-publicly traded investments from the old QPH file and import them into the rebuilt file?
Hi Joseph,
See this post for info on creating a price import file that you can use to rebuild your bond and other prices. You should be able to extract your bond prices using the QPH processor utility.
One caveat, using the above method in the last week or so, some volumes failed to import - no error messages, the prices import but not the volumes. Good luck, Mary
Mary: I noticed that lack of volume import issue also - with QW2009. Is that what you were running? I know your prior description (the link) worked fully in QW2007.
JPG: I you can also export prices to a QIF file, massage the data and import as a csv file. No time to find the link to the details right now. That method can still be labor intensive especially for many securities and a long history. Further, I tend to agree with your suggestions about QPH file corruption. My symptom was program crashes during editing within Quicken 2009 of a security price history. I am currently researching how I can best rebuild a QPH file. The QPH File Processor is great, but I have a few suggestions to pass on to the author when I have time.
using the above method in the last week or so, some volumes failed to import - no error messages, the prices import but not the volumes. Good luck, Mary
Thanks, Mary. I will try to recreate the price histories for my bonds using the suggested method. Volume data is not that important for me, so I can survive if it fails to import.
you can also export prices to a QIF file, massage the data and import as a csv file
Thanks for the suggestions. I thought about exporting the entire price history, removing the bad data, and importing the modified history back into Quicken, but with a 23MB QPH file (the output from QPH Processor is almost 4,000 pages in an Excel spreadsheet), that approach seemed too daunting and I adopted the easier method outlined in my posted message. I may try exporting just the bond information, and see if that is a manageable amount of data.
I may try exporting just the bond information, and see if that is a manageable amount of data.
For anyone trying to rebuild a QPH file to remove corrupt historical prices, price history information for bonds cannot be extracted from the old QPH file using the QPH Processor utility. Only securities with ticker symbols appear in the extracted data files (whether you extract in Excel or csv format) and bonds do not appear in the list of securities.
Also, if you export your portfolio to a QIF file, although the bonds will appear in your list of securities, there will be no historical price data in the QIF file.
Finally, I have tried to import bond prices into Quicken using either the name of the bond or the cusip, as a substitute for a ticker symbol, but no joy. Does anyone know how bonds are identified in the QPH file?
Unless someone knows how to get the historical data for bonds out of the old QPH file and then how to import historical bond price information back into Quicken, these limitations make including historical bond prices in a rebuilt QPH file problematical.
If you know how to get quotes into a csv file (from Excel save one sheet as a comma separated values (CSV) file) you can fix the bad data. symbol,close,date or symbol,date,close will work and date can be mm/dd/yy or mm/dd/yyyy. If you want high, low, and volume also then use the format
symbol,close,---,date, ---,high,low,volume/100,*
Import that file into Quicken by going to your porfolio page and selecting file/import/import prices
If you view the csv file in Notepad, one line looks like
CDE,1.87,---,8/22/2008,---,1.97,1.86,81712,*
I have tried to attach a csv file for an exammple.
For anyone trying to rebuild a QPH file to remove corrupt historical prices, price history information for bonds cannot be extracted from the old QPH file using the QPH Processor utility. Only securities with ticker symbols appear in the extracted data files (whether you extract in Excel or csv format) and bonds do not appear in the list of securities. Also, if you export your portfolio to a QIF file, although the bonds will appear in your list of securities, there will be no historical price data in the QIF file. Finally, I have tried to import bond prices into Quicken using either the name of the bond or the cusip, as a substitute for a ticker symbol, but no joy. Does anyone know how bonds are identified in the QPH file? Unless someone knows how to get the historical data for bonds out of the old QPH file and then how to import historical bond price information back into Quicken, these limitations make including historical bond prices in a rebuilt QPH file problematical.
JPG: You can assign a ticker to a bond in Quicken without any deleterious effects (AFAIK). Use something that makes sense to you. Because of this 'requirement', I have tickers for all my securities - stock, MF, CDs, Bonds, others. For example, my US treasuries are USTa, USTb, etc. I do not have them in my download quotes list. That may become a if I ever get a real security with that ticker. You might also consider something like 'XYZ-5%(Bond)'. Do that before using the QPH File Processor and you should be in business.
I believe you are correct that a ticker is required for the import-prices step.
New Quicken.com Investing and Quotes Download Aug 31, 2008 09:28 pm
This post is about: Quicken Deluxe 2006
Just a little information that may be helpful when checking your databases. Do you have the correct fields when accessing the quote server database? I can see that an error is occurring in the price, the historical price, and volume for FDRXX. That is the Fidelity Cash Reserve Money Market Fund. I can see that you are using the 7 day average yield to fill in the high-low for the day and the 1 year range in yield to fill in the 1 year price range. The Quicken Price History "volume" for this quote appears to be the average maturity in days for the holdings in this money fund, not the volume traded which has, of course, no meaning. Same is true with btvxx, the BLACKROCK LIQUIDITY FDS TEMP FD. In that situation the yield is 2.00 and you are using that for the current price, and the day range.
It seems that part of the problem may be that the quote server program is accessing the fields by numerical position in the database and not by the field name. (This may be a problem with the SQL fetch command in the quote server program that is queried by the user when calling for quotes.) The returned values may be generating erroneous data when the position in the database for a money market fund is essentially being used for another function, like yield, instead of price.
The old system wasn't workable, and not maintainable, it worked, but for how long? Letting it keep running was an option, but at some point a switch needed to be made, if not this year, next Jan, or spring, how many problems between now and then? We are in a much better position today than we were 3 months ago, I know it doesn't feel like it, but we have a large team working on these issues and are ironing them out. As a quicken customer myself I would much rather have a newer system with a team in place constantly improving it, that what we had before.
sorry - just bad decision and bad management...
In our case, having worked in IT for years, if any of my people ever launched a system like this, they would be out on the street....
There are so many things wrong here....
don't even know where to begin,
and not even having to do with the actual application, but more the culture, management and idea that this could even be happening ?
How would you feel if this was your online banking application, or even your on-screen TV cable guide ?
Data all messed up - application not tested completely, functionality missing, etc, etc.
I emailed Brad Smith (Intuit CEO) to alert him to all the problems with the new portfolio.
I figured that upper management could put pressure to correct the problems and revert back to the old portfolio where we could not. I received this response on Friday: ----------------------------------------------
Harold, I have copied our business leader (Todd Stanley) for Quicken so he and his team can incorporate your feedback into helping us get better. Thanks for the e-mail and support. Brad
----------------------------------------- Todd Stanley is Vice President & GM of Quicken.
We will see if it it helps. Harold
Last year, when all the news and quotes were broken, I had also mailed all the C-level execs and all that happened was a received a phone call from a normal tech support person....
New Quicken.com Investing and Quotes Download Sep 01, 2008 07:41 am
This post is about: Quicken Deluxe 2008
IMO said:
How would you feel if this was your online banking application, or even your on-screen TV cable guide ?
Haha! My local newspaper just did this to it's Sunday TV section, rendering is virtually useless by removing the information in their TV listings which are not available elsewhere.
I think in this day and age of cutbacks and cost savings, the people who are making these decisions just do not have an awareness of what makes their product superior or better than other offerings. The end result is that they remove those qualities, which are probably the most expensive to maintain, and thus demean their product and thereby reduce its attractiveness to consumers. They then lose customers which, in turn, forces further cutbacks until there is nothing left.
If I had a product such as Quicken which had a feature that no other such service offered, that is the last feature I would want to get rid of.
Quicken is now no different from any other stock tracking and research program, many of which are absolutely free to use. Why should I continue to purchase Quicken to get what I can get elsewhere for free?
Incidentally, the local newspaper some time ago, cut back on stock market coverage in which they printed the closing quotes from most actively traded stocks, to hardly any. Sure that information is available elsewhere, but seldom can you get it all in one spot in such and a comprehensive view. I suspect when they cut back on coverage of local sports, I will just drop my subscription there, too.
New Quicken.com Investing and Quotes Download Sep 01, 2008 08:44 am
This post is about: Quicken Premier 2008
q.lurker wrote: You can assign a ticker to a bond in Quicken without any deleterious effects (AFAIK). Use something that makes sense to you. Because of this 'requirement', I have tickers for all my securities - stock, MF, CDs, Bonds, others. For example, my US treasuries are USTa, USTb, etc. I do not have them in my download quotes list. That may become a if I ever get a real security with that ticker. You might also consider something like 'XYZ-5%(Bond)'. Do that before using the QPH File Processor and you should be in business.
I believe you are correct that a ticker is required for the import-prices step.
Thanks. Didn't realize this was possible because I had my bonds correctly identified as such and when security is identified as a bond, the symbol field is grayed-out. However, when I changed security type to "other", I was able to enter a "ticker" for each bond. Now QPH File Processor will extract the historical data for the bonds. As part of rebuilding qph file, I will try extracting historical prices from old qph file, deleting incorrect data, and importing correct csv file back into Quicken. Since there are fewer bonds in my portfolio than stocks, this should be a manageable task.
New Quicken.com Investing and Quotes Download Sep 01, 2008 09:11 am
This post is about: Quicken Premier 2008
q.lurker wrote:
Mary: I noticed that lack of volume import issue also - with QW2009. Is that what you were running? I know your prior description (the link) worked fully in QW2007.
Hi q.lurker,
Humm, interesting. I am running Q2008 Premier, but the price history file is from Q2009. When I rolled back from Q2009 to Q2008, I thought the easiest way to fill in the blanks in the price data was to rename the Q2009 .qph file to the Q2008 fileset name.
I will have to try swapping out the .qph file to the Q2008 version and see if that makes a difference in the import of the volume data.
Thanks. Didn't realize this was possible because I had my bonds correctly identified as such and when security is identified as a bond, the symbol field is grayed-out. However, when I changed security type to "other", I was able to enter a "ticker" for each bond.
Perhaps you realize this and didn't include it. I believe after you have changed the Sec-type to Other and entered a ticker (symbol), you can change the type back to Bond, and the ticker will stay.
New Quicken.com Investing and Quotes Download Sep 01, 2008 10:53 am
This post is about: Quicken Premier
This new improved platform has demonstrated in spades this week that it is totally unreliable. The current and historical quotes are still screwed up and now I am showing a one day slip in the quotes. For example Ariel Fund (ARGFX) shows $39.27 for Friday August 29th and $39.11 for Saturday August 30th. This should show $39.27 for Thursday August 29th and $39.11 for Friday August 30th.
Apple shows the same problem. AAPL shows $173.74 for Friday August 29th and $169.53 for Saturday August 30th. This should show $173.74 for Thursday August 29th and $169.53 for Friday August 30th.
I don't think the stock market is open on Saturdays!
This one day slip is true for all 25 of my Mutual Funds and/or stocks.
This Quote problem has got to be fixed or we all will abandon Quicken. I have been a user of Quicken since 1984 and I have never experienced anything like this.
New Quicken.com Investing and Quotes Download Sep 01, 2008 12:39 pm
This post is about: Quicken Premier 2008
All I get when I try to update my info to quicken.com is "server not available .. try again later". So I have not been able to update my information at all on quicken.com. I tried to change to a new quicken.com userid and that still gives me the same warning. Unfortunately I am finding Quicken upgrades last two years to be very poor and I have used Quicken for many many years.
New Quicken.com Investing and Quotes Download Sep 01, 2008 12:48 pm
This post is about: Quicken Deluxe 2008
I am now getting an error from OneStep Update just trying to download quotes & historical prices:
The server is not responding properly. Please try again later.
For historical prices it is saying "the securities are not recognized."
Forums