In Investing Tab, what is formula for Gain/Loss figure in Portfolio?
Best Answer
-
The "Gain/Loss" column in the Investing "Portfolio" view is the difference between the "Market Value" column and the "Cost Basis" column - so the formula for it is:
Market Value - Cost Basis = Gain/Loss
It would not take into consideration any cash dividends but would take into consideration any reinvested dividends to the degree those have affected your "Cost Basis" in the security.
Let me know if you have any followups.
FrankxQuicken Home, Business & Rental Property - Windows 10-Home Version
- - - - Quicken User since 1984 - - -
- If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you. -6
Answers
-
The "Gain/Loss" column in the Investing "Portfolio" view is the difference between the "Market Value" column and the "Cost Basis" column - so the formula for it is:
Market Value - Cost Basis = Gain/Loss
It would not take into consideration any cash dividends but would take into consideration any reinvested dividends to the degree those have affected your "Cost Basis" in the security.
Let me know if you have any followups.
FrankxQuicken Home, Business & Rental Property - Windows 10-Home Version
- - - - Quicken User since 1984 - - -
- If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you. -6 -
Is there a Quicken parameter that would include cash dividends over time in the calculated overall gain from stocks and mutual funds?0
-
Is there a Quicken parameter that would include cash dividends over time in the overall gain from stocks and mutual funds?0
-
vitreous said:Is there a Quicken parameter that would include cash dividends over time in the calculated overall gain from stocks and mutual funds?QWin Premier subscription0
-
The Average Annual Return figures (portfolio view or Investing Performance Report) do include effects of dividends (and similar income), and are presented as a percent return, whereas Gain/Loss is a dollar amount figure.
Return (in various forms via portfolio views) is also a dollar figure and will include dividends and similar income. It will also include the Realized gain/loss from sales of shares of a security. So it is not the "return" on the current shares held, but rather the return on the shares owned at some time during the relevant period.
IMO, Average Annual Return is the best universal measure of investment performance that Quicken offers.0 -
If you haven't already, you may want to review the built-in documentation on the topic: press F1
-1 -
Do you know why "Return % 5 Year" has values only for Mutual Funds in Portfolio view? Value are there for common stocks.
Thank you.0 -
My understanding is that Quicken downloads that data from third party financial information provider and that those figures are static - i.e. they are not calculated based on (or related in any way to) your investment transactions.
FrankxQuicken Home, Business & Rental Property - Windows 10-Home Version
- - - - Quicken User since 1984 - - -
- If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you. -2