Report - Investment Account Summary with Periodical (to date) P&L

Blue255 Member
edited June 2021 in Investments (Windows)
I am looking for a very Simple Investment (Account level summary) report that lists ONE row each for Investment account and have PERIODICAL (Daily, Week to Date, Month to Date etc.) Gains in Amount & Percentage.

PS: 'Portfolio' has something close; however, customized 'available' columns don't have Week/Quarter/Month to date columns (they have Monthly etc. - but doesn't serve the purpose).

Account Name
Current Market Value
Unrealized Gain
Daily p&L Amount (say in $)
Daily P&L %
Week to date p&L Amount
Week to date P&L %
Quarter to date p&L Amount
Quarter to date P&L %
Month to date p&L Amount
Month to date P&L %
Year to date p&L Amount
Year to date P&L %

Unless, I missed out something, currently these fields don't seem to be available. Difficult to believe that such simple report is not available given that Quicken collects all the data points to generate this report.

Any insights appreciated. Thanks.
0 votes

New · Last Updated


  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Please define as precisely as possible what you mean by P&L (profit and loss?).  P&L could mean gain/loss or it could mean something very different.

    Quicken does not provide any data anywhere in the program for "Week to date" which would require a separate definition of the starting day for the week (Sunday or Monday?).
  • Blue255
    Blue255 Member
    As an investor / trader (accountant would have way more elaborate definition!) I think of P&L of an Investment account for Given Period as End Market Value (MV) - Begin MV - Net Cash flow (Deposits / Withdrawals). For Week to Date - I do see "Week to Date" as option in Date Range dropdown in Investment Activity report. Whatever date is considered there - should be fine. (As a quick add - googling about it shows ISO 8601 standard marks Monday as 1st day and Sunday as 7th).
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Apologies on the "Week to Date".  I now see it as a common range.  Had not noticed it before. (Still don't know , haven't confirmed, the timing -- a later task.)

    Thanks for the clarification.  I'll flag this for a moderator to move to the IDEAS section. 
  • Blue255
    Blue255 Member
    Thanks; will be looking forward to see the report soon in Quicken!
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Blue255 said:
    Thanks; will be looking forward to see the report soon in Quicken!
    Don't hold your breath on that.  "Soon" and "Quicken Changes" rarely come together.   
  • Quicken Anja
    Quicken Anja Moderator mod
    Hello @Blue255,

    Thank you for taking the time to reach out to the Community with your request.

    I went ahead and changed your post to an Idea so other users who have the same or a similar request can vote on your idea by clicking the up arrow (see below).

    Ideas are also reviewed by our Development and Product teams in order to improve Quicken and implement new features requested by customers.

    Please, be sure to add your own vote as well.

    -Quicken Anja