RELATIONSHIP OF CUSIP TO SECURITY OR SECURITY NAME

Dave Robinson

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

Sherlock

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

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.

Sherlock

Jim_Harman said:

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

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. 

Dave Robinson

How do I edit two securities to combine them under one name, is there a way to merge two into one? the security at the institution is the same for both. I started renaming them in the register and now wish to undo it.

Sherlock

Dave Robinson said:

How do I edit two securities to combine them under one name, is there a way to merge two into one? the security at the institution is the same for both. I started renaming them in the register and now wish to undo it.

As previously explained, the only way to combine them under one name is to replace the references to one of the securities with the other in the transactions.  Once you are no longer referencing a security in any transactions, Quicken will allow you to delete the security.