How does quicken Calculate the "Day Gain/Loss" Column shown in the "Portfolio View"
I would greatly appreciate any assistance regarding; How Quicken calculates the "Day Gain/Loss" column that is shown in the "Portfolio View".
Upon doing some research, the data that Quicken is providing does not appear to be accurate, and when using "basic math", the data being provided by Quicken does not appear to add up correctly.
I have attached a spreadsheet that includes the data points in question. The data in this spreadsheet was exported from the Quicken Portfolio View. I believe it includes all of the pertinent data. The spreadsheet also includes all of the questions I am seeking help with, as well as specific examples of what appears to me as examples of how simple math should compute what I believe to be correct data.
Thanks in advance for your assistance.
Regards,
Steve…
Comments
-
The difference is pennies, correct?
It is probably a difference in rounding. The Day Gain/Loss appears to be calculated as (Today's share count) * ((Today's share price) - (Yesterday's share price))
It does not take into account any distributions or change in share count. See this discussion
QWin Premier subscription0