Portfolio Views-Incorrect Market Values-"As of" dates

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)?

Reply to
JRoss
Loading thread data ...

Why aren't you just running a Net Worth report by month?

Reply to
John Pollard

Thanks John, I'll try that.

Reply to
JRoss

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.

Reply to
John Pollard

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?

Reply to
John Pollard

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).

Reply to
JRoss

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?

Reply to
John Pollard

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!

Reply to
JRoss

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.

Reply to
John Pollard

But meant to write:

"I believe the recommended method for the conversion you did is a Corporate Acquisition"

Reply to
John Pollard

Thanks John, you are very generous with your time.

Reply to
JRoss

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.