NVDA stock split just trashed Investing/Portfolio report - Shares & Price (edit)

Don Awalt
Don Awalt Member ✭✭✭✭
edited July 28 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!

«1

Comments

  • Don Awalt
    Don Awalt Member ✭✭✭✭

    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
    Don Awalt Member ✭✭✭✭

    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
    isonclubikin Quicken Windows Subscription Member ✭✭✭✭

    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
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    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
    Don Awalt Member ✭✭✭✭

    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
    Don Awalt Member ✭✭✭✭

    So the complete solution, if you have stumbled onto this problem with NVDA this morning:

    1. Recover your last backup.
    2. 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.
    3. 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.
    4. Download transactions from your brokerage - this is what will download the stock split instructions.
    5. It should not have changed anything - verify all is correct!

  • msmith99usa
    msmith99usa Quicken Windows Subscription Member ✭✭✭

    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!

  • Dave1957
    Dave1957 Member ✭✭
    edited June 10

    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
    bmciance Quicken Windows Subscription SuperUser ✭✭✭✭✭

    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
    Dave1957 Member ✭✭

    Today's number of shares do not change after entering Friday's stock split 10-1.

  • bmciance
    bmciance Quicken Windows Subscription SuperUser ✭✭✭✭✭

    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
    Grunder Quicken Windows Subscription Member ✭✭
    edited June 10

    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
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭

    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 -

  • Ps56k2
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭

    yeah - my NVDA has the split price going back to 6/3 vs the current 6/10 split price

  • Don Awalt
    Don Awalt Member ✭✭✭✭

    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
    fab5friend Quicken Windows Subscription Member ✭✭

    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
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭

    just chill - Tuesday will have everything back to normal :)

  • Quicken Jasmine
    Quicken Jasmine Quicken Mac Subscription Moderator mod

    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 to Help > Report a problem and submit a problem report with log files, a sanitized data file, and screenshots (if possible) attached in order to contribute to the investigation.

    While you will not receive a response through 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
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @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

    QWin Premier subscription
  • Ps56k2
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭
    edited June 10

    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 -

  • Quicken Jasmine
    Quicken Jasmine Quicken Mac Subscription Moderator mod

    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
    ajs Member ✭✭✭

    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
    iseealine Quicken Windows Subscription Member ✭✭

    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
    iseealine Quicken Windows Subscription Member ✭✭

    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
    Ps56k2 Quicken Windows Subscription Alumni ✭✭✭✭

    I have NVDA shares in TWO different Quicken accounts. The stock split transaction only applied to one account.

    anything different between the 2 accounts - like SEPARATE or HIDDEN -
    do they both show as holding if you do a - Security Detail listing for NVDA

  • Quicken Jasmine
    Quicken Jasmine Quicken Mac Subscription Moderator mod

    Please follow my instructions in this response to submit logs and let me know once you have done so.

    Thanks!

    -Quicken Jasmine

    Make sure to sign up for the email digest to see a round-up of your top posts.

  • AWinTx
    AWinTx Member ✭✭✭

    The Growth of $10,000 report is also miscalculated. It is as if the present value of NVDA is $0 based on the drop against the other indexes. If I run the report without NVDA selected, the final result is similar in both reports. It should be easy for the developers to replicate.

  • jameswoods1953
    jameswoods1953 Quicken Windows Subscription Member ✭✭

    Thanks! Your advice cleared up my problem. Using the above information to help others using Quicken for Mac, Delete the downloaded stock split for each account and enter your own stock splits. Fixed everything!! Thanks again Don Await!

  • Quicken Janean
    Quicken Janean Quicken Windows Subscription Moderator admin

    Hi All, If you could upload your logs and a screenshot of your register, that would be helpful in researching this issue. Thanks!

    Quicken Janean

    Make sure to sign up for the email digest to see a round up of your top posts.

  • AWinTx
    AWinTx Member ✭✭✭

    Can people who restored from backup and entered the split manually confirm that the "Growth of 10k" report is correct? All my transactions look correct (cost is now 1/10 of what it was) but this is the only issue I see. I would hate to go back and restore from a June 5 backup and re-categorize transactions if this is an issue for those who caught it early. No need to share images but if you stated above that you fixed it, I would just like to validate this as I use this report a lot. TIA.

This discussion has been closed.