{"ok":true,"status":"EXPORT_READY","readonly":true,"export_kind":"portfolio_center_system_health_json_export","health_export_id":"SYSTEM-HEALTH-370FE2DF79E44C29","suggested_filename":"tsc_portfolio_center_v655_system_health_20260914.json","system_health_summary":{"ok":true,"status":"OK","readonly":true,"version":"TSC Portfolio Center V6.5.5 System Health Export","system_health_version":"V6.5.5","checkpoint":"TSC Portfolio Center V6.5.5 System Health Export stabil","source_checkpoint":"TSC Portfolio Center V6.5.4a Restore Checklist Fast Summary Fix stabil","portfolio_runtime_version":"TSC Portfolio Center V6.8.6 Stable Lock","portfolio_runtime_checkpoint":"TSC Portfolio Center V6.8.6 Stable Lock stabil","checked_at_utc":"2026-09-14T17:44:01+00:00","system_health":{"score":80,"label":"OK","blockers":[],"warnings":["Quality Summary meldet nicht ok.","Quality Score ist kleiner als 100."]},"counts":{"portfolio_transactions":274,"portfolio_cash":9,"portfolio_positions":2999,"portfolio_price_cache":2510,"portfolio_overview_snapshots":155,"portfolio_import_batches":3,"portfolio_import_rows":7,"portfolio_transaction_drafts":146,"portfolio_settings":547},"quality_summary":{"ok":false,"status":"REVIEW","quality_score":43,"quality_label":"ERROR","error_count":3,"warning_count":0,"info_count":3},"latest_snapshot":{"snapshot_date":"2026-09-14","snapshot_status":"CREATED","snapshot_version":"V6.12.4","snapshot_source":"portfolio_positions_market_value_securities_only_v6124","cash_total_eur":0.0,"position_cost_basis_eur":12748.9892,"position_market_value_eur":12679.9479,"portfolio_total_value_eur":12679.9479,"unrealized_pl_eur":-69.0414,"unrealized_pl_pct":-0.541544,"position_count":20,"missing_price_count":0,"safety_ack":"CREATE_PORTFOLIO_SNAPSHOT","snapshot_note":"V6.12.4b route override: securities-only snapshot from portfolio_positions market value truth","created_at":"2026-09-14T16:16:14.068187+02:00"},"latest_price":{"asset_key":"ALIBABA","price_date":"2026-09-14","price_eur":93.7511,"price":108.17,"currency":"USD","source":"auto_price_update_v6108b","price_source":"auto-yahoo-dynamic-v6108b","is_active":true,"is_latest":true,"is_deleted":false,"notes":"TSC Portfolio Center V6.10.8b dynamic automatic price update","created_at":"2026-09-14T16:16:12.706284+02:00","updated_at":"2026-09-14T16:16:12.706284+02:00"},"latest_position":{"asset_key":"ALIBABA","broker_key":"ALL","quantity":2.0,"cost_basis_eur":289.2,"market_price_eur":93.7511,"market_value_eur":187.5022,"unrealized_pl_eur":-101.6978,"valuation_status":"VALUED","valuation_version":"V6.11.8","valuation_price_key":null,"valuation_price_date":"2026-09-14","valuation_price_source":"auto-yahoo-dynamic-v6108b","updated_at":"2026-09-14T16:16:13.775379+02:00"},"settings_status":{"ok":true,"status":"OK","settings":{"portfolio_center_checkpoint":"TSC Portfolio Center V6.8.2 Dashboard Navigation Completeness stabil","portfolio_center_version":"TSC Portfolio Center V6.8.2 Dashboard Navigation Completeness","portfolio_system_health_export_mode":"readonly_fast_system_health_export","portfolio_system_health_export_trading_hub_changes":"false","portfolio_system_health_export_write_enabled":"false"}},"db_health":{"ok":true,"status":"OK","readonly":true,"driver":"psycopg","counts":{"portfolio_transactions":274,"portfolio_cash":9,"portfolio_positions":2999,"portfolio_price_cache":2510,"portfolio_overview_snapshots":155,"portfolio_import_batches":3,"portfolio_import_rows":7,"portfolio_transaction_drafts":146,"portfolio_settings":547},"latest_snapshot":{"snapshot_date":"2026-09-14","snapshot_status":"CREATED","snapshot_version":"V6.12.4","snapshot_source":"portfolio_positions_market_value_securities_only_v6124","cash_total_eur":0.0,"position_cost_basis_eur":12748.9892,"position_market_value_eur":12679.9479,"portfolio_total_value_eur":12679.9479,"unrealized_pl_eur":-69.0414,"unrealized_pl_pct":-0.541544,"position_count":20,"missing_price_count":0,"safety_ack":"CREATE_PORTFOLIO_SNAPSHOT","snapshot_note":"V6.12.4b route override: securities-only snapshot from portfolio_positions market value truth","created_at":"2026-09-14T16:16:14.068187+02:00"},"latest_price":{"asset_key":"ALIBABA","price_date":"2026-09-14","price_eur":93.7511,"price":108.17,"currency":"USD","source":"auto_price_update_v6108b","price_source":"auto-yahoo-dynamic-v6108b","is_active":true,"is_latest":true,"is_deleted":false,"notes":"TSC Portfolio Center V6.10.8b dynamic automatic price update","created_at":"2026-09-14T16:16:12.706284+02:00","updated_at":"2026-09-14T16:16:12.706284+02:00"},"latest_position":{"asset_key":"ALIBABA","broker_key":"ALL","quantity":2.0,"cost_basis_eur":289.2,"market_price_eur":93.7511,"market_value_eur":187.5022,"unrealized_pl_eur":-101.6978,"valuation_status":"VALUED","valuation_version":"V6.11.8","valuation_price_key":null,"valuation_price_date":"2026-09-14","valuation_price_source":"auto-yahoo-dynamic-v6108b","updated_at":"2026-09-14T16:16:13.775379+02:00"},"settings_status":{"ok":true,"status":"OK","settings":{"portfolio_center_checkpoint":"TSC Portfolio Center V6.8.2 Dashboard Navigation Completeness stabil","portfolio_center_version":"TSC Portfolio Center V6.8.2 Dashboard Navigation Completeness","portfolio_system_health_export_mode":"readonly_fast_system_health_export","portfolio_system_health_export_trading_hub_changes":"false","portfolio_system_health_export_write_enabled":"false"}},"duration_ms":62.95},"quality_report":{"ok":false,"status":"REVIEW","readonly":true,"driver":"psycopg","version":"TSC Portfolio Center V6.4.2 Portfolio Data Quality Checks","data_quality_version":"V6.4.2","quality_score":43,"quality_label":"ERROR","severity_counts":{"ERROR":3,"WARNING":0,"INFO":3,"OK":0},"category_counts":{"imports":3,"cash":1,"positions":1,"prices":1},"issue_count":6,"issues":[{"severity":"ERROR","category":"imports","code":"XTB_RAW_BUY_MAPPED_AS_SELL","title":"XTB Kauf als SELL erkannt: UPS","message":"Ein XTB-Import enthält raw 'Kauf', wurde aber als SELL verarbeitet.","action_href":"/portfolio/audit/imports","details":{"draft_key":"DRAFT-ab9443b9072542128ff8390790da0611","asset_key":"UPS","transaction_type":"SELL","cash_effect_eur":229.56,"source_import_key":""}},{"severity":"ERROR","category":"imports","code":"XTB_RAW_BUY_MAPPED_AS_SELL","title":"XTB Kauf als SELL erkannt: SLB","message":"Ein XTB-Import enthält raw 'Kauf', wurde aber als SELL verarbeitet.","action_href":"/portfolio/audit/imports","details":{"draft_key":"DRAFT-f077833b6c4d4c8cbac5cf292a7b431c","asset_key":"SLB","transaction_type":"SELL","cash_effect_eur":334.14,"source_import_key":""}},{"severity":"ERROR","category":"imports","code":"XTB_RAW_BUY_MAPPED_AS_SELL","title":"XTB Kauf als SELL erkannt: MERCEDES_BENZ","message":"Ein XTB-Import enthält raw 'Kauf', wurde aber als SELL verarbeitet.","action_href":"/portfolio/audit/imports","details":{"draft_key":"DRAFT-707cff53db794f34b560d0ac774069d6","asset_key":"MERCEDES_BENZ","transaction_type":"SELL","cash_effect_eur":54.55,"source_import_key":""}},{"severity":"INFO","category":"cash","code":"NO_ACTIVE_CASH_ROWS","title":"Keine aktiven Cash-Zeilen gefunden","message":"Die aktive Cash-Tabelle ist leer oder wurde noch nicht aufgebaut.","action_href":"/portfolio/rebuild","details":{}},{"severity":"INFO","category":"positions","code":"NO_ACTIVE_POSITIONS","title":"Keine aktiven Positionen gefunden","message":"Die aktive Positionstabelle ist leer oder wurde noch nicht aufgebaut.","action_href":"/portfolio/rebuild","details":{}},{"severity":"INFO","category":"prices","code":"STALE_PRICE_CACHE_ROWS","title":"Veraltete Kurse","message":"994 Kurszeile(n) sind älter als 7 Tage.","action_href":"/portfolio/prices","details":{"stale_rows":994,"threshold_days":7,"sample":[{"asset_key":"ALIBABA","age_days":75.17,"price_eur":84.0235,"timestamp":"2026-07-01T15:38:45.039000+02:00"},{"asset_key":"ALTRIA","age_days":75.17,"price_eur":62.987,"timestamp":"2026-07-01T15:38:45.039000+02:00"},{"asset_key":"ALPHABET_A","age_days":77.35,"price_eur":300.0,"timestamp":"2026-06-29T11:16:34.323533+02:00"},{"asset_key":"ALTRIA","age_days":75.17,"price_eur":62.9759,"timestamp":"2026-07-01T15:38:45.039000+02:00"},{"asset_key":"ALTRIA","age_days":75.17,"price_eur":62.9759,"timestamp":"2026-07-01T15:38:45.039000+02:00"},{"asset_key":"ALIBABA","age_days":75.17,"price_eur":84.997661955,"timestamp":"2026-07-01T15:44:12.269664+02:00"},{"asset_key":"ALTRIA","age_days":74.03,"price_eur":63.0898,"timestamp":"2026-07-02T18:57:12.218075+02:00"},{"asset_key":"ALTRIA","age_days":75.17,"price_eur":63.1034499041,"timestamp":"2026-07-01T15:44:12.269664+02:00"},{"asset_key":"ALPHABET_A","age_days":71.86,"price_eur":300.0,"timestamp":"2026-07-04T23:06:42.930193+02:00"},{"asset_key":"AMAZON","age_days":75.17,"price_eur":209.9936783702,"timestamp":"2026-07-01T15:44:12.269664+02:00"}]}}],"thresholds":{"draft_age_days":7,"price_age_days":7,"import_age_days":7,"snapshot_age_days":3},"status_payload":{"ok":true,"status":"OK","readonly":true,"driver":"psycopg","counts":{"portfolio_transactions":274,"portfolio_cash":9,"portfolio_positions":2999,"portfolio_price_cache":2510,"portfolio_overview_snapshots":155,"portfolio_import_batches":3,"portfolio_import_rows":7,"portfolio_transaction_drafts":146,"portfolio_targets":26},"latest":{"portfolio_transactions":"2026-09-09T23:28:05.963682+02:00","portfolio_cash":"2026-08-17T23:25:24.698643+02:00","portfolio_positions":"2026-09-14T16:16:13.775379+02:00","portfolio_price_cache":"2026-09-14T16:16:12.706284+02:00","portfolio_overview_snapshots":"2026-09-14T16:16:14.068187+02:00","portfolio_import_batches":"2026-06-29T00:38:41.818300+02:00","portfolio_transaction_drafts":"2026-09-10T01:28:05.939309+02:00"},"duration_ms":66.01},"write_enabled":false,"writes_executed":false,"trading_hub_changed":false,"duration_ms":400.13,"fast_quality_duration_ms":400.31},"important_urls":{"dashboard":"/portfolio","system_health":"/portfolio/system-health","health_export":"/portfolio/health-export","manual":"/portfolio/manual","restore_checklist":"/portfolio/restore-checklist","backup_export":"/portfolio/backup-export","baseline":"/portfolio/baseline","final_sync":"/portfolio/final-sync","quality":"/portfolio/quality","price_repair":"/portfolio/price-repair","market_value_rebuild":"/portfolio/market-value-rebuild","snapshot_chain":"/portfolio/snapshot-after-rebuild","checkpoint_api":"/portfolio/api/checkpoint"},"expected_api_paths":[{"name":"Health","path":"/health","kind":"global"},{"name":"Portfolio Checkpoint","path":"/portfolio/api/checkpoint","kind":"portfolio"},{"name":"Default Dashboard Status","path":"/portfolio/api/default-dashboard/status","kind":"portfolio"},{"name":"Quality Status","path":"/portfolio/api/quality/status","kind":"portfolio"},{"name":"Baseline Status","path":"/portfolio/api/baseline/status","kind":"portfolio"},{"name":"Final Sync Status","path":"/portfolio/api/final-sync/status","kind":"portfolio"},{"name":"Manual Status","path":"/portfolio/api/manual/status","kind":"portfolio"},{"name":"Backup Export Status","path":"/portfolio/api/backup-export/status","kind":"portfolio"},{"name":"Restore Checklist Status","path":"/portfolio/api/restore-checklist/status","kind":"portfolio"},{"name":"System Health Status","path":"/portfolio/api/system-health/status","kind":"portfolio"}],"write_enabled":false,"writes_executed":false,"restore_execution_enabled":false,"trading_hub_changed":false,"guardrails":{"system_health_export_is_readonly":true,"runtime_db_write_enabled":false,"writes_executed":false,"restore_execution_enabled":false,"rebuild_execution_enabled":false,"snapshot_execution_enabled":false,"price_repair_execution_enabled":false,"trading_hub_changed":false,"does_not_write_to":["portfolio_transactions","portfolio_cash","portfolio_positions","portfolio_price_cache","portfolio_overview_snapshots","portfolio_import_batches","portfolio_transaction_drafts","Trading-Hub-Tabellen"]},"duration_ms":463.41},"manifest":{"ok":true,"version":"TSC Portfolio Center V6.5.5 System Health Export","system_health_version":"V6.5.5","checkpoint":"TSC Portfolio Center V6.5.5 System Health Export stabil","source_checkpoint":"TSC Portfolio Center V6.5.4a Restore Checklist Fast Summary Fix stabil","created_at_utc":"2026-09-14T17:44:01+00:00","export_contains":["runtime version/checkpoint","database counts","latest snapshot","latest price","latest position","quality summary","health score","important urls","expected api paths","guardrails"],"important_urls":{"dashboard":"/portfolio","system_health":"/portfolio/system-health","health_export":"/portfolio/health-export","manual":"/portfolio/manual","restore_checklist":"/portfolio/restore-checklist","backup_export":"/portfolio/backup-export","baseline":"/portfolio/baseline","final_sync":"/portfolio/final-sync","quality":"/portfolio/quality","price_repair":"/portfolio/price-repair","market_value_rebuild":"/portfolio/market-value-rebuild","snapshot_chain":"/portfolio/snapshot-after-rebuild","checkpoint_api":"/portfolio/api/checkpoint"},"expected_api_paths":[{"name":"Health","path":"/health","kind":"global"},{"name":"Portfolio Checkpoint","path":"/portfolio/api/checkpoint","kind":"portfolio"},{"name":"Default Dashboard Status","path":"/portfolio/api/default-dashboard/status","kind":"portfolio"},{"name":"Quality Status","path":"/portfolio/api/quality/status","kind":"portfolio"},{"name":"Baseline Status","path":"/portfolio/api/baseline/status","kind":"portfolio"},{"name":"Final Sync Status","path":"/portfolio/api/final-sync/status","kind":"portfolio"},{"name":"Manual Status","path":"/portfolio/api/manual/status","kind":"portfolio"},{"name":"Backup Export Status","path":"/portfolio/api/backup-export/status","kind":"portfolio"},{"name":"Restore Checklist Status","path":"/portfolio/api/restore-checklist/status","kind":"portfolio"},{"name":"System Health Status","path":"/portfolio/api/system-health/status","kind":"portfolio"}],"recommended_host_export_command":"mkdir -p exports/portfolio && curl -sS http://localhost:8000/portfolio/api/system-health/export > exports/portfolio/tsc_portfolio_center_v655_system_health_$(date +%Y%m%d_%H%M%S).json","guardrails":{"system_health_export_is_readonly":true,"runtime_db_write_enabled":false,"writes_executed":false,"restore_execution_enabled":false,"rebuild_execution_enabled":false,"snapshot_execution_enabled":false,"price_repair_execution_enabled":false,"trading_hub_changed":false,"does_not_write_to":["portfolio_transactions","portfolio_cash","portfolio_positions","portfolio_price_cache","portfolio_overview_snapshots","portfolio_import_batches","portfolio_transaction_drafts","Trading-Hub-Tabellen"]}},"write_enabled":false,"writes_executed":false,"restore_execution_enabled":false,"trading_hub_changed":false,"created_at_utc":"2026-09-14T17:44:01+00:00","checked_at_utc":"2026-09-14T17:44:01+00:00"}