This discussion was created from comments split from: Portfolio Xray issue.
I remember when this ETF issue was a problem a few months ago but then it was fixed and looked OK.
But today I checked Portfolio X-Ray in my primary data file and see that the issue has returned. I did manually reselect all accounts and all securities as well as manually refreshed X-Ray. Currently a large percentage of my investments are ETF and Bonds, both of which are not accounted for correctly in Portforlio X-Ray.:
For comparison, here is what Quicken's Asset Allocation graph looks like. It seems to be pretty close to what I expected to see.:
Hello @Boatnmaniac,
Thank you for letting us know you're also seeing this issue. The ETF issue returning has already been reported; ticket CTP-18131. The main discussion for that issue is:
So far, you're the first I've seen reporting problems with bonds not reflecting correctly. Is this happening only in the Portfolio X-Ray? If not, where else are you seeing it? Are all bonds affected?
I look forward to your reply!
@Quicken Kristina - Thanks for posting the link to the main thread on this issue. Since I stopped actively managing most of our financial investments a couple of years ago and turned it over to a financial management company I haven't found a need to use Portfolio X-Ray very much anymore. That explains why I'm a bit behind the curve on this issue.
Bonds not showing up is only happening in Portfolio X-Ray. Here is what it looks like after I deselected all securities except for bonds:
I then decided to replace bonds with brokered CDs (which are mostly just a variation of bonds) and got the exact same result. So it is not capturing CDs, either.
I then selected all securities except for Bonds, CDs and ETFs and this is what it shows. I'm not sure if it is right be it does show data in the buckets I would expect it to be shown in. Except that I'm now seeing some Bonds data but maybe that is picking up Bonds allocations in some of my MFs. picked up. But I don't know what that "Not Classified" is.:
Thank you for your reply @Boatnmaniac,
Sorry for the delayed response. I didn't receive a notification that you'd responded.
I tested in my file and observed similar behavior. When only bonds and CDs are selected, the Portfolio X-Ray acts like it's all cash.
I suspect the "Not Classified" is your CDs. When I added CDs to my file to test the issue, I noticed that Quicken defaults the Asset Class for CDs to "Not Classified."
I forwarded this issue to the proper channels for further investigation and resolution. Since I replicated the issue, we shouldn't need logs.
Thank you!
(CBT-1302)
We received some feedback from the escalations team regarding this issue, and I wanted to share this with you.
Portfolio X-Ray is powered by Morningstar. When the user opens it, Quicken sends Morningstar a list of your holdings and their values. Morningstar can only identify a holding if Quicken has a Morningstar ID for it. Quicken gets that ID when it downloads quotes for the security.
If a security has no Morningstar ID, Quicken leaves it out of what it sends, and it doesn’t show an error. Morningstar doesn’t cover every security, and a security that never gets a successful quote download can’t pick up an ID.
This is why bonds and CDs behave as they do:
The Asset Allocation graph is calculated separately from Morningstar, which is why it looks right to you.
Things you can try
This may not help for every security, because some bonds and CDs have no Morningstar coverage.
Please try the steps above for the bonds and CDs you are having issues with and let us know if it helped resolve any.
Thank you. I look forward to your response.
Thanks for the follow-up on this, @Quicken Kade. As shown in this pic of my Security List:
OSU SETTINGS: Securities are set up in OSU settings to be downloaded and prices are updated in Security Details in Quicken each day during OSU. These daily price updates reflected in all of the various relevant investments views and reports.
OSU SUMMARY: I get a message after most OSUs that the prices did not download for any of the Bonds and CDs. Yet, as mentioned in the prior paragraph, the prices are actually updated during OSU. Following is a picture of that message. The picture below lists only some of the Bonds but I confirmed that the entire list includes all of the Bonds and CDs shown in the picture above. So, why am I getting this message when the daily updated prices have actually been downloaded?
After verifying all of the information provided above I then opened Portfolio X-Ray and essentially got the same results as I'd posted earlier in this thread:
So, bottom line is that after following the steps you listed there was virtually no change in the outcome in Portfolio X-Ray.
Any other thoughts or suggestions?
@Quicken Kade - I thought you might find this of interest. On the Portfolio view on the Investing tab I have a column for "Morningstar Rating" which shows the ratings Morningstar assigns to most of my stocks and MF securities. But there are no ratings shown for the CDs, the Bonds and all but one of the ETFs. I'm thinking that this is probably a good indication that Morningstar does not, as you mentioned, cover these securities and is why these are not being accounted for in the Portfolio X-Ray.
This one shows the CDs and some of the ETFs that I have. Only 1 ETF has a Morning Star rating (highlighted in green) but this is not being picked up by Portfolio X-Ray..
Here is a picture of a different account that is comprised mostly of Bonds. Same thing….no Morningstar Ratings.:
Morningstar can only identify a holding if Quicken has a Morningstar ID for it. Quicken gets that ID when it downloads quotes for the security.
This concept of a Morningstar ID is new to me. What Quicken has used for decades for downloading quotes has been the ticker symbol. Is the Morningstar ID different than that?
The problem becomes two-fold as I see it. First, when you download or create a new security for a bond, the ticker is not (usually) filled in. So the statement that Quicken ‘gets’ the M* ID when it downloads quotes sounds inaccurate to me.
Second, users (myself and others and perhaps brokerage) will fill in the ticker field with the CUSIP of the bond as a convenience. Doing so does not cause prices of the bond to download because it is not a valid NYSE (or other) ticker. I doubt that M* sees it as a valid M* ID, either.
@Quicken Kade - please clarify this M* ID concept especially if is different than the ticker field.
I agree with @q_lurker on the "Morningstar ID." As far as I can tell, Morningstar is supposed to use the security's Ticker Symbol to identify it for the X-Ray.
Stocks, ETFs, and publicly traded mutual funds have valid Ticker Symbols and in the past they have all worked correctly with the X-Ray. This includes funds and ETFs that hold bonds.
Individual bonds and private funds, often used in 401(k)s, do not have Ticker Symbols and they have never worked correctly with the X-Ray.
@Boatnmaniac I don't think the Morningstar Rating column is a good indicator of whether a security is included in Morningstar's database. In most cases it is populated only for publicly traded mutual funds.
A somewhat better indicator may be the Industry/Category column, which is populated for mutual funds and individual stocks, but for some reason that column has never been populated for ETFs, even though they used to work correctly with the X-Ray.
Hello Everyone,
Thank you all for taking the time to share your findings and provide additional insight into how Morningstar identifies securities for Portfolio X-Ray. We have reviewed the information and appreciate the detailed responses shared throughout this discussion.
We will be passing along the information provided, along with your questions, and we will let you know when we hear back. Your feedback is valuable in helping us better understand the behavior.
Thanks for sharing your experience and contributions to the community!
The problem becomes two-fold as I see it. First, when you download or create a new security for a bond, the ticker is not (usually) filled in.
…users (myself and others and perhaps brokerage) will fill in the ticker field with the CUSIP of the bond as a convenience. Doing so does not cause prices of the bond to download because it is not a valid NYSE (or other) ticker. I doubt that M* sees it as a valid M* ID, either.
I have many individual bonds, but I never really paid much attention to the Tickers or CUSIPs of them. I do not manually add the bonds. Fidelity downloads them when they are bought, and they are downloaded with the CUSIP already listed. I don't know why I didn't make the connection before, but when Fidelity downloads the bonds, the CUSIP is what is listed in the Ticker field, and the Ticker field is also not editable.
I don't know if any of this makes any difference regarding this Portfolio X-Ray issue, but I find it to be an interesting discussion. Thanks to everyone for your insightful comments.
@Boatnmaniac Thanks for the confirmation about Fidelity’s process for bond downloads.
the CUSIP is what is listed in the Ticker field, and the Ticker field is also not editable.
FWIW (not much): if you change the security type away from Bond, you can edit the ticker field. Then change the type back to Bond. I do that if I want to add the CUSIP to a bond’s ticker field.
Thanks. I'll be sure to keep that in mind for the future.