mirror of
https://github.com/farcasclaudiu/xtb-investment-tools.git
synced 2026-06-29 15:02:06 +03:00
37 lines
1.6 KiB
Markdown
37 lines
1.6 KiB
Markdown
# Portfolio Review Validation Checklist
|
|
|
|
Load this before saying an XTB portfolio review is ready.
|
|
|
|
## Commands
|
|
|
|
- Install dependencies:
|
|
`<skill-folder>/scripts/setup-env.sh`
|
|
- Validate bundled tools:
|
|
`<skill-folder>/scripts/validate-review.sh`
|
|
- Generate report and CSVs:
|
|
`<skill-folder>/scripts/run-review.sh <report.xlsx>`
|
|
- If working inside the original project repository, full tests are also useful:
|
|
`.venv/bin/python -m pytest -q`
|
|
|
|
## Required Checks
|
|
|
|
- The command exits successfully and writes `results/<stem>_review.html`.
|
|
- CSV side outputs exist when `--csv` was used.
|
|
- Cash reconciliation is `[OK]` or the mismatch is explicitly reported.
|
|
- Holdings with live-price failures are visible as cost fallbacks.
|
|
- The HTML remains self-contained/offline: no CDN script or stylesheet dependency.
|
|
- The report includes methodology/data-quality notes for pricing and reconciliation.
|
|
|
|
## Useful Output Files
|
|
|
|
- `_holdings.csv`: shares, cost basis, market value, allocation, unrealized P/L, price source.
|
|
- `_cash_flows.csv`: deposits, withdrawals, invested, proceeds, dividends, tax, fees, ending cash.
|
|
- `_realized_pl.csv`: realized profit/loss by ticker.
|
|
- `_performance.csv`: portfolio value, total gain, return metrics, income yield.
|
|
- `_income.csv`: dividend and interest income over time.
|
|
- `_evolution.csv`: daily cost/value/realized series for charts.
|
|
|
|
## Reporting Style
|
|
|
|
Summarize computed facts and data-quality status. Avoid recommendations to buy, sell, rebalance, or time markets unless the user explicitly asks for financial planning context, and still frame it as educational analysis rather than advice.
|