QWin 2017: Portfolio X-Ray Does Not Find Assets

  • 0
  • 1
  • Problem
  • Updated 3 days ago
  • In Progress
  • (Edited)
I just purchased Quicken 2017 Premier, R4, 26.1.4.5. When applying it to a particular portfolio it correctly shows an asset allocation of 33% domestic bonds, 65 % cash, and 2% large cap stocks, which is obviously a very conservative asset allocation. I thought I would try the Portfolio X-Ray feature which was not included in the versions of Quicken I have previously used. The X-Ray feature told me this was a very aggressive portfolio because it completely ignored the bonds and cash, only including in its analysis the large cap stock that makes up 2%. What's wrong with this apparently useless and misleading feature?
Photo of Donald Range

Donald Range

  • 150 Points 100 badge 2x thumb

Posted 4 days ago

  • 0
  • 1
Photo of NotACPA

NotACPA, SuperUser

  • 315,594 Points 100k badge 2x thumb
Obvious question ... but were you including All Securities?  Because it seems to work properly for all combinations of accounts that I could test

Photo of Donald Range

Donald Range

  • 150 Points 100 badge 2x thumb
Thanks for the suggestion, but that does not seem to be the problem. The top bar shows "All Accounts" and "All Securities," and I refreshed X-Ray, and even exited and restarted Quicken. Same result: no bonds or cash show in the X-Ray even though the bonds are set to Quicken's type of "Bond" and Asset Class of "Domestic Bonds." And the bonds and cash are properly allocated within Quicken's Asset Allocation screen.
Photo of NotACPA

NotACPA, SuperUser

  • 314,554 Points 100k badge 2x thumb
OK, another possibly obvious question.  Do the bonds have ticker symbols associated with them?  I saw something that indicated that securities for inclusion needed the tickers ... so that Morningstar could look them up.

AND, in Q, how is the cash held?  In a MMF, or as cash in a brokerage acct?  If a MMF, does it have a ticker?
Photo of Donald Range

Donald Range

  • 150 Points 100 badge 2x thumb
Some of the bonds have a 7-digit number in the greyed-out Symbol field, which is the second from the top in the Edit Security Details dialog box. I didn't enter these "symbols" so perhaps Quicken looked them up from the bond description or from the purchase transaction. But bonds don't show in the X-Ray whether the Symbol is present or not. The Edit Security Details screen has an Other Info button and when this is used it shows a CISIP number for the bond at the bottom of the screen. All of the bonds have these CUSIP numbers. Again, I did not enter CUSIP numbers, so I assume Quicken looked them up.
Regarding the cash, some is in cash in brokerage accounts and some is in CDs held in a brokerage account or in banks. All CDs are entered in Quicken as Type=CD and Asset Class=Cash. None show up in the X-Ray. Some have CUSIP numbers and some do not. No Money Market Funds are involved.
Photo of Jim Harman

Jim Harman

  • 2,700 Points 2k badge 2x thumb
Also the X-Ray depends on your holdings having correct tickers (or maybe CUSIPs?) and being in Morningstar's database, which is OK for stocks and publicly traded mutual funds, but not for things like TIAA Traditional, 401k Stable Value funds, etc. When you say "it" at the top of your post, I assume you are referring to Quicken's asset allocation. Does a lot of your portfolio show up as "not classified" in the X-ray asset allocation?

You might also look at the Top 10 holdings at the bottom of the X-ray to see if anything major is missing.
Photo of NotACPA

NotACPA, SuperUser

  • 315,434 Points 100k badge 2x thumb
I found out about the ticker requirement when I tried X-ray on one of my wife's accounts ... which is at TIAA and holds only TIAA Traditional.
Photo of Jim Harman

Jim Harman

  • 2,700 Points 2k badge 2x thumb
Another shortcoming of the X-ray analysis is that for bond funds it classifies all of the holdings into one of their bond style boxes. This is inaccurate for funds that hold a mixture of maturities and ratings like Vanguard Total Bond Market. And it gets very confused for the popular Pimco Total Return, which acts like an intermediate term bond fund but holds both long and short positions using a lot of derivatives.
Photo of Donald Range

Donald Range

  • 150 Points 100 badge 2x thumb
No bond funds involved in my portfolio where X-Ray isn't working. All bonds are individual US corporate bonds purchased through a brokerage house and held there.
Photo of Donald Range

Donald Range

  • 150 Points 100 badge 2x thumb
Yes, when I said "it" was correct in Quicken I was referring to the Asset Allocation tab in Quicken's Portfolio view. This tab includes in the asset allocation the bonds, CDs, and cash items that are missing in the X-Ray tab of the portfolio.
The "Not Classified" allocation in the X-Ray is zero. So is the Cash, Bonds, Other, and Non-US Stocks.  US Stocks is listed at 100%. The top ten list at the bottom is missing everything except the stock that makes up 2% of the portfolio.