Absolute Performance % average (and column totals)

[RoChess]

View: Security Accounts -> select an account -> Add/View "Abs. Perf. % 3 years" column.

Each individual asset is calculated on the %, but unlike all the other columns I'm using, the "Abs. Perf. % 3 years" lacks a total/average value in the "Equity Fund" header-row and "Total" footer-row.

Summing up each asset respective % value and dividing it by the number of asset rows, as in averaging the value, would match what Fidelity.com provides me on their summary page.

PS: It works as expected for "Abs. Perf. 3 years" dollar amount total, but those are all SUM() based, and % columns would need to be AVERAGE() if I were to do this in Excel.

[inv-trad]

I guess, you are talking about the view Reports -> Statement of Assets. Correct?

Averaging the Abs. Perf. % by just summing up and dividing by the number of entries, might lead to misleading results and I guess that is, why there is no average implemented.

Example: Total investment 110.000 € Security A (large investment of 100.000€): Abs. perf. 10.000 € with Abs. Perf. % 10% Security B (small investement of 10.000€): Abs. perf. 5000€ with Abs. Perf. % 50% Total: Abs. perf. 15.000€ with Abs. Perf. % average: 30%, while the weighted Abs. Perf. % would be 13.6%

I think, an average here would only confuse and don't add much value unless it is the weighted average. What do you think?

[RoChess]

Yup, that does not make it easy.

It is indeed under "Reports" -> "Statement of Assets", but also under "Accounts" -> "Securities Accounts" which lists a statement of assets summary at the bottom table as well. Just find it easier to quickly swap between accounts there than to add a filter inside the reports.

Digging deeper, Fidelity lists each stock on absolute % performance as = "$ Total Gain/Loss" / "Cost Basis" * 100%

And then the footer total is indeed weighted via "Cost Basis" / "Cost Basis Total" on each individual entry added together.

Due to the limited amount of mutual funds in my account the math must have been striking similar to AVERAGE(), but you are right, it needs to be weighted to make sense.

[flywire]

@RoChess can you edit title to include column totals again?

https://forum.portfolio-performance.info/t/reporting-across-multiple-security-accounts/17381/6

Q2. Can column totals be displayed?

[RoChess]

Done. Appreciate the effort; it always takes me a lot of time to enter the data from some sources that don't offer easy way to export, but the results in Portfolio Performance are worth it.