SumWorth · portfolio research

Portfolio data-quality worksheet

Use this blank worksheet while reviewing a provider export, historical chart, or backtest. Record what was observed before separating it from calculated summaries and modeled overlays.

Observed metadata

What the source supplied

Describe the source, dates, coverage, and missing observations without filling gaps or treating retrieval time as market freshness.

Provider or feed

As-of date (latest provider observation)

Retrieval timestamp

Evidence status (complete / partial / insufficient / stale / unavailable / unknown)

Requested coverage (start, end, timezone, date inclusivity)

Common coverage actually supported (start, end, observation count)

Price basis (close, adjusted close, total return, other)

Currency and conversion caveat

Venue, timezone, and market calendar

Missing data, exclusions, or interrupted dates

Calculated summaries

What the rules produced

Label each number as a calculation over the observed data. Keep the method and units next to the result.

Summary, metric, or chart result (include units)

Portfolio definition, weights, and rebalance rule

Fees, expenses, inflation, cash, contributions, withdrawals, or taxes

Benchmark identity and methodology

Missing-data handling in the calculation

Modeled overlays

Assumptions, not observations

Record any scenario, shock, forecast, or sensitivity overlay separately from the provider evidence and calculated summary.

Overlay or scenario name

Comparison baseline

Modeled inputs, shocks, or assumptions

What this overlay can and cannot show

Bounded conclusion

What the evidence supports

Supported conclusion for this window and these inputs

Limitations, uncertainty, and evidence gaps

Conclusion boundary: what this does not establish

Evidence boundary

This worksheet records historical or modeled evidence. It does not predict future performance, establish suitability, provide personal financial advice, or guarantee an outcome.