{"ok":true,"status":"READY","readonly":true,"version":"TSC Portfolio Center V6.8.4 Cash Truth Diagnostics","cash_diag_version":"V6.8.4","checkpoint":"TSC Portfolio Center V6.8.4 Cash Truth Diagnostics stabil","source_checkpoint":"TSC Portfolio Center V6.8.3a Main Route Registration Fix stabil","lts_reference":"TSC Portfolio Center V6.6.1 Long Term Stable Lock stabil","checked_at_utc":"2026-07-16T19:42:57+00:00","driver":"psycopg","diagnostics_readiness":{"status":"READY","blockers":[],"warnings":[]},"dashboard_metrics":{"portfolio_total_value_eur":11687.1149,"portfolio_total_source":"active_positions_plus_securities_only_cash","portfolio_net_value_eur":11687.1149,"snapshot_total_value_eur":11687.1149,"position_market_value_eur":11687.1149,"cost_basis_eur":11466.7785,"cash_total_eur":0.0,"unrealized_pl_eur":220.3364,"unrealized_pl_pct":1.9215,"position_count":20,"cash_display_mode":"SECURITIES_ONLY","metrics_truth_guard":"V6.13.0-R4"},"explanation":{"severity":"OK","dashboard_cash_eur":0.0,"snapshot_cash_eur":0.0,"cash_ledger_sum_eur":0.0,"estimated_transaction_cash_effect_eur":18506.59,"position_market_value_eur":11687.11,"dashboard_total_eur":11687.11,"dashboard_net_total_eur":11687.11,"findings":["Dashboard nutzt Brutto-Positionswert als Headline-Fallback.","Cash-Ledger-Summe entspricht dem Dashboard-Cash."],"suspects":[],"next_checks":["Cash-Zeilen einzeln prüfen.","Letzte Snapshot-Zeilen prüfen.","Transaktionstypen und Amount-Spalten prüfen.","Erst nach Diagnose korrigieren."]},"cash_table":{"table":"portfolio_cash","exists":true,"columns":["id","cash_date","broker_id","cash_type","amount","currency","fx_rate_to_eur","amount_eur","related_transaction_id","source","source_reference","notes","is_deleted","deleted_at","created_at","updated_at","cash_key","cash_scope","broker_key","transaction_count","positive_count","negative_count","null_cash_effect_count","cash_in_eur","cash_out_eur","cash_balance_eur","first_transaction_date","last_transaction_date","source_run_key","source_rebuild_run_key","cash_truth_version","cash_truth_source","is_active","raw_summary_json","applied_at","replaced_at"],"row_count":0,"amount_column":"amount_eur","type_column":"cash_type","date_column":"created_at","description_column":"source","ledger_sum_eur":0.0,"by_type":[],"latest_rows":[],"warnings":[]},"snapshot_cash":{"table":"portfolio_overview_snapshots","exists":true,"columns":["id","snapshot_key","snapshot_date","snapshot_status","snapshot_version","snapshot_source","cash_total_eur","position_cost_basis_eur","position_market_value_eur","portfolio_total_value_eur","unrealized_pl_eur","unrealized_pl_pct","cash_row_count","position_count","asset_count","broker_count","valued_position_count","missing_price_count","not_valued_count","error_count","warning_count","overview_status","overview_version","summary_json","counts_json","status_flags_json","warnings_json","asset_summary_json","broker_summary_json","cash_summary_json","overview_json","safety_ack","snapshot_note","created_at"],"row_count":46,"date_column":"created_at","portfolio_value_column":"portfolio_total_value_eur","cash_column":"cash_total_eur","invested_column":null,"latest_snapshot":{"snapshot_at":"2026-07-15T23:15:16.602236+02:00","portfolio_value_eur":11687.11,"cash_total_eur":0.0,"invested_eur":null},"latest_rows":[{"snapshot_at":"2026-07-15T23:15:16.602236+02:00","portfolio_value_eur":11687.11,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-14T23:15:13.130117+02:00","portfolio_value_eur":11675.45,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-13T23:15:13.798118+02:00","portfolio_value_eur":11653.7,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-11T23:19:12.743659+02:00","portfolio_value_eur":11585.08,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-11T11:52:13.588875+02:00","portfolio_value_eur":11585.08,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-10T23:15:13.010691+02:00","portfolio_value_eur":11188.12,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-10T22:30:13.070495+02:00","portfolio_value_eur":11189.4,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-10T11:01:13.153652+02:00","portfolio_value_eur":10973.37,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-09T23:15:13.331637+02:00","portfolio_value_eur":10999.17,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-08T23:15:12.763242+02:00","portfolio_value_eur":10731.43,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-08T22:41:13.558701+02:00","portfolio_value_eur":10735.05,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-07T23:15:12.230354+02:00","portfolio_value_eur":10815.55,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-06T23:15:12.306207+02:00","portfolio_value_eur":11020.12,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-06T21:58:12.905832+02:00","portfolio_value_eur":11021.77,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-05T23:09:12.681758+02:00","portfolio_value_eur":10895.3,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-05T20:21:13.320991+02:00","portfolio_value_eur":11073.74,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-03T23:15:12.470298+02:00","portfolio_value_eur":11073.74,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-03T20:42:13.382739+02:00","portfolio_value_eur":11071.9,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-03T11:44:13.739161+02:00","portfolio_value_eur":11064.27,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-07-03T00:03:20.495389+02:00","portfolio_value_eur":11061.38,"cash_total_eur":0.0,"invested_eur":null}],"warnings":[]},"transaction_cash_effect":{"table":"portfolio_transactions","exists":true,"columns":["id","transaction_date","transaction_time","transaction_type","broker_id","asset_id","quantity","price","gross_amount","fees","taxes","net_amount","currency","fx_rate_to_eur","amount_eur","source","source_reference","external_id","notes","is_deleted","deleted_at","created_at","updated_at","draft_id","draft_key","commit_gate_version","commit_ack","commit_note","commit_status","committed_at","rollback_note","rolled_back_at","broker_key","asset_key","cash_effect_eur","payload_json","preview_json","deleted_reason"],"row_count":143,"type_column":"transaction_type","asset_column":"asset_key","amount_column":"amount_eur","date_column":"transaction_date","estimated_cash_effect_eur":18506.59,"by_type":[{"transaction_type":"FEE","rows":7,"amount_sum_eur":1.01,"min_amount_eur":0.01,"max_amount_eur":0.42},{"transaction_type":"DIVIDEND","rows":36,"amount_sum_eur":71.55,"min_amount_eur":0.05,"max_amount_eur":7.27},{"transaction_type":"SELL","rows":19,"amount_sum_eur":7871.55,"min_amount_eur":10.41,"max_amount_eur":1303.43},{"transaction_type":"BUY","rows":70,"amount_sum_eur":18275.36,"min_amount_eur":0.1,"max_amount_eur":2681.18},{"transaction_type":"CASH_IN","rows":11,"amount_sum_eur":28839.87,"min_amount_eur":0.01,"max_amount_eur":26760.0}],"latest_rows":[{"row_id":"6a51ae97-02fa-4dec-b64b-1481dc65c669","transaction_date":"2026-07-10","transaction_type":"BUY","asset_key":"IONQ","amount_eur":200.0},{"row_id":"c2d9b6fd-722d-4b5b-b4cc-343b66e148db","transaction_date":"2026-07-10","transaction_type":"BUY","asset_key":"AMAZON","amount_eur":100.01},{"row_id":"1c1ec108-0483-4464-835c-92fdf2bec3e3","transaction_date":"2026-07-10","transaction_type":"BUY","asset_key":"PAAS","amount_eur":200.0},{"row_id":"49e078eb-3f7b-4eb8-8542-c0040e81c547","transaction_date":"2026-07-10","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":250.0},{"row_id":"1287bfda-d594-401f-8b8d-8d5b272cd1d8","transaction_date":"2026-07-02","transaction_type":"SELL","asset_key":"COINBASE","amount_eur":482.32},{"row_id":"cd621cda-36f5-4ad5-aebe-e61e868a766a","transaction_date":"2026-07-01","transaction_type":"BUY","asset_key":"UNDER_ARMOUR","amount_eur":500.0},{"row_id":"c677e682-43d6-4741-a3f8-a3648770dbb6","transaction_date":"2026-06-25","transaction_type":"SELL","asset_key":"UNDER_ARMOUR","amount_eur":511.34},{"row_id":"3ed1f28a-abad-49ae-8471-00975caafb76","transaction_date":"2026-06-19","transaction_type":"BUY","asset_key":"UNDER_ARMOUR","amount_eur":500.0},{"row_id":"1b48cd26-47a1-475a-8daa-dcad976834dd","transaction_date":"2026-06-18","transaction_type":"SELL","asset_key":"NVIDIA","amount_eur":501.04},{"row_id":"06abd3a4-de14-40a4-b9c9-95a992c37722","transaction_date":"2026-06-15","transaction_type":"BUY","asset_key":"META","amount_eur":99.98},{"row_id":"ffbad4c6-89cd-4d05-9a69-9ffbdb4f5cb1","transaction_date":"2026-06-15","transaction_type":"BUY","asset_key":"NVIDIA","amount_eur":500.01},{"row_id":"50cb9f94-aeda-4a5d-8f3e-d7689d9c7195","transaction_date":"2026-06-15","transaction_type":"BUY","asset_key":"D_WAVE_QUANTUM","amount_eur":200.0},{"row_id":"10fa4024-a26f-48f6-b134-4f0dea4f6760","transaction_date":"2026-06-12","transaction_type":"SELL","asset_key":"ALPHABET_A","amount_eur":621.87},{"row_id":"febda882-e19a-402c-9818-09647ea08285","transaction_date":"2026-06-12","transaction_type":"SELL","asset_key":"ALPHABET_C","amount_eur":624.75},{"row_id":"204c6722-cb47-41cb-96a7-f0acb23b532c","transaction_date":"2026-06-10","transaction_type":"BUY","asset_key":"D_WAVE_QUANTUM","amount_eur":50.0},{"row_id":"cd55d645-5300-425d-9b7a-ff4b91647641","transaction_date":"2026-06-05","transaction_type":"BUY","asset_key":"ETF_QDVE_XETRA","amount_eur":100.0},{"row_id":"fdca392d-e7b6-4c8a-9866-6027fb3ed69a","transaction_date":"2026-06-04","transaction_type":"DIVIDEND","asset_key":"UPS","amount_eur":2.39},{"row_id":"037c1f3b-3109-4ea0-8356-a973b3661383","transaction_date":"2026-06-02","transaction_type":"DIVIDEND","asset_key":"PAAS","amount_eur":1.44},{"row_id":"12f79661-fb4a-4bf9-b377-ca1addfd4791","transaction_date":"2026-05-05","transaction_type":"DIVIDEND","asset_key":"FREEPORT_MCMORAN","amount_eur":1.22},{"row_id":"306f2eaf-dd74-4f8a-87f4-64100735a23a","transaction_date":"2026-05-01","transaction_type":"DIVIDEND","asset_key":"ALTRIA","amount_eur":7.24},{"row_id":"10a75fa7-afce-40c5-af07-28587444aa68","transaction_date":"2026-04-21","transaction_type":"BUY","asset_key":"UEC","amount_eur":64.54},{"row_id":"86a047da-795e-4e4f-9b45-278d7eb94af2","transaction_date":"2026-04-17","transaction_type":"DIVIDEND","asset_key":"RIO_TINTO","amount_eur":5.55},{"row_id":"3899696d-8138-424a-a5e8-fb25644d75fa","transaction_date":"2026-04-07","transaction_type":"BUY","asset_key":"PAAS","amount_eur":100.0},{"row_id":"57e28684-632e-4304-be1b-05bb3bf98530","transaction_date":"2026-04-02","transaction_type":"DIVIDEND","asset_key":"SLB","amount_eur":1.27},{"row_id":"0989e97b-94b1-44d6-8772-83d6e5c36c60","transaction_date":"2026-04-02","transaction_type":"DIVIDEND","asset_key":"SLB","amount_eur":0.1},{"row_id":"d29bd805-d172-4223-a4bd-5b76115a4528","transaction_date":"2026-04-02","transaction_type":"DIVIDEND","asset_key":"SLB","amount_eur":0.25},{"row_id":"3623f885-6fde-4215-a3b2-468aa8be2f88","transaction_date":"2026-04-02","transaction_type":"BUY","asset_key":"FREEPORT_MCMORAN","amount_eur":200.0},{"row_id":"b374ce71-0d5c-48a1-ad68-ceb373c337b8","transaction_date":"2026-03-30","transaction_type":"DIVIDEND","asset_key":"META","amount_eur":0.3},{"row_id":"9f3b4a1b-b4ca-4dd5-bf22-b4cce952bc71","transaction_date":"2026-03-25","transaction_type":"DIVIDEND","asset_key":"PAYPAL","amount_eur":0.05},{"row_id":"5c9b4a4c-20b4-4d7a-8b53-f2870524f50e","transaction_date":"2026-03-25","transaction_type":"DIVIDEND","asset_key":"PAYPAL","amount_eur":0.36},{"row_id":"4c425e14-3d2c-4a9d-9118-7a324b0aeb8b","transaction_date":"2026-03-25","transaction_type":"FEE","asset_key":"PAYPAL","amount_eur":0.05},{"row_id":"475381db-977d-45d2-8de6-550465bfff93","transaction_date":"2026-03-25","transaction_type":"FEE","asset_key":"PAYPAL","amount_eur":0.01},{"row_id":"694b69c0-c513-43ed-b805-ffce40bf4d01","transaction_date":"2026-03-25","transaction_type":"DIVIDEND","asset_key":"PAYPAL","amount_eur":0.36},{"row_id":"ed23cb70-3c06-4715-aff9-1f27b355aa6e","transaction_date":"2026-03-25","transaction_type":"FEE","asset_key":"PAYPAL","amount_eur":0.05},{"row_id":"2c2d9f13-4fb2-4e20-80fc-7c75b52de239","transaction_date":"2026-03-19","transaction_type":"BUY","asset_key":"FREEPORT_MCMORAN","amount_eur":143.64},{"row_id":"f1d04a13-1d5b-4930-b19e-267e2316a29a","transaction_date":"2026-03-18","transaction_type":"DIVIDEND","asset_key":"ALPHABET_A","amount_eur":0.31},{"row_id":"e87a8f66-6479-4401-b337-2f19986e55af","transaction_date":"2026-03-18","transaction_type":"DIVIDEND","asset_key":"ALPHABET_C","amount_eur":0.31},{"row_id":"73700ff0-ba11-475e-a417-2254fe12cfc8","transaction_date":"2026-03-16","transaction_type":"DIVIDEND","asset_key":"FREEPORT_MCMORAN","amount_eur":1.21},{"row_id":"159db7bb-724c-40cb-8580-883687fc782a","transaction_date":"2026-03-13","transaction_type":"BUY","asset_key":"UEC","amount_eur":199.5},{"row_id":"cd6d55fa-34bc-4748-a1ad-567b1febacbf","transaction_date":"2026-03-05","transaction_type":"FEE","asset_key":"UPS","amount_eur":0.42},{"row_id":"ad7e5027-f437-4c47-976f-cf4beb3b5eae","transaction_date":"2026-03-05","transaction_type":"DIVIDEND","asset_key":"UPS","amount_eur":2.81},{"row_id":"ad3e4832-9c83-41fe-9235-500239303985","transaction_date":"2026-02-27","transaction_type":"BUY","asset_key":"FREEPORT_MCMORAN","amount_eur":250.0},{"row_id":"d2e76f81-fbab-40ec-a3ef-e04ce2e3cb47","transaction_date":"2026-02-27","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":41.93},{"row_id":"815532f0-ac94-4b1a-a272-e5a9b136dc32","transaction_date":"2026-02-25","transaction_type":"BUY","asset_key":"COINBASE","amount_eur":499.99},{"row_id":"36ecf68e-c2f3-465e-a098-03169916c4f1","transaction_date":"2026-02-24","transaction_type":"SELL","asset_key":"FREEPORT_MCMORAN","amount_eur":541.79},{"row_id":"1dccdda6-1d5f-486f-9152-65ffc6071114","transaction_date":"2026-02-12","transaction_type":"BUY","asset_key":"UEC","amount_eur":500.09},{"row_id":"aa1a234d-11c1-46b9-8756-195b995ea51e","transaction_date":"2026-02-12","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":100.0},{"row_id":"fdad8424-83b8-4258-8b0b-25372d934f7a","transaction_date":"2026-02-10","transaction_type":"BUY","asset_key":"UEC","amount_eur":11.34},{"row_id":"987f6384-7508-433b-af9a-5e93496879cb","transaction_date":"2026-02-10","transaction_type":"BUY","asset_key":"UEC","amount_eur":198.42},{"row_id":"2a3a20cd-033f-4bb0-8f21-322f70368b27","transaction_date":"2026-02-06","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":100.09}],"warnings":[]},"write_enabled":false,"writes_executed":false,"orders_created":false,"transactions_created":false,"cash_corrections_executed":false,"snapshot_corrections_executed":false,"settings_saved":false,"cron_created":false,"systemd_timer_created":false,"restore_execution_enabled":false,"trading_hub_changed":false,"guardrails":{"cash_truth_diagnostics_is_readonly":true,"runtime_db_write_enabled":false,"writes_executed":false,"orders_created":false,"buy_orders_created":false,"sell_orders_created":false,"transactions_created":false,"cash_corrections_executed":false,"snapshot_corrections_executed":false,"settings_saved":false,"cron_created":false,"systemd_timer_created":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","portfolio_settings","crontab","systemd timers","Trading-Hub-Tabellen"]},"duration_ms":158.04,"cash_truth_diagnostics_active":true}