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.
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."
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. Any one else having this problem?
I assume from the comments in this thread that everyone is having the same problem. I will not update any stock data on the Quicken website because of all the corrupted data. Will someone start a new thread with suggestions of how to move from Quicken to better alternatives?
New Quicken.com Investing and Quotes Download Sep 01, 2008 04:03 pm
This post is about: Quicken Premier 2008
As I mentioned before on this thread, there is no need to move to another product unless you are so fed up you feel like you must.
Download the freeware software NetStock.
Set up NetStock once by adding in your stock and mutual fund symbols.
In NetStock, after it automtically updates prices, FILE > Quicken Export.
This will create a file named prices.csv. Save this file to your C: hard drive.
In Quicken, go to Portfolio view. Then FILE > IMPORT > Import prices. You can only do this from the Portfolio view.
When prompted, enter C:prices.txt and Quicken will enter current day ACCURATE prices into Quicken.
The initial setup takes just a bit of time...after that I can do this in less than a minute!
When doing a One Step Update, uncheck "Download quotes, asset classes, headlines and alerts". Continue leaving this unchecked until Quicken finds a way to download quotes that actually works.
New Quicken.com Investing and Quotes Download Sep 01, 2008 04:43 pm
This post is about: Quicken Premier 2008
What is Quicken 6? An old DOS version of Quicken?
If you are referring to Quicken 2006, it will work in that version.
What is really interesting is that this also works for "retired" versions Quicken 2005 and earlier.
Quicken disabled download capabilities for those versions, but NetStock will work where Quicken has an "Import prices" feature. That just leaves transaction downloading as the only main feature that has been disabled.
Completing your user profile to include the Quicken version/year and Windows operating system helps others troubleshoot your problem.
You should only floss the teeth you want to keep!
Currently using Quicken 2009 Rental Property Manager R5.
New Quicken.com Investing and Quotes Download Sep 01, 2008 05:26 pm
This post is about: Quicken Online
I like Yahoo as well, especially the plotting features. However, you have to load everything manually. Morningstar is a good choice and you can upload info from Quicken on PC, although cumbersome for those of us who use PC versions for automatic update feature from institutions.
Biggest plus to me for Quicken.com was automatic update from Quicken on desktop AND its portfolio view, all on one page! Of course, that has all changed now. The new Quicken.com does seem to have features that will be benefitial once they get them working, like memorizing custom views, incremental updates, correct portfolio value graphs, sort holdings by name option (symbols suck), just to name a few.
My gut tells me though that the new will not be as powerfull as the old and that Intuit Management does not care.
I too am now using broker sites for daily tracking until Quicken.com shapes up or I decide on another method.
Forums