Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Investing (Windows)
CUSIP & Stock Splits
thansen
I believe Quicken uses CUSIP numbers to link downloaded stock data to tickers in your data file. I also believe the CUSIP number changes (last 3 characters) when a stock splits.
Now this results in the same ticker being listed twice in the security list (different CUSIP numbers).
When you enter a stock split transaction you get to pick 'security name', the number of 'new shares' and the number of 'old shares'.
How is this supposed to work?
Is 'security name' the old entry in the security list or the new entry?
Stock data should be sourced from old security list entry before the split (and adjusted appropriately) and from the new security list entry after the stock split. How is this possible if you only specify one the security list entry in your stock split transaction?
Find more posts tagged with
Investments
Windows
Comments
thansen
I guess I could ask what is the proper way of handling stock splits (assuming CUSIP changed)? What kind of account transactions should I have in my account register?
I see some of my downloaded accounts (Pershing and Fidelity) have 3 transactions: The split transaction which has no impact on the account value & holdings, a remove stock transactions (old CUSIP) and a add stock transaction (new CUSIP). This seems to do the job but also seems cumbersome. Now to compute performance you would to remember to include all the security entries associated with a particular ticker. Quicken must have a better way to handle this?
q_lurker
Sometimes the CUSIP changes, sometimes not. More often not in my experience but that is not definitive by any means.
If the CUSIP does not change, it should be a simple StkSplt transaction.
If the CUSIP does change, I would still use the StkSplt transaction. I would then follow that up by going to the Security Details for that security, unchecking the box as Matched with Online security. That should effectively remove or disable the current CUSIP. I would then go through Tools / Online Center / Financial Institution selection / Account Selection / Holdings Tab, and click the "Compare to Holding". That should create the opportunity to associate the broker's 'new' version with the 'new' CUSIP to your version of the security. You should more simply get the same matchup opportunity with the next download from the FI.
With all that, the StkSplt would be the only transaction in the Quicken records. Delete any Removes or Adds the brokerage may have sent.
HTH
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of