RELATIONSHIP OF CUSIP TO SECURITY OR SECURITY NAME

Can I change the relationship Quicken assigns to a downloaded security CUSIP. As example, I have a CUSIP of "(9999776)" which I have manually changed to "(9999776) CASH". Originally I changed them all manually. So I now have both. I wish to eliminate the display of the CUSIP number and only show a name. I could convert ALL my securities manually, however in the case of the two cash noted above, I cannot change them both to "CASH" since I cannot do them both at one time. Convert one then can't convert the other due to naming conflict. The result I am looking for is to only display the Name, eg "MSFT" or "CASH" for all my securities.

Ideas??

Thanks, Dave

Answers

  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    The CUSIP ID is provided by the financial institution when we download transactions. The CUSIP ID is assigned to a Quicken security when we match an online security to a Quicken security.   Quicken should prompt to match an online security to a Quicken security when the financial institution provides a security with a CUSIP ID that has not been assigned to a Quicken security.  If a Quicken security has been mismatched, we may uncheck Matched with online security on the Edit Security Details window and the Quicken security will become available to be matched to an online security when Quicken next encounters an unmatched online security.

    If you have inadvertently entered transactions using an incorrect Quicken security, I suggest you replace the security in the transactions. 
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Also you can rename securities as you wish. Quicken uses the CUSIP number to match to downloaded transactions and the Symbol (ticker) for downloading quotes.
    QWin Premier subscription
  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    Also you can rename securities as you wish. Quicken uses the CUSIP number to match to downloaded transactions and the Symbol (ticker) for downloading quotes.
    Quicken uses the CUSIP ID to match security from the financial institution - that includes transactions, share balances, and quotes.  

    Quicken uses the ticker symbol to pull prices from the third-party quote service.
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    To supplement those prior (very accurate) answers, the name used in Quicken for a security does NOT need to match the name used by either Quicken's lookup sources for price quotes, or your financial institution for downloaded transactions, holdings and prices.

    As you noted, two distinct securities in Quicken cannot have the same name (CASH in your example).  In my experience, financial institutions rarely hold cash, they operate with MM funds as sweep accounts.  The MM fund used at one brokerage is typically different that what is used at a different brokerage.  I suggest those types of funds, if maintained in Quicken, should have names reflecting their true name rather than a catch-all CASH. 

    Some users for simplicity choose to not reflect the MM sweep funds in their Quicken file.  They allow the Quicken account to have a cash balance and recognize that cash balance should match what the financial institution reports as its MM fund balance.