Weird Stock Split question - 1:7109 split penny stock (edit)
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
-
"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.
0 -
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
0 -
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.
0 -
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.
0 -
@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 VP0 -
have never seen anything like this -
What is the stock symbol ?
0 -
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!
0 -
oh - penny stock - zero value - worthless
-
0 -
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.
0
