Day Gain/Loss in investment account showing huge loss with no transactions for period

Robhawaii
Robhawaii Quicken Mac Subscription Member ✭✭

My portfolio graph showed a huge spike in value on 6/30/23 then dropped back to the actual balance the next day. By using the drop down menu I narrowed the problem to my IRA account, by only checking this account in the dropdown list. There were two Reinvest Dividend transactions on 6/30/23 for $171.03 and $3.14. I deleted the transactions and entered them manually. However, the graph and day gain/loss, for this account, did not change.

I also reviewed the entire portfolio values and looked for any missing cost basis entries, which there were none. The Market Value in the window and registers is all correct. What else should I look for that is causing the Day Gail/Loss and graph to spike, with no matching transactions.

Tagged:

Best Answer

  • Robhawaii
    Robhawaii Quicken Mac Subscription Member ✭✭
    Answer ✓

    Yes, that worked to find the problem. With an As Of Date of 6/30/23 there are 3 transactions for a security that are inflated. I made 3 purchases in June, July, and August 2021 for $12,000. The Market Value as of 6/30/23 for each transaction is over $1MM each. I switched to the Dashboard and clicked on the security to check the Price History. There was one entry on 6/30/23 that was incorrect that I just deleted. I download from Vanguard 2-3 times a week. I did not enter this price entry manually.

Answers

  • Robhawaii
    Robhawaii Quicken Mac Subscription Member ✭✭
    Answer ✓

    Yes, that worked to find the problem. With an As Of Date of 6/30/23 there are 3 transactions for a security that are inflated. I made 3 purchases in June, July, and August 2021 for $12,000. The Market Value as of 6/30/23 for each transaction is over $1MM each. I switched to the Dashboard and clicked on the security to check the Price History. There was one entry on 6/30/23 that was incorrect that I just deleted. I download from Vanguard 2-3 times a week. I did not enter this price entry manually.

This discussion has been closed.