I tried checking the market value of my portfolio through the course of this year by changing the register "as of" date to the first weekday of each month. I got bizarre results. For instance, the March market value was considerably higher than it is now, or ever has been. I'm sure that is not true. Is there something else I need to do to get accurate total market values for my portfolio on past dates? For instance, do I need to include/exclude accounts or securities to reflect my actual holdings on a particular date (they haven't changed much)?
Portfolio Views-Incorrect Market Values-"As of" dates
Nov 06, 2005
11 Replies
Why aren't you just running a Net Worth report by month?
Thanks John, I'll try that.
Same result. The problem seems to involve one of my Vanguard funds which converted from “Investor” to “Admiral” shares. Quicken seems to be applying Admiral share pricing to the # of Investor shares I had before the conversion, producing values more than 3 times what they should be. I had no such problem with my other Vanguard conversions.
Sorry, I wasn't necessarily sugggesting the Net Worth report would give different results, just answering your question about how to see the progress of your worth over time.
Sorry again, got distracted, meant to add: if one ticker has incorrect prices (you can verify this manually), why not just download historical prices for the ticker with the wrong prices?
It's not really a question of wrong prices--Q just thinks I had VGSLX from day 1, whereas I had VGSIX until 5/16, when it converted to VGSLX (fewer shares, but higher prices).
How did you enter the "conversion" in Quicken? Did you rename the old fund and change the ticker? Or did you do a corporate acquisition?
John-- I did the conversion through a stock split. No name change--perhaps that's the problem--just a change of ticker symbol after doing the split. Of course, at that point, you're asked whether to merge or delete quotes (it looks like you can even do both), or let Q decide. I've seen messages on the Q board that recommend merge and others that recommend delete. Since Q provides no guidance, I used the default, so that could be the problem.
I did this for 2 other accounts holding a 2d Vanguard fund. For all 3 my current shares, market value and cost basis appear to be correct. I don't know if the other 2 have the same pre-conversion anomaly--their shares and prices for the Investor and Admiral shares were very close. Maybe I'll just punt, but it would be nice if Q specifically addressed this issue--it must affect many Q users. I'd make the suggestion, but they won't let me register on the official forum!
This last might explain that you have the same problem for the other two conversions but it is not so apparent.
I believe the recommended method for the conversion you did is a Corporate Conversion (despite the fact that it may present a problem of its own, I think it may be better than the stock split/change ticker).
I think the net result of your approach causes Quicken to treat what were, and are, two different securities, as being the same security. I think you essentially told Quicken that Admiral shares and Investor shares were the same security.
I don't understand how/why you can not register. But there is still a suggestion capability at the Intuit support site as far as I know. And someone has already made a suggestion for a unique treatment for "conversions" such as you had with Vanguard in the Intuit forums. Given the number of posts in the Intuit forums on the subject, I am certain that Intuit is aware of the problem.
But meant to write:
"I believe the recommended method for the conversion you did is a Corporate Acquisition"
Thanks John, you are very generous with your time.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required