Investment Market Value Change Report

isonclubikin

It would be nice if Quicken provided a simple Investment-type report that shows the end-of-month values, dollar change from the previous end-of-month, and possibly the percentage change from the previous end-of-month for all investment accounts and their individual securities (including cash). I was trying to use the Gain/Loss 1-Month columns in the Portfolio view, but those "months" are from/to specific dates of the months, not ends-of-months (i.e., 01/28/2025 to 02/28/2025 instead of 01/31/2025 to 02/28/2025). Also, they don't do anything with cash balances and if something like a money-market sweep account doesn't have complete pricing data, it gets the gain/loss wrong. Plus, I assume, gains/losses are really not the same as market value changes.

The closest I can get to this kind of report is an Account Balances report of just investment accounts with a custom dates, the interval set to Month, and Account Detail checked under Customize. But, that report includes zero-value securities in one account if they're non-zero in another account and doesn't include the actual changes in values. I have to massage the report in a spreadsheet to correct that.

Jim_Harman

I don't see zero-balance securities that are held elsewhere being included in the Account Balances report.

What I do see is that by default all securities that have ever been held in the account are included, even if they are hidden and even if the balance was zero for the selected period.

I routinely set securities that are no longer held anywhere to Hidden. Then on the Securities tab, un-check the Show Hidden securities box. You may also need to do a Clear all and Select all to see just the active securities.

isonclubikin

Yep. You're second paragraph is what I was trying to describe. I have to manually delete those now-zero security rows when I bring that Account Balances report into a spreadsheet.

I do the same with marking no-longer held securities as Hidden.