Options
Don Awalt Member ✭✭✭✭
June 10 edited June 10 in Investing (Windows)
I own some shares in NVIDIA, which this morning opened with a 10:1 stock split. I accepted the split in Quicken from this dialog:
So now, my Investing/Portfolio (probably among other reports) is total trash. Here are the problems I see in the report:
-Quote/price is 1/10th of what it should be - it's showing as $12.08 a share instead of $120.80
-Market value is 10% of what it should be
-Cost basis in dollars is correct
-Average cost/share is correct
-Gain/loss is wrong
-ROI and Annual return are wrong
-Income in dollars is correct
and of course, it is wrecked those calculations for my entire portfolio.
If I say No/Clear the question on accepting the split that I show above, then:
-Price/share is now correct
-Shares are wrong
-Market value is correct
-Cost basis (dollars) is correct, cost/share is wrong
-Gain/loss, ROI, annual return is wrong
So either way everything gets hosed!
Should I do something different, to have this stock split work correctly, either from a backup or at this point? How do I correct/fix this? Thanks!
Don Awalt Member ✭✭✭✭
June 10
Options
Whew found the answer - Enter a stock split BEFORE you download transactions! Instructions are here:
https://help.quicken.com/pages/viewpage.action?pageId=3216615
Maybe something different in lieu of that dialog box should be presented, as the user is hosed if they did not know a stock split was coming - the "enter stock split has to be done before downloading quotes, etc.!
Hope this helps someone..
Don Awalt Member ✭✭✭✭
June 10
Options
Actually I spoke to soon, On the next download transactions, it apparently accepted a stock split without the dialog box I showed above, so after entering the stock split transaction manually and having everything correct, the price, market value, cost/share, gain/loss, ROI, Annual return are all 10% of the correct values again.
Help!
isonclubikin Member ✭✭✭✭
June 10
Options
Same problem here: Nvidia's stock value in Quicken is 10% of what it should be. It looks like the 10:1 split went in correctly, but Quicken has divided the correct new price by 10. I can't see where it's doing that, though. The stock price history shows the last price as being the correct-ish one (about $120/shr). But, the portfolio is showing the price at about $12/shr.
Jim_Harman SuperUser ✭✭✭✭✭
June 10
Options
Often when there is a split, the date of the price change in Quicken's quote feed is off by a few days.
It may be necessary to edit the price history so that the price jump occurs on the same day as the split.
Also make sure you have only recorded one split, not two.
QWin Premier subscription
Don Awalt Member ✭✭✭✭
June 10
Options
OK, I think it's working. The key was not only entering the stock split transaction, but I had to enter the new current price, which the dialog box for Enter Stock Split says is "optional". At least in this case, it's not optional - without a value there, Quicken will calculate the price incorrectly.
Don Awalt Member ✭✭✭✭
June 10
Options
So the complete solution, if you have stumbled onto this problem with NVDA this morning:
- Recover your last backup.
- Manually enter a stock split transaction for NVDA - old shares 1, new shares 10. ENTER the stock price which is 10% of the closing price from Friday afternoon (should be ~ $120.888) - this is important, the dialog box says optional - enter it. Enter effective date today, 6/10. Close the box.
- Verify in investment report only quote price, shares, and average cost per share have changed. Other values (market value, cost basis in dollars, gain/loss in dollars, income, ROI, Annual Return %, etc.) should not change.
- Download transactions from your brokerage - this is what will download the stock split instructions.
- It should not have changed anything - verify all is correct!
msmith99usa Member ✭✭✭
June 10
Options
Just checking Q (Premier, Version R56.9, Build 27.1.59.9; running on Windows 10) after downloading transactions for past few days. Looks like Q started reporting NVDA price per share as if the 10:1 Sock Split occurred on 6/3, NOT after close on 6/7. What is causing this? It is not like this is a surprise to anyone!
1
Dave1957 Member ✭✭
June 10 edited June 10
Options
After entering the NVDA stock split 10-1 transaction, my number of shares remain the same.
I am showing a massive loss in my portfolio because the share numbers have not increased.
Why is the stock split transaction NOT working?
How do I adjust the shares manually if Quicken can't do simple math?
bmciance SuperUser ✭✭✭✭✭
June 10
Options
Are you sure the number of shares is wrong? It worked for me but the issue is with the price for the prior 5 days. This is always the issue with stock splits. For some reason the Quicken Quote service incorrectly adjusts the price on the security for the last 5 days. If you go back and change the price for these days it will mostly fix the issue. It seems the only issue it does not fix is the total daily gain/loss on the account with the security. The individual security will be fine and the total portfolio is fine but the total for the account will still be off (not sure why other than it is a bug)
Dave1957 Member ✭✭
June 10
Options
Today's number of shares do not change after entering Friday's stock split 10-1.
bmciance SuperUser ✭✭✭✭✭
June 10
Options
Did you enter it manually or did the One Step Update suggest the split and enter the adjustment? I let the One Step Update enter the split shares and it worked fine.
Grunder Member ✭✭
June 10 edited June 10
Options
one of my accounts (Roth) had 25 shares of NVDA before the split. After downloading all accounts this morning, there are NO NVDA shares shown in the Q portfolio - there should be 250. Tried to d/l multiple times, and checked on the brokerage web site to verify the 250 shares are in the portfolio. ???
Ps56k2 SuperUser ✭✭✭✭✭
June 10
Options
check the Security Detail for NVDA in Quicken to see how many Quicken shares and which Quicken accounts -
Also - Quicken messes up with Splits - my NVDA showed the split price going back to 6/3 vs as of 6/10 -
I did get the split transaction from Schwab - so different brokerages may have different timelines for handling splits -Not sure how the NVDA would totally disappear from your holdings - again, look at the Security Detail -
QWin - R54.16 - Win10
Ps56k2 SuperUser ✭✭✭✭✭
June 10
Options
https://community.quicken.com/discussion/comment/20438110#Comment_20438110
yeah - my NVDA has the split price going back to 6/3 vs the current 6/10 split price
QWin - R54.16 - Win10
Don Awalt Member ✭✭✭✭
June 10
Options
I did notice the column "Day Gain/Loss" in the Portfolio report has a larger than normal number - not sure how that's being calculated. But the price and shares are correct so that problem will probably go away tomorrow.
fab5friend Member ✭✭
June 10
Options
I knew I wouldn't be the only one with Quicken problems today with the Nvidia split. For me, the "Price Day Change" value and % are way off. I looked at the price history and it looks like the last week's prices have been split adjusted. So the "Price Day Change" is not calculated off of that value. Does anyone know how that is calculated? I wish I had a 910% gain in one day. I hope tomorrow everything will be correct.
Ps56k2 SuperUser ✭✭✭✭✭
June 10
Options
just chill - Tuesday will have everything back to normal :)
QWin - R54.16 - Win10
Quicken Jasmine Moderator mod
June 10
Options
Hello All,
Thank you for taking the time to visit the Community to report this issue, though we apologize that you are experiencing this.
We have forwarded this issue to the proper channels to have this further investigated. In the meantime, we request that you please navigate toHelp > Report a problemand submit a problem report with log files, a sanitized data file, and screenshots (if possible) attached in order to contribute to the investigation.
Whileyou will not receive a responsethrough this submission, these reports will help our teams further investigate the issue. The more problem reports we receive, the better.
We apologize for any inconvenience! Thank you.
-Quicken Jasmine
Make sure to sign up for the email digest to see a round-up of your top posts.
Jim_Harman SuperUser ✭✭✭✭✭
June 10
Options
@Quicken Jasmine the issue with the incorrect share price following a split has happened many times in the past, it is an error by the quote provider. It would sure be nice if this was fixed.
See for example this post
https://community.quicken.com/discussion/7880103/apple-stock-split-year-to-date-returns
QWin Premier subscription
1
Ps56k2 SuperUser ✭✭✭✭✭
June 10 edited June 10
Options
as shown here - the NVDA price/quote was already showing the 10:1 price split quote as of 6/3 - a week ago -
I've updated the price back to a general $1,100 for each day of the entire week -
you can see the orig bogus 10:1 price quote displayed in the LOW entry -This pretty much happens every SPLIT - the bogus quotes are downloaded for the week before the split -
Guessing some market announcement is the trigger vs the actual day of the split -
QWin - R54.16 - Win10
2
Quicken Jasmine Moderator mod
June 10
Options
https://community.quicken.com/discussion/comment/20438172#Comment_20438172
Thank you for providing more information regarding this issue!
-Quicken Jasmine
Make sure to sign up for the email digest to see a round-up of your top posts.
ajs Member ✭✭
June 10
Options
I have NVDA shares in TWO different Quicken accounts. The stock split transaction only applied to one account. I had to manually enter a second stock split transaction into account #2 in order to see the correct number of shares. Why would the stock split transaction even have an 'account' field? The stock is going to split no matter what account it is in.
iseealine Member ✭✭
June 10
Options
stock splits with quicken are always wrong and need manual fixing. why is this? It isnt even math, it is arithmetic. Come on folks get this fixed. I saw the dialogue box and accepted it. My shares and price were all correct. My portfolio total was correct but my day gain was $60,000 more then it should be. Security details confirmed split price and new shares are correct. Please advise
iseealine Member ✭✭
June 10
Options
one more thing, portfolio totals are all correct. my problem in on the dashboard, NVIDIA shares, price and total value are all correct. the day gain is $60,000 more then it should be. The portfolio total in the dashboard is also correct
Ps56k2 SuperUser ✭✭✭✭✭
June 10
Options
I have NVDA shares in TWO different Quicken accounts. The stock split transaction only applied to
oneaccount.anything different between the 2 accounts - like SEPARATE or HIDDEN -
do they both show as holding if you do a - Security Detail listing for NVDAQWin - R54.16 - Win10
Categories
- All Categories
- 25 Announcements
- 11 Product Alerts
- 604 Welcome to the Community!
- 547 Before you Buy
- 1.1K Product Ideas
- 45.3K Quicken Classic for Windows
- 14.1K Quicken Classic for Mac
- 921 Quicken Mobile
- 702 Quicken on the Web
- 10 The Community Meetup Newsletter
