{"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-09-14T17:44:06+00:00","driver":"psycopg","diagnostics_readiness":{"status":"READY","blockers":[],"warnings":[]},"dashboard_metrics":{"portfolio_total_value_eur":12679.9479,"portfolio_total_source":"active_positions_plus_securities_only_cash","portfolio_net_value_eur":12679.9479,"snapshot_total_value_eur":12679.9479,"position_market_value_eur":12679.9479,"cost_basis_eur":12748.9892,"cash_total_eur":0.0,"unrealized_pl_eur":-69.0414,"unrealized_pl_pct":-0.5415,"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":29249.73,"position_market_value_eur":12679.95,"dashboard_total_eur":12679.95,"dashboard_net_total_eur":12679.95,"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":9,"amount_column":"amount_eur","type_column":"cash_type","date_column":"created_at","description_column":"source","ledger_sum_eur":0.0,"by_type":[{"cash_type":"UNKNOWN","rows":9,"amount_sum_eur":0.0,"min_amount_eur":0.0,"max_amount_eur":0.0}],"latest_rows":[{"row_id":"cedfaf2c-26d1-4d22-a286-15a8c2127523","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"f5ce2b1a-c26b-4d22-9dac-609fce3eb041","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"269e7be0-9487-4fdf-8219-725229ee7317","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"6956350c-a88d-440d-b7d8-338efb7dba26","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"374c77e6-0180-4368-adc5-c57a1db92d57","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"05d3f9d5-fa70-445b-ad17-2cd98e097ad1","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"232fc7fc-217f-4d45-9d20-96dfc83ef7c0","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"88c96a6a-81b0-4a2e-b0d4-4c3849585930","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null},{"row_id":"c9b5ae3c-c276-4cb2-9fde-e3bd95ef255c","cash_date":"2026-08-17T23:07:37.054080+02:00","cash_type":null,"amount_eur":0.0,"description":null}],"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":155,"date_column":"created_at","portfolio_value_column":"portfolio_total_value_eur","cash_column":"cash_total_eur","invested_column":null,"latest_snapshot":{"snapshot_at":"2026-09-14T16:16:14.068187+02:00","portfolio_value_eur":12679.95,"cash_total_eur":0.0,"invested_eur":null},"latest_rows":[{"snapshot_at":"2026-09-14T16:16:14.068187+02:00","portfolio_value_eur":12679.95,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-12T16:07:14.067670+02:00","portfolio_value_eur":12784.69,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-11T23:15:12.722385+02:00","portfolio_value_eur":12783.97,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-11T15:53:13.914072+02:00","portfolio_value_eur":12857.62,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-10T23:15:13.010759+02:00","portfolio_value_eur":12720.91,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-10T15:55:13.450279+02:00","portfolio_value_eur":12715.93,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-10T01:29:13.065097+02:00","portfolio_value_eur":12902.77,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-09T23:15:13.381253+02:00","portfolio_value_eur":12820.86,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-08T23:15:12.860669+02:00","portfolio_value_eur":12891.0,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-08T10:38:14.434114+02:00","portfolio_value_eur":12807.22,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-08T10:34:13.347344+02:00","portfolio_value_eur":12807.42,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-07T23:15:13.855130+02:00","portfolio_value_eur":12802.29,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-06T16:09:13.422829+02:00","portfolio_value_eur":12793.74,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-04T23:15:13.727397+02:00","portfolio_value_eur":12793.74,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-04T17:00:15.233073+02:00","portfolio_value_eur":12805.38,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-03T23:15:13.580517+02:00","portfolio_value_eur":12897.83,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-02T23:15:13.638504+02:00","portfolio_value_eur":12761.76,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-01T23:15:13.367705+02:00","portfolio_value_eur":12677.52,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-09-01T00:43:15.618347+02:00","portfolio_value_eur":12881.79,"cash_total_eur":0.0,"invested_eur":null},{"snapshot_at":"2026-08-31T23:15:14.090488+02:00","portfolio_value_eur":12881.79,"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":274,"type_column":"transaction_type","asset_column":"asset_key","amount_column":"amount_eur","date_column":"transaction_date","estimated_cash_effect_eur":29249.73,"by_type":[{"transaction_type":"FEE","rows":8,"amount_sum_eur":18.11,"min_amount_eur":0.01,"max_amount_eur":17.1},{"transaction_type":"DIVIDEND","rows":46,"amount_sum_eur":88.06,"min_amount_eur":0.05,"max_amount_eur":7.27},{"transaction_type":"SELL","rows":29,"amount_sum_eur":10200.99,"min_amount_eur":10.41,"max_amount_eur":1303.43},{"transaction_type":"BUY","rows":113,"amount_sum_eur":21636.86,"min_amount_eur":0.01,"max_amount_eur":2681.18},{"transaction_type":"CASH_IN","rows":78,"amount_sum_eur":40615.66,"min_amount_eur":0.01,"max_amount_eur":26760.0}],"latest_rows":[{"row_id":"0ad8dba4-56d2-4c88-8b3f-27e10a2c63d7","transaction_date":"2026-09-08","transaction_type":"CASH_IN","asset_key":null,"amount_eur":200.0},{"row_id":"a8fdb520-6e1c-4a3d-aa99-8ea64e115994","transaction_date":"2026-09-07","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":100.9},{"row_id":"3831e873-ff7e-4632-bb97-d406efdc723c","transaction_date":"2026-09-04","transaction_type":"DIVIDEND","asset_key":"PAAS","amount_eur":2.08},{"row_id":"1d5aee8d-37f6-4add-9d09-7db4f34e4b4c","transaction_date":"2026-08-19","transaction_type":"BUY","asset_key":"CROWDSTRIKE","amount_eur":244.96},{"row_id":"abcfc03a-f5dd-4076-9462-8fd5abaa7c34","transaction_date":"2026-08-19","transaction_type":"BUY","asset_key":"TESLA","amount_eur":249.0},{"row_id":"79eaacf9-16e1-4c82-a596-9568a3e8302f","transaction_date":"2026-08-19","transaction_type":"BUY","asset_key":"NETFLIX","amount_eur":249.98},{"row_id":"20acff6d-3db9-4b29-948f-db6b0d7b6323","transaction_date":"2026-08-17","transaction_type":"BUY","asset_key":"ETF_QDVE_XETRA","amount_eur":100.0},{"row_id":"710df31c-d1bc-4057-b003-0d6a33ed3547","transaction_date":"2026-08-05","transaction_type":"CASH_IN","asset_key":null,"amount_eur":200.0},{"row_id":"d8b46382-f6b7-4c95-9c11-d33ded0541fd","transaction_date":"2026-08-04","transaction_type":"BUY","asset_key":"IONQ","amount_eur":100.0},{"row_id":"ed068efc-e023-4c5a-9886-54c22b60c3c5","transaction_date":"2026-08-04","transaction_type":"DIVIDEND","asset_key":"FREEPORT_MCMORAN","amount_eur":1.23},{"row_id":"af9b1060-24e1-46ef-aa42-20cfecf5283a","transaction_date":"2026-08-04","transaction_type":"BUY","asset_key":"RIO_TINTO","amount_eur":200.0},{"row_id":"2dc7d5da-35cc-45bb-a388-80f972a4ac6b","transaction_date":"2026-07-24","transaction_type":"SELL","asset_key":"UPS","amount_eur":229.56},{"row_id":"75d3aed4-8017-4e9e-bbbf-d7f5d52a0a6e","transaction_date":"2026-07-24","transaction_type":"SELL","asset_key":"SLB","amount_eur":334.14},{"row_id":"52e432ef-469b-4f71-af70-4951fe50e682","transaction_date":"2026-07-16","transaction_type":"BUY","asset_key":"ETF_QDVE_XETRA","amount_eur":100.0},{"row_id":"25a18151-5a99-41a3-892d-56f9fe1ca9eb","transaction_date":"2026-07-13","transaction_type":"DIVIDEND","asset_key":"ALTRIA","amount_eur":7.24},{"row_id":"a6a0eb8f-e5c4-424a-b457-62a5e0d31e67","transaction_date":"2026-07-12","transaction_type":"DIVIDEND","asset_key":"ALIBABA","amount_eur":1.84},{"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":"6a51ae97-02fa-4dec-b64b-1481dc65c669","transaction_date":"2026-07-10","transaction_type":"BUY","asset_key":"IONQ","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":"c57f1c39-7b7d-4f2b-a7ab-6776827010ec","transaction_date":"2026-07-09","transaction_type":"DIVIDEND","asset_key":"SLB","amount_eur":1.64},{"row_id":"09881541-95e9-4924-98f4-6488b96cfbbd","transaction_date":"2026-07-09","transaction_type":"DIVIDEND","asset_key":"CREDIT_AGRICOLE","amount_eur":0.74},{"row_id":"e2d5a213-08bc-43b5-a8bb-1b0e704e90c6","transaction_date":"2026-07-06","transaction_type":"CASH_IN","asset_key":null,"amount_eur":200.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":"7ddc98b3-62a2-40f8-b63b-6c7444364a84","transaction_date":"2026-06-26","transaction_type":"DIVIDEND","asset_key":"META","amount_eur":0.31},{"row_id":"c46aace2-dcba-4c3d-8b58-aa3ed5a3ff7b","transaction_date":"2026-06-25","transaction_type":"DIVIDEND","asset_key":"PAYPAL","amount_eur":0.79},{"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":"cd79b2bc-f703-463d-9d25-064306089f46","transaction_date":"2026-06-16","transaction_type":"DIVIDEND","asset_key":"ALPHABET_C","amount_eur":0.32},{"row_id":"716d06c3-b71f-4e70-8692-64fdf8128c01","transaction_date":"2026-06-16","transaction_type":"DIVIDEND","asset_key":"ALPHABET_A","amount_eur":0.32},{"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":"79e85c83-8ac4-4fb8-8fcb-a670034469f9","transaction_date":"2026-06-05","transaction_type":"CASH_IN","asset_key":null,"amount_eur":200.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":"124ebfb0-b0de-4b2e-8c01-6e94322473f0","transaction_date":"2026-06-04","transaction_type":"CASH_IN","asset_key":null,"amount_eur":103.0},{"row_id":"037c1f3b-3109-4ea0-8356-a973b3661383","transaction_date":"2026-06-02","transaction_type":"DIVIDEND","asset_key":"PAAS","amount_eur":1.44},{"row_id":"ecaf3887-57fb-4af2-9791-da1538f7d094","transaction_date":"2026-05-05","transaction_type":"CASH_IN","asset_key":null,"amount_eur":200.0},{"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":"e91624bb-5db9-4bc8-9af0-052f34689ebb","transaction_date":"2026-04-19","transaction_type":"CASH_IN","asset_key":null,"amount_eur":50.0},{"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}],"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":386.54}