Weird Stock Split question - 1:7109 split penny stock (edit)

JF73
JF73 Quicken Windows Subscription Member ✭✭
edited December 2023 in Investing (Windows)

One of the securities in my Schwab portfolio had a 1:7109 stock split. Any idea how to enter this into Quicken? It won't allow it

thanks

Comments

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2023

    "1:7109"

    You got 7,109 shares for each 1 share owned? Is that correct? Or is that 1 for every 7,109?

    I guess you could use a Remove and then an Add, or series of Adds if you have more than one lot if the former.

  • JF73
    JF73 Quicken Windows Subscription Member ✭✭

    Tom, it's the other way around. They reduced my shares, and I can't figure out how to do the math in Quicken

    Thanks

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Not at my Quicken, but I can imagine the problem. Using the inverse 0.000141 is not (may not be) accurate enough.

    Is this one or two lots or many lots?

    My basic alternate would be:

    • Assume you had a lot of 15,000 shares
    • You would be due 2.11 shares
    • You would receive 2 shares and a cash-in-lieu amount for the 0.11 shares
    • I would Remove Shares for the 15,000
    • Add Shares for the 2.11 with the full basis of that lot and the applicable Acquisition Date
    • Sell the 0.11 shares for the cash-in-lieu amount.

    For multiple lots. You could consolidate the Remove Shares and the Sell to individual transactions rather than per lot.

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭

    You can't do this directly into Quicken, either way, using the stock split wizard. You're going to have to do all your calculations outside of Quicken and then do the Remove and Add(s) that get you to the correct ending point. It will be pretty easy if you only have one lot, or just a few.

    You may want to see how Schwab actually ends up showing this at their site and just copy their results (manually of course) though I'd expect that they probably will download the something into your file for this split so you may want to wait for that to show up.

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @JF73, did you get any "cash in lieu" for fractional shares sold?

    How many shares did you own before this transaction? How many shares after?

    And, if you'd name the security it would make our effort to help you easier.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • Ps56k2
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭

    have never seen anything like this -

    What is the stock symbol ?

  • JF73
    JF73 Quicken Windows Subscription Member ✭✭

    Thanks for your help guys!! The stock symbol is MCHA (used to be GEAR). Some shady penny company, it's now pretty much dead....I know, stupid trade..…but I'm just trying to figure out how to at least get the worthless share count correct in Quicken.

    Thanks again!

  • Ps56k2
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭
    edited November 2023
  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Since the company actually is worthless, and probably will be history soon, if all you want is an accurate share count and nothing more, then do a Remove of ALL the shares, do an Add for the correct amount of shares that you've calculated outside of Quicken. Round down to the whole number of shares resulting from your calculation.

This discussion has been closed.