Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Year to Date Returns--Portfolio View-- Certificates of Deposit from Brokerage firms

Gary R
Gary R Member ✭✭
edited July 2020 in Investing (Windows)
Oh Boy! Last week I posted a question about Year to Date Returns not agreeing with my Brokerage statements and issue was resolved thanks to this great group.
I just noticed today that Year to Date Returns on Portfolio View in Quicken are messed up. I'm not talking about comparing to my brokerage. Example. Interest received from Citibank $400 in 2020----Return Year to Date $650. Nothing agrees with the two interest payments received on my Cd's during the year and the Return Year to Date from the Cd. This makes no sense.
Security view shows the two interest payments of $200 each ($400 total) but Return Year to Date shows $650---(Removed) is going on here??????

Best Answers

Answers

  • Gary R
    Gary R Member ✭✭
    Your guess was absolutely correct. All my CD's are market traded. I tested a few and was able to reconcile the Year to date return. I had no idea that the price of these CD's changed daily. All I know is they are Federally insured and my principle is paid back at maturity like bank CD's.
    I really appreciate your time and help in resolving this issue. I would have never been able to figure this out on my own. This community forum is just great.
  • Gary R
    Gary R Member ✭✭
    I only wish that I had taken them out for longer than 3 years. They are paying 3% and renewals are coming up paying 1%. Gonna be taking a big cut in interest income over the next two years.
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    I know.  I don't invest in CDs for myself but 1-1/2 yrs ago I set my mother-in-law (I have POA for her) up with a 5-yr ladder and starting in Feb they started maturing.  I started looking at reinvesting in 5-yr CDs to replace the ones that had matured and found the best rates pay only 1%-1.5% which is what good MMFs now pay so that's what I reinvested her money into.  Low Fed rates are great for businesses and people who need loans but they suck for investors.
    (QW Premier Subscription: R32.12 on Windows 10)
  • Gary R
    Gary R Member ✭✭
    Low rates really suck for individuals, but on March 23, of this year my portfolio was down 40% and that really sucked. 1% was looking real good at that time--lol
    Follow up question
    For brokerage CD's, is there any way that I can stop the dowload with the current price? I just changed January 1, 2020 and 7/20/2020 to $100, but don't want to see price changes for these CD's.
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    edited July 2020
    Pull up your Securities List (under Tools).  Uncheck the boxes in the Download Quotes column for the CDs for which you no longer want prices downloaded.  Then click "Done" at the lower right corner of the Securities List screen.
    (QW Premier Subscription: R32.12 on Windows 10)
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Gary R said:
    Low rates really suck for individuals, but on March 23, of this year my portfolio was down 40% and that really sucked. 1% was looking real good at that time--lol
    Follow up question
    For brokerage CD's, is there any way that I can stop the dowload with the current price? I just changed January 1, 2020 and 7/20/2020 to $100, but don't want to see price changes for these CD's.
    Pull up your Securities List (under Tools).  Uncheck the boxes in the Download Quotes column for the CDs you no longer want downloaded.  Then click "Done" at the lower right corner of the Securities List screen.
    I believe you would also need to edit the security details and uncheck the box about "Matched with online security" as the brokerage is likely to be supplying prices for those securities.  Unchecking that box might create other issues as the brokerage downloads interest payouts or your eventual sales.   
  • Gary R
    Gary R Member ✭✭
    Boatnmaniac---All the boxes for CD quotes were already unchecked previously but prices still downloaded daily.

    q_lurker--I was actually going to try that before I posted today, but thought it may present problems just like you mentioned.
    I may try it for a few CD's and see if it works.
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    Interesting.  I have 4 different MMFs in my accounts and I had unchecked the Download Quotes box for each of them years ago because sometimes downloading quotes for them would cause some problems (to be honest, I can't even remember what those problems were).  Doing this resolved those problems and since MMFs always are $1/share there haven't been any holdings value issues since then.  
    I never unchecked "Matched with online security box" for them. Keeping that box checked has never caused any dividend, reinvest dividend or payout issues with them.
    So, I'd assumed that the same would be applicable to CDs.
    I hadn't looked at the MMFs securities price histories in a long time but I did just now and was surprised to see that quotes have indeed been downloaded sporadically.  It's understandable that this would occur when I would buy or sell or reinvest dividends but for most of the price updates aren't tied to any such event.  So, maybe keeping that box checked does have something to do with quotes sometimes downloading.

    (QW Premier Subscription: R32.12 on Windows 10)
  • Gary R
    Gary R Member ✭✭
    I'm going to uncheck the box for all my Cd's. (Match with on line security)
    Thanks
  • Gary R
    Gary R Member ✭✭
    CRAP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!THIS REALLY SUCKS
    Yesterday I unchecked all CD's in Security View (Match with online security) Are you sure you want to unmatch security----YES
    I also unchecked Download quotes in Security View for all CD's.
    Guess What?
    This morning Quicken updated all my CD's with the current market price. Match with online secuity was checked again for all CD's.
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Gary R said:
    ....
    Guess What?
    This morning Quicken updated all my CD's with the current market price. Match with online security was checked again for all CD's.
    So I think what is happening there is that 
    a) your download from the brokerage found securities in the brokerage's list that were not matched to any Quicken security.
    b) the program found securities in your Quicken records that identically matched the securities reported by the brokerage.
    c) the program decided those must be matches, and did so without confirmation from you.  

    Had the names (and tickers?) be distinct enough, I think the program would have asked for your input or confirmation on the match.  But even at that, my recollection is still that the program requires some sort of match -- that the brokerage's security must somehow be associated to a Quicken security.  

    So the only way to keep the price at face value would seem to be to delete the other prices after each download.  

    Now might be the time to ask:  Why the problem with the market value prices?  If you can sell the CD on the open market today (yesterday) for 102 or 98 cents on the dollar, what is wrong with seeing that information?
  • Gary R
    Gary R Member ✭✭
    I have 24 CD's. Yesterday I set the prices back to face value for 1/1/20, and 7/20/20. Honestly, too much work and time to do it every day.
    I have no intention of selling the CD's before maturity. They are earning 3-3.5%.
    The market price means nothing to me. But you're right. Probably should keep them at market value since that is what the brokerage firm is using for total performance.
    Thanks again.
This discussion has been closed.